David Johnson (12/5/2008)

---

Good article - very clear. It is good to know what is possible, even if there are drawbacks.

Please note that there is a comma missing, from before 'SaveAs'....

Isn't that the truth.

Fantastic article! Thanks!

Wayne

Iggy (11/13/2008)

---

Nice! I almost got tricked. If you had put

1 Test Policy 150000.00

2 Policy1 250000.00

3 0.00

in the answer, I would have chosen it, but because this answer doesn't exist,...

Okay, I found out how SSMS is doing it (by tracing it's actions).

It needs to be done like:

select name from sysobjects o1

where type in ('FN',...

I agree with using the SELECT ... FOR XML PATH('') to get a set based operation. Not only does it remove the cursor, but it greatly simplifies the code.

What I...

Derek,

This doesn't do it... those procs must not be in sys.system_objects

Wayne

Derek Dongray (11/10/2008)

---

I assume R.Barry Young was kidding ...

select name from sysobjects o1

where type in ('FN', 'IF',...

Thanks Matt.

(I hate the answers that are SOOO obvious... why didn't I think of it???:))

Neat article.

You can eliminate the cursor (though in this case there's really not a performance hit) by:

...

Interesting. While testing out the select statement above, I am getting the emails almost instantly. Typical.

The logs were showing the database mail process starting, and about 10 minutes later stopping.

To get the last 100 from an identity column, it would be as Adi said:

select top 100 *

from MyTable

order by MyIdentityColumn desc

this gets the last 100 values...

What happens if you put the password column at the end of the select list instead of in the middle?

I don't think that this will relate, but if you have...

Good thoughts. Thanks for your replies.

What I'm trying to accomplish is to:

a. get a list of drives, free space, and available space. (xp_FixedDrives gets me the drive letter and...

GilaMonster (10/1/2008)

---

WayneS (9/30/2008)

---

I have SS 2005 (Dev) on my computer. I frequently need to connect to a SS 2000 server. I've noticed a couple of things that I could do...

I agree. And that's a pretty interesting use...

bhovious (8/21/2008)

---

Just to answer the rhetorical questions about building xml by wrapping tag constants around data, rather than use a "For XML" statement, we should remember that a lot of...