Thanks Matt! This works great. On the live data I'm finding both methods are actually producing roughly the same speed results, which I found interesting. I am...

Jeff,

Here you go! Thanks for the tip. I've been struggling with how to get the results in here in a way that is representative of how they look....

I would like to but I can't seem to get the formatting correct to make it look good and be readable. If you run this to create a temp...

In case anyone is ever trying to do something similar, here is what I came up with for the actuals I was after.

SELECT cr.prediciton_date_startdate,

cr.prediction_date_enddate,

cr.actuals AS [1],

b2.[2],

b3.[3],

b4.[4],

b5.[5],

b6.[6],

b7.[7],

b8.[8],

b9.[9],

b10.[10],

b11.[11],

b12.[12],

b13.[13]

FROM #tmpactuals cr

CROSS APPLY(

SELECT [2]...

Realized I had more in the results than what you could get with the sample data. The results should be:

Columns: Row 1, Row 2

prediction_date_enddate 4/28/2007 0:00, 5/5/2007 0:00

Actuals Week...

I'll be gone for the holiday as well. Get some much needed relaxation and just be a kid with my kids.

Here is a new actuals table with 14 weeks...

Jason,

Way more than I expected to get out of the posting. Thank you very much. Now what I'm looking at is the actuals. The way the table...

Thanks Rajesh,

From your input and some others I ended up altering the stored proc to use an OUTPUT parameter. Here is the resulting proc:

CREATE PROCEDURE udsp_OutputOAErrorInfo

...

Yes I am, because my ultimate goal is to take that result along with some other information and write it to an error table so I have some audit information...

That's it! Thanks for the help while I had a momentary brain fart.

Thanks.  This works great.  Had to add some logic in to account for items that did not yet have an end_date but that was easy.  Just used ISNULL and assigned...

It has a key and I tried this but ended up with some strange results.  I should have gotten back 120 records per rep (24 records each for 5 mile_codes)...

I thought of this on the way to work this morning and realized the way I described what I wanted was incorrect.  If the data is sorted by DeltaT for each...

Thanks Gail.  I actually had changed to something like this late yesterday based on the advice of some other people as well.  Pretty much came up with the same thing...

I've been burned as well on the timeout issue and it seems that the times I forget the old [Ctrl-a][Ctrl-c] is when I get burned.