Thanks for all your replies.

I agree that $150,000 is an obscene amount of money (unless someone wants to pay me that for a job) and it does include a lot...

Have a look at this post to see another way of stepping through a record set:

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=11057

Jeremy

Frank,

I've only just spotted your quote from BOL which answers the question.

Thanks.

Jeremy

Frank,

I have a temporary table which is populated from several stored procedures/UDFs and is ultimately returned to the client app.

I currenly have a UDF which returns the owner's name ...

It's an idea but if I'm going to all that trouble I might as well return a table.

Jeremy

ASE - Ask Someone Else.

Jeremy

There is no simple way of doing this within a stored procedure as the second procedure is nested within the first and the first will not continue until the second...

Good practice would be to split the job up into a number of smaller jobs.

There are a number of problems updating 40 million rows in one statement. ...

I've found an answer to this. I wasn't setting up the Task Collection properly.

Jeremy

Just a thought - why not use bigint?

It holds -2^63 through 2^63-1 and storage size is ony 8 bytes?

Jeremy

I think I have solved the problem.

I had a workflow script for the task which I have taken out and put into a separate Active X task and it now...

Duh.

Clicking on the wrong bit.

Thanks. I thought it must be simple but wasn't sure where to look.

One further question. What answer does objectfilegroup give when the index and the table are on...

Have a look at this link: http://www.sqlservercentral.com/faq/viewfaqanswer.asp?categoryid=3&faqid=138

It should give you some ideas.

Jeremy

Each connection will create its own version of the temporary table. Otherwise, if two users were connected at the same time they would interfer with each other.

If you create...