I don't believe you can embed a CASE statement within an INSERT.  I've never gotten it to work.

However, one possibility would be to create a UDF that takes the...

Thanks for all the responses.  I discovered the reason for my problem.  Using MDAC 2.6 RTM, there is a bug where the driver will ignore any authentication settings in the...

Our procedure has been working for us for several years.  I've worked here 4 years and haven't had any reports of locking issues with the SQL Server version of this procedure (we...

We have a very similar scenario. Our procedure that updates the 'xsequence' table does both the get value and the update in one statement.

 update serialno

  set @tmpSerno = serialno, serialno=serialno+1...

That worked!!

Thanks for your help!!

I still have the problem.  I can do the select statement, but the results are still displaying to the results pane..

Below is part of the code I'm running and the...

That works great! I used key_column_usage instead to pull in the ordinal position.

However.. Is there no way to do it using the stored procedures??

I'm just curious now..

I'd considered that, but I'd really rather not have to create another table or a temporary table to do this. Is there any other way?

I just use the objectproperty(object_id(),'ExecIsTriggerDisabled')

Returns a 1 if the trigger is disabled.

ie: select objectproperty(object_id('r_CLNUMCOPY_i'),'ExecIsTriggerDisabled')

Unfortunately, all the errorlog says is that it got a stop request from the Service Control Mgr. The cnfgsvr.out says that the service started successfully, the dbs created, and...