Basically, where I'm at is that I have to move data from the source table to the destination table and I have to generate new identities for the rows being...

Thanks.  I do have a question though.  Does SQL Server implicitly use a cursor when it assigns a multirow resultset to a varchar?

For instance:

Select '<' + ElementName + '>' +...

David...

Thanks for the reply.  One more quick question.  Let's say I

• turn auto shrink off
• run a weekly script that 1) updates statistics and 2) DBCC DBREINDEX (in some fashion, maybe...