"I still probably won't make the cut because I'm not an A-lister."

Says who?

Grant Fritchey (7/2/2010)

---

I'm not so sure about testing. The interview process where I work includes considerable time at the white board. We talk about queries & table structures & TSQL....

Hugo, thanks again for the excellent re-write and explanation.

Not sure why this one is tripping folks up, if you just count the delimiters, you can see it will return 13...

Anybody seen Barry lately? Republication of his '15 ways to lose your cursors' (gonna be singing Simon & Garfunkel in my head all friggin day now) made me wonder?

I absolutely think there should be testing, and I would gladly apply for any job that did so, not only to get a shot at it, but to find out...

lmu92 (6/28/2010)

---

Lynn Pettis (6/28/2010)

---

Here is why he couldn't change his call after seeing it in instant replay, he is bound by the same Laws of the Game as the players...

I totally agree with ALZDBA, your article makes me want to go play with the functionality; it's easy to understand for someone who doesn't know what the RG is, gives...

David, you have a couple of interesting points. To add to yours,

1 - if we're re-evaluating the CTE every time we do the loop, and we can't specify the order...

Get and read Tom LaRock's book, DBA Survivor[/url]. It will give you a 'ground up' view of what being a DBA means, and will help you decide if that's the...

Think this part is causing you issues:

-- prepare query

set @SqlCmd = 'select * into ##tempHTML1 from (' + @Query + ') as t1'

execute (@SqlCmd)

Try adding another parameter for @OrderBy, then...

Steve Jones - Editor (6/24/2010)

---

jcrawf02 (6/24/2010)

---

Don't know if you guys are fans of Statistical Analysis, but there's a proposal for a StackOverflow model on stats, still waiting for enough folks...

Don't know if you guys are fans of Statistical Analysis, but there's a proposal for a StackOverflow model on stats, still waiting for enough folks to commit to make it...

FWIW - we do just that here at work, although we don't have access to the reportserver tables (working on that, politics...). We write into our own table, capturing the...

Happy early birthday...

Tooltips automatically display for a short time when you put...