Looks like your months are ordering, alphabetically. You need to set your ordering by month number, not name.

Ok, let's start with why this is failing. You're setting the SET INSERT IDENTITY ON before the table exists. This isn't going to work, as there's no table to chaneg...

I think you've missed everyone's point here. Our point is that your need isn't for answers, you need to learn, which you aren't doing.

I see someone in need...

Most likely your charindex is returning a value of 0, and thus erroring. For example, if FULLNAME contained a value of 'Thom', charindex(',', U.FULLNAME) would return a value...

Personally I found answering questions here really helpful. I'm not going to pretend I have anywhere near the level of expertise, or experience (I'm probably quite a few years younger...

I believe that they honestly think they are paid to get answers from the internet, rather they learn and think for themselves... https://www.sqlservercentral.com/Forums/FindPost1871266.aspx

Perhaps:
UPDATE [master]
SET checkin ='N'
OUTPUT inserted.* --You may need to adjust the * to the correct Column names if your tables do not exactly match

Duplicate of post https://www.sqlservercentral.com/Forums/1871233/Transactional-Replication-issue

You do also realise that the above SQL is only going to update 1 account right? You can't assign multiple values to a variable, but that seems to be what...

Could you post some sample data which shows the problem (CREATE, INSERT, SELECT statements). Also, I can't see the column ORDERDATEANDTIME in your original query, only ORDERDATE?

On a...