What does the SSMS version have to do with the question.

I mean it is a good question, requiring attention to detail but the SSMS version is totally unrelated.

It is clear that the  query change was an improvement but I suggest that some index work would make a dramatic improvement.

OP did not provide index or key...

Three different points.
A.) It is not the DBA's job to convince the CFO and that approach is ultimately doomed.  The DBA should be working with the database's business side...

Thanks Mike,  I second the postitive reactions and look forward to the followups.
I do have one suggestion/complaint.  My approach is to manually key in examples a bit at a...

hurricaneDBA (11/20/2016)

---

Our RTO is 5 days but they are using EMC backup so the dbs have to stay in full backup mode.

The issue I have is sharepoint has enabled...

This one sure generated a lot of discussion but I don't think (at least I did not see) that anyone addressed the actual code problem in the UDF the OP...

The algebraic hierarchy of operations is pretty clear here and the order followed. Everything to the right of the += will be executed prior to the addition of the...

The Range of a Small int is -32768 to 32767. This is an artifact of using 2's complement.

Your small demo is a great illustration of a serious problem many...

Steve Jones - SSC Editor (7/19/2016)

---

David.Poole (7/19/2016)

---

This situation destroys trust between IT and business people. The question "Why don't you know how to alter the system you wrote?" Is...

Eric M Russell (7/19/2016)

---

I was listening to a web developer talk about some fundamental changes in a web platform. In this case, an older system was being replaced completely with...

Hi Dave,

The first answer is your clue 🙂

Create a new procedure which calls the other procedures in the order you need them to execute.