Select query

Question

Viewing 2 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Cadavre SSC-Forever Points: 41690 More actions · Answer 1

p.ravirao (7/14/2010)
Thanks!
When i am modifying your query like below. I am getting zero rows.

There's no data in the table variable that you've created there, so it will return zero rows.

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

p.ravirao SSC-Addicted Points: 400 More actions · Answer 2

SSC-Addicted

Points: 400

July 14, 2010 at 6:17 am

Thanks!. I got it.I got the results .