OK, I just have the one that...

SQLKnowItAll (2/2/2012)

---

My guess is that the OP is trying to save an SSIS script generated using SSMS import/export wizard, not BIDS. Am I correct? If I am, which options...

I can't save it, it won't let me

Also,...

TOP: CPU time = 1281 ms, elapsed time = 7777 ms, logical reads 223933 (ORDER_ITEM_DIM)

ROW_NUMBER: CPU time = 2000 ms, elapsed time = 15948 ms, logical reads 303216 (ORDER_ITEM_DIM)

TOP is...

I can use that, for sure, but it changes nothing really. Similar I/O counts and CPU time actually goes up. I'm attaching the plans for the two versions:

cross...

OK -- I get that now. So I added:

where rn=1 (so it would be included)

and removed the top 1, so I now looks like:

select nco.*, nci.ORDER_ITEM_ID o2

From OR_NCCore.dbo.Order_Dim...

Thanks for the insights! I have a question about your comment about the rn doing nothing though. My hope was that it would force the windowing so that...

OK , I've attached the two execution plans. Recall that I do a similar query two ways: 1 with join and one with cross apply. The produce identical results....

Hmmm.... replacing Having with Top 1...order by causes it to return Nulls for the max() for some rows -- not what I want. Here are the execution plans (couldn't...

I've been learning CROSS APPLY lately and found some interesting things. I have a query that can easily be written as a JOIN (Sorry, it seems my indentation is...