From a hardware perspective as long as I have reasonable processing power on my laptop(retail mine is less $400 and works fine i'm also sure my company got some kind...

Heh.. you posted this in the 2012 forum as well, i though i responded there.  It looks like there's an answer there that'll work in 2008 as well.

What about this?

select id ,Doctype, [DocName] , min(priority) PRIO,max(startdate) STDT , LAST_DOC.LAST_DOC
from #t
CROSS APPLY(
SELECT LAST_VALUE(FinalDOC) OVER(PARTITION BY id,Doctype, [DocName] ORDER BY [priority]...

I would not put up my personal money for anything outside of maybe incidental costs like food, anything like hotels, plane tickets, software trials etc..... should be put on a...

Wwhat about this?

WITH TEMP_CTE AS(
SELECT ID, ProductCode, Quantity - 1 AS Quantity FROM Test
UNION ALL
SELECT ID, ProductCode, Quantity - 1 FROM...

You should be able to take this out altogether.

WHERE Invoice.InvoiceDate BETWEEN @StartDate AND DATEADD(MS, -1, DATEADD(D, 1, CONVERT(DATETIME2, @EndDate)))

Your temp table already controls the filtering as it's already populated with the date range you...