For which enumerator type are you interested in ?

http://msdn.microsoft.com/en-us/library/ms141724.aspx

I really think for such general issues, you will be better of goggling/binging.

Take a look at this blog http://sqlcat.com/technicalnotes/archive/2009/01/14/reporting-services-performance-optimizations.aspx from the sqlcat team , which should help you to tie down where the problem(s) lie.

This is expected behaviour , see example c here http://technet.microsoft.com/en-us/library/ms176057.aspx

Ok , i feel i provoked him , apologies for that.

http://www.sqlservercentral.com/Forums/FindPost1066189.aspx

Not exactly redeeming himself though.

Good catch, i was about to answer there.

Since your last thread went a little awry,

http://www.sqlservercentral.com/Forums/Topic984249-9-1.aspx

personally, im not inclined to help here.

Karma my friend.

Surprised that no one has mentioned using a calendar table so far.

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

Makes it all pretty simple.

Did you read the article ?

Big meeting on friday to best decide how to handover all my knowledge to co-workers.

First big change i need to do today is was told to make the change and...

Sounds like the order by condition is causing a sort which in turn is causing the writes as the rows are being spooled to tempdb so that the entire set...

Is it spooling or sorting ?

I suspect this is a homework question , is it ?

You will have to insert the results of the sp_executesql into a temp table and test against that.

Rather than guess, what error does it give ?

True cursors are slow but this looping is no better.

http://bradsruminations.blogspot.com/2010/05/truth-about-cursors-part-1.html

Results To Grid,

R-Click - Save As....

Should do you