I took another look at the non-question. Seems to be a glitch in the forum software.... I just posted this reply:

= = = = = = = =...

Somehow the text of the original question doesn't show up in the main post, but I was able to copy it from the annotation seen in the topic in the...

Am tempted to reply to the non-question with just:

But that may be too obscure.

David Walker-278941 (9/23/2009)

---

Tao Klerks (9/23/2009)

---

David Walker-278941 (9/23/2009)

---

Yes, but I'm not forgiving of superfluous apostrophes in the word "its". The sentence gets a Fail. "It's" means "it is" and...

Hugo,

Thank you for this gleaming nugget. Although I'm a developer, not a DBA, I like to know something of what's under the hood with the tools we use. ...

aboyce (9/22/2009)

---

The answer depends on where the query is run. If run from SQL Server Management Studio, you get the answer given. With the 9 columns being:

E (No name) ight...

Although SSIS will run an ActiveX script, the underlying data model has changed dramatically, so it won't be able to interpret things like the value of a DTS 2000 global...

Sai,

I've never been able to fully control the formatting in an Excel worksheet, so may not be able to fully satisfy what you're trying to do. These notes from my...

Carleton,

Thank you for that correction. You're absolutely right about the wildcards. I'm here to learn and appreciate the chance for dialog.

Now, however, the NOT LIKE still doesn't...

Is it too early to think my Forty-niners are back on the road to respectability? Knocked off the NFC champ Cardinals last week, then convincingly beat the Seahawks yesterday....

Carleton (9/19/2009)

---

This is a fast and dirty way of doing what you are asking for. However, this query won't win any speed contensts, so if you have a lot...

You definitely do not need to use a one-at-a-time solution with a cursor or WHILE loop. Besides using EXCEPT to find the members of one resultset not found in...

Maybe it's the way my brain works, but I find that language is not only a tool of expression but also of organization. A thought will occur while reading...

J-F Bergeron (9/17/2009)

---

lmu92 (9/17/2009)

---

I could agree to "misunderstanding" if there weren't the attitude shown in his reply to J-F's post. And even a misunderstanding can be and should be phrased...

I wasn't so much confused by the negative conditionss as by the variable names themselves. Using "@c" and "@var" put my mind in the frame of "We're going to compare...