The thing that disheartened me the most about the Sarbanes-Oxley act was that the very same companies that caused the crisis (eg. Enron's auditors) were able to make vast sums...

One advantage of casting 1 and 0 to bit is that some UIs will default to displaying these as True/False or ticked/unticked without any special coding.

There's a good reason most TV programmes are around the 50-55 minute mark (even on the BBC which doesn't stop for adverts every few minutes) - that's probably the length...

Thanks all. I have some things to try once I have write access to a development copy of the database.

Is it possible that LGTC_ShipmentsClaims is empty (or at least contains no matching rows) at the time your stored procedure is run?

Here's the next key table.
create table SEQ_SYSTEMKEY
  (LASTKEY int null) on [PRIMARY];

and here's the current stored procedure.
create procedure nextSID
as
 ...

The code in the sproc just does an update of column Last_Key on the one row in that table and returns the new value. That's not a real sequence is...

Thanks, but I don't think I can amend the 3rd party procedure and I'm not sure this is significantly different from updating the table directly with +1 +@NumSids. With either...