If I won the lottery, I would keep working where I am as long as they would have me (government contracting, funding is everything). If it was 200+ million prize,...

Another option is to test if the UpdatedBy column is updated by using the UPDATE() function in the trigger.  If it is, bypass the code that updates this column.  This...

The Colorado Springs SQL Server Users Group held its SQL Saturday this past Saturday (2017-03-25).  Our fearless SSC Leader was there and held two outstanding sessions (yes, I am kissing...

If you have the money there is Toad for SQL Server.  Been years since I last tried it and at that time it wasn't all that stable.  I did use...

It's fun when an OP deletes the contents of their original post.  Nice when the first response happens to quote it so you can still see it.

Does this help?  It is based on what I could find in other posts since your original post has been edited so that nothing is there.

/*

Maybe something like this, it removes all leading zeroes except where a value is all zeroes:

CREATE TABLE #Inventory(
  ItemNum nvarchar(400),
  action_desc varchar(100)
);

INSERT...