IMHO, this question does not really illustrate "the point that a subquery cannot be terminated with a semicolon". Semicolons terminate the statements and since the subquery is not the whole...

Jeff,

Thank you very much for your suggestions. You make a very good point about the iTVF, it is definitely more useful than the proc. In my defense about the tally,...

Jeff,

I would like to ask your opinion on the version of the split I recently wrote. It is implemented as a stored proc and does not have any limitation on...

Jeff Moden (7/2/2010)

---

BWAA-HAA!!!! First, this is NOT a good example of Tally Table code. It doesn't use a Tally Table and it doesn't use anything that could be...

What I mentioned in my post...

This is a very good question, thank you Ron. It really took some time to figure out correct answer. From your explanation:

Odd that running ISNUMERIC() against a space (ASCII 32)...

hrvoje.piasevoli (7/2/2010)

---

If I need to quickly disable all triggers in the database then I use disable trigger syntax to take care of all tables and views and then append disable...

This would...

This is a very good question, thank you. Presence of nullif does not change anything though, so it is difficult to figure out why it is there. What I mean...

This is a good basic question, thank you.

I also paused for a minute before answering trying to figure out what could be a possible reason for this table not to...

Trey Staker (6/14/2010)

---

Thanks for the question. I messed up and thought I read rows instead of columns. It kind of reminds me of the childhood riddle about if...

This is a very good question, thank you Ron. I answered incorrectly because I read columns as rows, the number of rows should be 2, so I got my answer...

Hugo Kornelis (6/11/2010)

---

Another problem I have is that this kind of questions call for psychic powers on our part. Others have already commented that it might have been a honest...

Very good question, thank you Jason! I answered it correctly because I remembered there was a discussion some time in the past on this site about the read_only nuances of...

Very good question, thank you Jason.

Creating a proc with name beginning with sp_ is very evil indeed. While there is a way to invoke the AdventureWorks' version of the proc...