sqlusers (10/5/2010)
Phil Parkin (10/5/2010)
Why does your data source contain a WHILE loop?Actually, i need to get the data's according to From and To Date from a table. So for that i used this while loop.
Even i used NOCOUNT ON. But sorry i didn't get the columns yet.
Why not a WHERE clause? Sounds like you're getting the records one at a time?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.