Thanks,Bill
Through a command:
'-- Never time outcmd.CommandTimeout = 0
'-- Set the parmscmd.Parameters.AddWithValue("@Parm1", 1).SqlDbType = SqlDbType.Int
'-- Set the command typecmd.CommandType = CommandType.StoredProcedure
'-- Execute the commandMe.ExecuteNonQuery(cmd)
Works great! Thanks a bunch. Oh...and the wait window...awefully nice feature!!
Now, I just need to work on getting that sproc to run faster than 90 seconds. It has several nested CASE statements that I think are gumming up the works. Not too sure how to simplify those conversions that are going on.
Happy Friday!Bill