Heh... I agree, Michael... there's always that. 😛

GilaMonster (7/11/2008)

---

Jeff Moden (7/11/2008)

---

Heh... I had the feeling you'd say that... I think all of that is more for formatting for folks that can't get over the 19000101 meaningless date...

Heh... they already have one! It's called the DATETIME datatype! What they really need is just a simpler way of formatting and they need to allow for the...

If you're talking about RBAR update/select pairs, that's just a bad programming practice... between the proprietary UPDATE SET @variable = columnname = expression and the OUTPUT clause available in 2005,...

That's all well and good... I guess people who are unaware could use the help of the Date and Time datatypes. What I'm waiting for is the people who...

Of course your CLR function is going to beat the T-SQL function... you used RBAR on steriods... you need to test against a correctly written T-SQL function for this to...

Why on Earth would you put a single SELECT in an explicit transaction???

GSquared (7/11/2008)

---

And now I know that you've seen "Harvey". And you know that I know that you've seen it. And I know that you know that I know...

GilaMonster (7/11/2008)

---

A time table - Physics 101, Lecture room 2B, 9am every monday.

Movie schedules. Movie X shows every day this week at 17:00, 20:30 and 23:00

A store list with their...

There is a method for this in Books Online called "expanding hierarchies"... it has about the same amout of RBAR as a recursive subquery (recursive subqueries are not set based...

First, let me suggest a minor correction to your code... First, try this... (your original code with a twist on the data)...

[font="Courier New"]DECLARE @OutString NVARCHAR(MAX)

SELECT @OutString = ISNULL(@OutString, '') +...

It's probably because I've not had enough coffee this morning, yet... :hehe: can you tell me...

Leo Mepham (7/10/2008)

---

Jeff, I work with TSQL all day long, and I do read & enjoy your pieces on here - But I don't see that you've solved his problem?...

Sorry... I just couldn't imagine why anyone would want a dynamic solution for this... now I see one (pass multiple different CSR parameter lists back to a GUI). Still,...

GSquared (7/10/2008)

---

No. Actually you are completely alone. The rest of us are just paranoid delusions. (By the way, the fact that you have imaginary friends as twisted...