Alvin Ramard (7/31/2015)

---

Luis Cazares (7/31/2015)

---

That wasn't the only attempt on that day. Here's a completely lost Oracle user.

But hey, as long as...

Superfluous additional exclamatory congratulations, Gail!

But for some strange reason this is unsurprising.

There are better ways to include column names with output. I don't know of any other system that handles column names the way that view does. ...

Just saw your last post. Why on earth are you trying to put text for column headers at the front of your actual data?

Of course "Call...

It may be that some of the values in your table do not represent valid dates.

If you try to convert to datetime and any row has a bad value...

I inherited a large EAV (TRANSLATE_CODE_VALUE) that contained descriptions matched to a series of single-character codes across dozens of columns in several primary tables. The schema...

Brian J. Parker (6/5/2015)

---

This is completely branching off the topic of the original article, but... I've grown accustomed to instantiating a Tally table whenever possible in any database I work...

No argument with the statement that cursors are acceptable where row by row processing can't be avoided. The reason relative newcomers to SQL are warned away from...

Eric M Russell (5/18/2015)

---

Real...

Um... guys... did you look at when this thread started. Your advice is about 5 years too late 😉

Dangit, I read all the way down thinking about the VALUES clause and you beat me to it.

Miskatonic alumni often are.

I agree with EMarkM that 99.99% of the time its a mistake to force use of an index. Not to be unkind, but the optimizer knows what...

When you do a left join or a right join or a full outer join or an outer APPLY, unmatched rows return NULL values. Use the...

Wow.... five years...

Here is a quick example of a Calendar table. If you will search this site under the words "Calendar Table" you will...