It almost sounds like there are triggers in addition to the routines you describe. Any chance of that?

Guarddata-

The only thing I can imagine is to have the interface determine the combination in question and query for that specific number. I don't know if you have that...

OK - in your example it appears that you know what column1 is...for the sake of this example, we will call it VARCHAR(50)

CREATE PROCEDURE myProc ( @tempTable VARCHAR(50) ) AS

...

I suppose it depends on the maintenace scripts as well. If the index were to be used by a single script, the command could just be part of the...

A real low-tech way would be similar to the method mentioned by stax68. Create a stored procedure to do the work. Set it as a job to run...

Yeah - good enhancement in SQL 7, no? To the best of my knowledge, the only way in 6.5 was to copy the data to a new structure without...

If the @result datatype is known, you can do something like:

SET @sql = N'SELECT @result = column1 from ' + @temptable,

@paramDef = N'@result INT OUTPUT'

exec sp_executesql @sql, @paramDef, @result...

We generally (sometimes under protest by all) go through the pain of writing specific statements for each option when:

a) Performance is the highest priority

b) There is a limited...

CSDunn,

Remember to check that the field you are updating has changed. Perhaps on the EXISTS clause add the criteria of DL.Updated <> SB.Updated

Guarddata

Some observations:

1a) Rollback tran affects all active transactions. The commit is meaningless because the only transaction has just been rolled back.

1b) Code works with the save point because the...

I don't know how much of the problem is solved in the enterprise version. We didn't have that option and finally resorted to using a middle tier to address...

I would try changing the startup to be <domain>/SQLUSER. Make sure this connection has rights to the email feature. This would allow you to "log on" and perform...

Not to mention the fact that the view is reusable. The query has to be rewritten many times.

Also - for use by third party products (Crystal Reports, etc.) the...

It would be interesting to review the code of your trigger. You are probably already doing this but the code needs to be very specific in determining to make...

Outer joins have occasionally caught me off-guard. When the test data didn't have the same join condition as the full set, it was hard to catch the error in...