I didn't see anything on Michelles Post about the script but do you know if anyone has converted this to work...

sibir1us (5/10/2011)

---

YSLGuru (5/10/2011)

---

Too bad you have to sign up for yet one more site in order to review/use...

Too bad you have to sign up for yet one more site in order to review/use the item...

jhorowitz10 (5/6/2011)

---

You might also want to check out this link:

http://www.sqlservercentral.com/articles/T-SQL/63681/

How to easily Converting Rows to Columns using Crosstabs

I hope this helps:

SELECT C.Name,

...

When I say best I mean the fastest method. I know my DB is on the smaller...

kent.kester (5/2/2011)

---

I think someone slipped up and let a marketing type look at a spec document for someone's network. They saw this cloud-shaped thing and decided it was marketable.

Here's...

Thanks G and yes your right about the reverse on the copy and paste. I try when i can to actually create the dummy tables and data so...

ColdCoffee (5/4/2011)

---

For starters, you can use

1. GROUP BY with MAX(CASE END) to get a row turned into columns

2. CROSS APPLY twice (or once) to get rows added as columns...

Steve Jones - SSC Editor (4/11/2011)

---

Jeff Moden (4/10/2011)

---

I think people have really gotten silly with computers. I mean, c'mon! Why would anyone connect a bloody washing machine to...

Grant Fritchey (3/30/2011)

---

Again, maybe, maybe not. You're also looking at the resources on the system. How much memory is there? Is it possible that you've pushed the DBCC check to...

Grant,

In my scenario the environment doesn’t change normally and so when it runs all factors are the same with the exception of some data growth. I have seen times...

bphipps-931675 (3/29/2011)

---

This is a reinvention of the wheel. There are a number of products that can do file comparisons and would've taken a lot less time to aquire and...

Thats what i thought. Thanks for confirming.

Great piece!

Meta Data / Extended Property question:

I have a PDF file (Man I hate PDF) that has thousands of details on Tables and columns for a very large DB (schema...

Jeff

Don't laugh but I'm not that familiar with Command line syntax and so I never thought about trying something like xp_DirTree. Do you know of any examples using xp_DirTree...