Oh I've read it. Years ago as well as quite a bit of arguments made after that as recently as this decade. The original piece if I am correct was...

In regards to the article about "Go To Statement Considered Harmful," WOW. If technology hasn't gotten any better since 1980's, I'll go back to my old job. Wait, that job...

Out of curiosity, have you ever created a job in SQL Server with multiple steps and tell it what to do upon failure? If so, then you've used GOTO. GOTO's...

In regards to the below, perhaps you should go work for the microsoft sql server team as GOTO is not uncommon in TSQL. 🙂

"The GOTO should always be one...

Why not try GOTO Step#. You can find it on BOL. I had to write something recently and it worked like a charm.

Example

If A = B

BEGIN

...

I am guessing that you have the contract contact person in a table somewhere that can be tied back to contracts. (ie email address and name of person). If so,...

Out of curiousity, are they dba's, sql developers, application developers? I work in a small shop so unfortunately and run into this same thing from time to time despite all...

I guess the first question I have is, why make the changes at the subscriber? In short, the way replication works (since you are not using updating subscriptions) is based...

Does anyone know where all this negativity came from about cursors? All I've read about this year are articles saying get away from cursors, "Very Bad" for your production environment....

I agree with Jack. I should of mentioned that part about scripting out the current table. Good catch Jack.

There is a way to change your timeout but have you tried to do a bulk insert into a new table (where the data types are updated)? Once the insert...