Check the placement of your OUTPUT clause, and compare to https://docs.microsoft.com/en-us/sql/t-sql/queries/update-transact-sql.

OUTPUT goes after SET and before FROM.

Cheers!

EDIT: Darn, beaten to it yet again. I'm...

The query forms suggested by Chris and J are the way to go for this.

Just to explain the results you were seeing, the join criteria don't make any...

Rebuilding an index updates that index's statistics with the equivalent of FULLSCAN, so you won't want to update the rebuilt index's statistics, since you'll be duplicating work (that's at best;...

Ok, so obligatory disclaimer: the order of attributes (columns) should not hold any significance. I point that out because of your desire to shift values "left".

At any rate,...

As an alternative, if you really just want the 1 row with the lowest code, then you could use TOP 1...ORDER BY CODE ASC

Cheers!

My best guess is that you're running the query from a database with a case-sensitive collation.

Switch to all lower-case for the object name and/or check the collation for...

It doesn't have to be all that painful.

For the table definitions, you can just right-click and script the definitions out from SSMS.

For the data (can also...

Thanks for the effort, but that actually isn't quite what we need (right technique, but wrong content).

We will need the structure of the underlying tables used by the...

As others have pointed out, there are no connections to tables; the information requested simply cannot be provided. 

You mentioned this is a request from one of your clients.

You have me curious, Ed. 🙂

Having said that, it looks like the main difference is the ratio of Jacob #1 to the others that is different in your...