That's why Andrew said to check and make sure that what look like spaces, actually are... it's a data problem... the trim functions will not remove all white-space characters... just...

Ninja's_RGR'us (2/23/2009)

---

Why not bump the limit to a...

Sorry, didn't mean to leave you hanging...

Here's one way to read the result set of SP_WHO2 into a temp table. What ever you're doing (it would be nice if...

Oh yeah... I almost forgot... we need a way to download all PM's. There's a 100 I wanna keep. 😉

Steve Jones - Editor (2/22/2009)

---

I don't like bits for things like this and I'd go with ISO. Who knows what crazy categories someone might assign, so leave room for growth...

To be more clear...

If it were a cross tab of aggregated numbers, it could save a huge amount on how much you stuff into the pipe. But, even then,...

Bob Hovious (2/22/2009)

---

Why ask why? 😉

I get these kinds of requests from our reports group. Some people want to squeeze as much information as they can onto a...

You didn't try it enough. You will get dupes if you use CheckSum on GUID's.

SELECT TOP 1000000

CHECKSUM(NEWID()) AS...

I hope this was at least a paid entry. Other wise, I'd have to rate it as some seriously overdone SPAM.

Have fun... sp_who2 has two SPID columns. Make sure you name them differently in the temp table.

Also, think about NOT using a cursor.

Heh... too easy... use the BIT datatype... 0...

sriram (2/22/2009)

---

I need to display the data in a single row all groups as columns as below.

henry - 10/20/1960 - 2 - 3 - 5

...

I'd say there's bigger fish to fry...

Bold, italics, and underline work just fine but the highlighted item being affected loses focus after any of those. It's frequently desireable to...

Actually, you can...

SELECT *

FROM OPENROWSET('SQLOLEDB','Server=yourserverinstancehere;Trusted_Connection=Yes;Database=Master',

...

Do you have any ETL processes on that server?