A stored procedure

Hello!
Could anyone help me with this stored procedure...!?
Table Cars:
-Id
-Model
-Make
-Year
...
Table PriceList
-Id
-CarId
-Price
...
I would like to select all fields from "Cars" and only MIN(Price) from
"PriceList" WHERE Cars.Id = PriceList.CarId. and join them into a single
result set.
Thanks!
JamesHello,
Try with
SELECT id, Model, Make, Year, (SELECT MIN(Price) FROM PriceList WHERE CarId
= c.Id)
FROM Cars c
Regards,
Tomislav Kralj
"James T." <gimenei@.hotmail.com> wrote in message
news:uSyVIOUKFHA.572@.tk2msftngp13.phx.gbl...
> Hello!
> Could anyone help me with this stored procedure...!?
> Table Cars:
> -Id
> -Model
> -Make
> -Year
> ...
> Table PriceList
> -Id
> -CarId
> -Price
> ...
> I would like to select all fields from "Cars" and only MIN(Price) from
> "PriceList" WHERE Cars.Id = PriceList.CarId. and join them into a single
> result set.
> Thanks!
> James
>

A question about Log Shipping

If I switching recovery model from Full to Bulk-Logged, will the log
shipping break?
Thanks
LijunHi Lijun,
IMO, it should work eventhough I haven't tried this yet. Log-shipping
criteria is that the database partcipating in log-shipping should be either
in full or bulk-logged recovery mode.
Thanks
Yogish

A question about Log Shipping

If I switching recovery model from Full to Bulk-Logged, will the log
shipping break?
Thanks
Lijun
Hi Lijun,
IMO, it should work eventhough I haven't tried this yet. Log-shipping
criteria is that the database partcipating in log-shipping should be either
in full or bulk-logged recovery mode.
Thanks
Yogish

A question about Log Shipping

If I switching recovery model from Full to Bulk-Logged, will the log
shipping break?
Thanks
LijunHi Lijun,
IMO, it should work eventhough I haven't tried this yet. Log-shipping
criteria is that the database partcipating in log-shipping should be either
in full or bulk-logged recovery mode.
--
Thanks
Yogish

a key time as a split variable in Microsoft Time Series?

Hello,

I was working with Microsoft Time Series model (MTS) with some data, when in the mining model viewer, decision tree tab, I realized that the key time variable that I define, it was acting like a split variable.

So, I ask you, this is possible?, because, for me, this should not happen….

After, I review the Data Mining Tutorial by Seth Paul, Jamie MacLennan, Zhaohui Tang and Scott Oveson, and I found, in the Forecasting part, that the key time variable (Time Index) it was acting like a split variable too, in for example, M200 pacific:Quantity and R250 Europe:Quantity.

So people, it’s possible that a key time variable act like a split variable in a MTS model?

Thanks

This is by design. Imagine you have a series that behaves in a certain manner, then at some time, the behavior changes radically - possibly due to some external event not captured in your data. Since the Time Series prediction always occurs in the future, splitting on time allows us to isolate and describe that past behavior without averaging out that behavior into your current predictions. If your series was mostly increasing or decreasing, this would manifest itself naturally in a split like (t-2)>70, however, if your series is mostly stationary, such a split wouldn't make sense.

The implementation is that we add a monotonically increasing series that is only used as a split candidate and not as a regression candidate.