You need to run

EXEC sp_rename

and remove the ''GO'.  That is a batch separator so your IF is technically in a different piece of code from your ELSE.

If I remember rightly it's something to do with execution plans that use temp tables but don't take my word for that.

This post helped me in a similar situation.  There might be a couple of other things you need to do but that was a good place to start.

Sometimes a loop is the best way to do something.  Doing something iteratively can be one of those times.  Have you tested the performance of a loop? Do you know...

Stopped gigging a while back, now it is only for my personal pleasure (read: when no one else is at home)

Same here, it's one of the disadvantages to the 9-5...

Some of the special Jacks are much better.  I don't think they're...

OK, so I'm curious and interested in expanding my repertoire when it comes to liquor...

Whiskey / whisky vs scotch, and, what's so bad about Jack D?

(Note, I've only...

Haggis is great though! Haven't had it in ages mind, but I've enjoyed it every time I have. In...

Careful with that 'e' there Mike.  It's normally 'whisky' you have with haggis.

I'm planning on doing another belly this summer when I do 2 pork shoulders and 6 chickens for my daughter's grad party.  She's undecided on the smoked macaroni and cheese. ...

The one time I met Grant in person, we chatted about...

The question asks for text mode, rb will open the file in binary mode.

SELECT DATEADD(SECOND,1575944000000/1000,'1970-01-01 00:00:00.000')

Does this work?

I think the problem is that it is needed serialized update (order by Eff_Date) and some kind of recursive (The first line should updated 4 times using this flow: "Person...

If you're after 36 individual matrices a loop may indeed be the way to go.  However, you can't just create loop to execute a SELECT statement with 36 different values,...