TomThomson (11/5/2014)

---

Good question.

I was careless, and ignored the implicit conversion of ((RAND() * 10) + 1) to int; since implicit conversion to int rounds towards 0 in SQL,...

I worked for several years in a one person shop. I still put comments in the code, ESPECIALLY little utility snippets. If I can't tell what the code was supposed...

Thanks for the question Tom. It shows quite clearly why serious consideration should be given to avoid the combo declare/set syntax.

Excellent question. Loved the text explaining the things you weren't trying to trick us with. 😉

When I worked at Intel In the mid-90's, we were growing so fast that a universal system couldn't handle the needs of the local groups fast enough. So, we had...

Koen, are you doing something different with your hair? (He said, noticing something strange about Koen's icon.)

(Later realizing that he was mistaken, as he was thinking...

Toreador (8/6/2014)

---

TomThomson (8/6/2014)if I want put many column names into for example a select list using an SP to generate a complete list (which I can then prune) is faster...

Although many found it easy, quite a few have missed it. I'm happy with the two points.

Thanks for the question Hugo.

No need to protest. I'll take the extra three points you don't want....

Thanks for question! Easy but still had to think about it. Please post another QOTD.

Why would I use the method in the question when, as the answer showed, I can use:

SELECT *

FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS

Hugo Kornelis (7/30/2014)

---

See...

Good question for me as I had to do some investigate to confirm the answer. Thanks free mascot!

I agree with those that favor a date table. This has the advantage of removing most of the date manipulation code from SP's -> easier to maintain.

Nice, and not so easy for me that I didn't have to think, but still easy enough for a Monday. And brought up an interesting point or two. Thanks Steve.