All DELETES require locks, but keep in mind that deleting a large group of rows does not always mean that your whole table will be locked.  SQL Server will determine...

Pros:  Your server guys will not need to dedicate you a stand alone server.

Cons: Keep in mind that your Virtual Server will be sharing physical resources with other Virtual Servers. ...

DECLARE @Insert int,

    @EndString int

SELECT @Insert = CHARINDEX('e',Anystring) FROM Test

SELECT @EndString = (LEN(Anystring) - @Insert) FROM Test

UPDATE Test

SET Anystring = SUBSTRING(Anystring,1,@Insert) + '1234' + SUBSTRING(Anystring,(@Insert + 1),@EndString)

FROM Test

SELECT Anystring

FROM Test

Your answer lies in the phrase 'result sets'.  A result set is the dataset returned as the result of a DML statement.  To get multiple result sets, you must run...

It would help if you could post your table DDL.

As far as performance goes, its hard to say what kind of gain, if any, you will get with this query without knowing more about your database/environment.  But here is...

I could be mistaken, but I think you need to reinstall SQL Server to change license modes. 

Yes, that is what I am asking.  So, if I'm hearing you correctly, you run this query go SELECT your data into variables and then you call the INSERT stored...

Odds are, it is not due to the memory consumption.  Most of that memory, as R2ro said, will be used for buffer cache.  This is where your recent data pages will...

As things stand, your stored procedure is already setup to accept in all of the column values that you need for your INSERT statement.  You've got 2 choices here:

1.  Whereever...

"I'm not at all familiar with coding looping structures within SQL Server 2000."

Consider yourself lucky!!  Most people are TOO familiar with looping structures.  Anyway, you say that you need to...

Run this through QA, output to File.  Open the file in QA and run.  Or, output to text and cut/paste into new QA window and run.

set nocount on

SELECT 'CREATE TABLE...

I think I fell asleep at the wheel on this one.  The solution in my previous post has flaws.  Back to the drawing board.

This appears to be more than just your normal self-join.  In fact, I can not find a way to do this one without use of a temp table.  Maybe some...

It looks like you have 3 sessions with that specific creative ID.  Am I mistaken?