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...

The problem sounds more like that you're storing your datetime in your table as a varchar, rather than a datetime. Is my guess correct?

Also "gives you an error";...