I think (before there is some serious bloodletting here), that perhaps what M$ needs to do is update the documentation so that it matches the functionality that was inherited/borrowed/etc from...

I suppose we'd have to ask the folks at Sybase why it was done that way. In the mean time, don't believe all the Sybase doc for what happens with...

jeff.mason (5/17/2011)"Unknown" is not nothing. In standard database calculation, NULL touching anything makes it NULL. There is no argument I can think of to support this activity on...

I'm going to play devil's advocate here (like MS needs any help...). In my copy of online help the...

At the risk of exposing how much I might not know, why all the alter statements changing fields from tinyint to int, as well as NOT NULL? I would assume...

@hugo,

I am quite sure that on Friday when this question first appeared that the nvarchar definition was on the web site as well as the email (which of...

Ernie Schlangen (4/11/2011)

---

The really sad thing is that this is not all that uncommon an occurrence but if any of the questions are corrected and/or the persons with the actual...

As one of the 40% who got this wrong (and learned from it) I'd say there are several advantages to a procedure like this:

1. It's great for problem solving. If...

The biggest issue I've seen with reports is the merging of cells. This usually happens if I have multiple tablixes on the same page that would export to being in...

I'll have to hang on to this. While I've not needed to rerun everything, on occasion I've needed to rerun some stuff. Your code will give me a good starting...

No problem and no offense meant. As noted, it's an entertaining little item and it was nice to look for the "Gotcha" in the script.

It should be noted that no matter what value is passed into the procedure, you will always get 10 "words" (language to be determined) from this procedure.

select @i=0

...

while @i<10

...

set...

Thank you much for the explanation and for taking the time to write it up.

Bob

I don't mind being wrong (heck, if I were right all the time...) but it does mystify me a bit that the HAVING clause empties the result set. I selected...

ChrisM@home (2/12/2010)

---

Dupe = ROW_NUMBER() OVER(PARTITION BY Col1 Col2 Col3 Col4 Col5 Col6 ORDER BY Col1 Col2 Col3 Col4 Col5 Col6 Col7)

If you set up your sample as a CREATE...