Hi Gail Shaw, The server which i refer to is sql 2000. i don't find an option to save execution plan. Let me read the article about parameter sniffing which...

Thanks again for the reply,

I am testing it as query now, eventually i'll have to put this part into a stored procedure

I agree with you Join practice and the...

datatype of coldate is datetime,

there is no difference in the execution plan of both queries.

Thanks Eugene Elutin for that date format practice .. old habits hard to change .....

.

Thanks a lot.. 🙂

Hi ,

It worked when i tried to export to excel. though.csv didn work. excel understand char(10) 🙂

Thanks

Jeyis

Thanks for the reply Koen. This one got resolved today. Issue was with the sql server agent's Services login ID and not with the 32-64 bit. previously I was getting...

thanks for the reply Koen, Server is 32 bit.