What does the window's error log say?

Please do not cross-post, we monitor all boards.

Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=20&messageid=214013

Union all doesn't have to do the distinct... distinct implies comparaison and that takes data types compatibility, which you get by converting .

You got that right .

Looks like I got to open up BOL for this one .

Just throwing ideas around...

Can it be connection pooling?

Or yourself not closing a connection somewhere (EM, QA, APP)

Cool, we have a replacement for Sushila's comments .

BTW, the version I did is NOT the equivalent of BETWEEN (note the < instead of <=).

There's a older headlines link on the main page. You can browse them that way.

That's why it fails... just use the variables directly >>

where CTimeStamp >= @DateFrom and CTimeStamp < @AddedDateTo

My solution is not too bad but yours can be better. The join can take up a lot of ressource. Even with only 5000 rows in the resultset,...

What query are you using to get the data?

How are you displaying the data on the excell sheet?

I don't understand the logic of this query.. can you dummy it up a little more?

Are CTimeStamp and the Variables of type DateTime??

HTH.