nancy.lytle (8/29/2008)

---

Hugo, about your code:

SET @ComplaintList = ''

SELECT @ComplaintList = @ComplaintList+ UserComplaint+ char(13)

FROM ComplaintsTable

WHERE UserID=@UserID

..

Return @ComplaintList

I thought that might be something I could use for various things, but...

shnizzle (8/29/2008)

---

Hugo, I read the KB article and even when taking it into account, I think that my code is correct - it looks exactly as the statement described...

Jeff Moden (8/29/2008)

---

Hugo Kornelis (8/29/2008)

---

On second look - the string concatenation technique used to piece the bits back together is undocumented, and might cause unexpected results. Not good for production...

shnizzle (8/29/2008)

---

Hugo, is it not documented or documented as not defined? This code reminded me of a function I use that operates on the same principle in order to concatenate...

shnizzle (8/29/2008)

---

Since isnull(@var,1)=1 then the following code should be equivalent to the original:

Declare @var int

Select @var = 1+ Value1

From (Select 1 Value1 Union All Select 1 Union All...

The article presents a nice example of a possible use for a new technique - but unfortunately, the choice of examples is a bit bad.

I think every advanced SQL Server...

thomas.lamp (8/6/2008)

---

The tally table is wonderful -- thought I'd post another use I'm getting from it: finding a minimum numeric record key within a potentially gapping set.

So my TableWithManualKey table...

hodgy (8/4/2008)

---

I enjoyed this question (even though the clause is being phased out!) as it was something I wasn't aware of, and it made me go off and research the...

Hi Jeff,

Just as I appreciate...

Jeff Moden (7/24/2008)

---

Hi Hugo,

Do you have an example of when...

Christian Buettner (7/24/2008)

---

This is a misunderstanding. What I meant to say was that when you open a static cursor, you have a point in time copy of the data as...

Gianluca Sartori (7/24/2008)

---

I agree that this question was a bit confusing. I would never have chosen the "right" answer just because this is not any way to update the cursor,...

Christian Buettner (7/24/2008)

---

I find this question a little confusing. It should be clearly stated in the question that you do not need to see updates made to the underlying data....

brewmanz (7/24/2008)

---

I used the following extract from BOL

(...)

Was it a fluke, or is it some indirect help from BOL? Or maybe direct help - cursors are a bit of a...

There's a HUGE difference between "Allows the owner of another table to use columns in the table to which they've been granted that permission" (the supposedly "correct" answer to this...