Tom Hamilton (7/9/2008)

---

Hi Jeff,

I was researching cross-tab like products and your postings come as one who knows how.

I need to produce a of Cases and comma-separated list of Jurisdictions, like...

Ummmm.... I use T-SQL and CmdShell... Once in a while, I may throw a little VBS into the mix... but everything else I do when I do DBA work is...

Dugi (7/9/2008)

---

Very intereseting ....

So if you compare one MVP(SQL - and we have some infos how to become MVP) with one Software Engineer (SQL or Oracle Database) Graduate Master or...

webrunner (7/9/2008)

---

Steve,

In your editorial you write, "I'm not sure why I was picked."

That's very humble. But as someone who has benefited from the SQL expertise that you and many others...

I just tell it to ignore at least 1 error...

Looks ok to me... don't forget... you can use MAX in place of SUM for things that aren't numeric in nature provided they're unique.

And, thanks for the feedback.

Angelindiego (7/9/2008)

---

Christopher, can you explain a bit more in detail what the conversation you and Jeff are having is about?? I don't want to get lost here.....(ok, anymore lost.....)

Thanks...

Sorry... I meant "SysComments"... not "SysColumns"... I've repaired the post where I made that error.

The key is that the...

It's ok, really... as suggested, it's a really great study in the human element. Some post with out reading, some argue they read, some read and still don't understand.

And,...

Gosh... this is an "adjacency" hierarchy on steroids... my feeling is that the tables are not correctly designed... there should be a table where ALL the managers and employees are...

A sports MVP knows how to get one... serve the team and go the extra mile. Should be no different for SQL Server or any of the other categories...

The only problem with that is if the function name sits on the "border" between two code segments in SysComments... you could miss a dependency that way. Works 99%...

Non-sequential inserts on a clustered key are a huge problem. It makes for page splits and some very slow inserts once a page split has occured. You need...

So, you're going to send out scripts customized for each user?

You can write a batch...

I haven't executed it (the last part of the code), but it looks correct. The first part of the code still has a "Dense_RANK" in it... 2k has no...