I don't know of any way to do this with multiple columns in a single row.... but this seems like an easy one for a child table where SQL performs...

Ahhh- you are, of course, correct rdfoxx. This delete does delete them all in the first execution. In my rush, I was treating this the same as an...

Seems like one of the issues relating to the SELECT ought to be a combination of the number of rows and the complexity of the WHERE statement. If there...

Sorry for the slow response, StefanJ. I am sure you have figured this out already. Since the delete occurs, those original 1000 entries are no longer in the...

Here is a quick sample of something that might work for you - it can be adjusted however you need. Hope it helps.

Guarddata-

--DROP table sqlReady

create table sqlReady (

cmdID...

For clarification - I assume this means that @@servername returns the cluster name instead of the server name?

Guarddata-

We have found that, if you are not using distributed transactions, there is no need to use SET XACT_ABORT ON when you are using the BEGIN TRANSACTION. Makes it...

Yep - makes sense. I really don't think there is any problem storing the query as long as they can properly call the stored procedure. The burden is...

Yeah - but BOL doesn't admit that the update happens *eventually* after a series of queries have been run.

Glad it made a difference.

Guarddata-

Arthur, The submission process would need to have the ability to assure a properly formed argument. Is the interface a web page using an ADO object? Is...

My quess would be that you had all the data before creating the index. Try UPDATE STATISTICS [Detail] and see if it makes any difference.

Guarddata-

Sounds like the email account is not set up correctly on that machine. Can you log in as the network user used by SQL agent and send a message...

It almost sounds like you just want

SELECT DISTINCT * FROM ralph

Could you please explain more?

Guarddata-

This message is not a failure within the procedure but during the call to it. An entry for @orgCode must be supplied unless you put a default value in...

Greg, For all practical purposes, that routine will work. However, it will not work in every case. Simple example: if you just used two replace commands (spaces...