Is there an "On Error Resume Next" command? I am creating these procedures that bomb out when they encounter an error and I need to do some clean up...

I just ran your code and it worked for me but I have had the same types of problems when you do things with enterprise manager. Try building the...

I believe that everything (especially in SQL) is an option. Write and re-write the same procedure as many ways as you can think of and test it for speed....

Alright, thanks for the advice.

The scripting objects utility in Enterprise Manager? Yea, that was our last resort, we just wanted to attempt it this way. You know, something different that might come...

Out of curiosity, why do you turn nocount off again before the select statement. I have been using the SET NOCOUNT ON in all my procedures but I never...

Try it after the table name.

USE NORTHWIND

SELECT EmployeeID

FROM Employees WITH (NOLOCK)

WHERE EMPLOYEEID = 4

The value '03/03/2003' is interpreted as midnight. So if you are passing this into a stored procedure use

when_dt >= @Date and when_dt < @Date + 1

(or use...

Have you tried:

Select ColumnA, ColumnB from TableA where ColumnB NOT IN (Select ColumnC from TableB where ColumnD = "Value1")

and ColumnA = "Value2"

When you put a leading zero on the number it isn't a number anymore. Here is what I do.

DECLARE @YourNumber INTEGER

SET @YourNumber = 1

SELECT RIGHT('00' + CONVERT(VARCHAR, @YourNumber), 2)

...

Out of personal preference I try not to EVER write cursors unless they are absolutely necessary. I read somewhere about how SQL is a set based language and you...

Guard, you used the set and select both in your loop. Not sure if it makes too much of a difference but I tried this.

declare @iLoop integer

declare @stTime datetime

SELECT...

Ok, it is fixed. Our DBA killed the instance of the Sybase Engine running on the machine and it started back up when he tried to connect again allowing...

What I don't understand is that it was working for a while. Enough time for me to build all these procedures to feed it and then right before it...

Isn't that the only thing Excel is good for? 🙂