Thanks for your response

Reluctantly I used a cursor at the firm request of the lead programmer - this process runs mostly in the background (no user impatiently waiting for it...

Isn't there a facility to schedule a job in SQL Server 2005? That way the timing of the job could be taken care of and the logic simplified.

I got my Bachelors Degree in my late teens early 20's because well that was what was expected of me. Having wealthy parents and going to college in the...

I don't immediately see the problem - the MAX and MIN functions return a single value, right? but I would highlight and run each in turn and see if...

they don't shoot newbies here, they help them

I'm one too

according to the MSDN library, create a BindingSource, point it to a DataTable (your dataset.Tables(0) will do quite nicely) and then...

I changed the TABLE variables to temp tables and added a With RECOMPILE option - that helped a lot

thanks one and all

thanks one and all

it's even more complicated - there are also 3 options

return all the data OR

return data with null counts OR

...