Wouldn't the UNPIVOT approach be a little easier?

;

WITH cte AS

(

SELECT *

FROM

(SELECT *

FROM tblCompare) p

UNPIVOT

(Vals FOR col IN

(col1,col2,col3,col4)

)AS...

The solution to your question usually is referred to as PIVOT or CrossTab query. A link to an related article referencing the latter can be found in my signature.

In general,...

Yup, that's my first source. Now that Gail pointed...

GilaMonster (12/8/2011)

---

Whoever designed that is making the standard mistake of specing for space, not performance. Grab a copy of 'Troubleshooting SQL Server' by Jonathan Kehayias and check out chapter 2...

Hi Andrew,

I'm not sure if this would help you to get started:

Instead of trying to select one at a time, you could use Row_Number() to place the rquired rows in...

Like I said before: if there are some ready...

SQLRNNR (12/7/2011)

---

Yes on the 64K, get them to format as 64K clusters. If filestreaming with larger files, you may want larger cluster sizes.

The spindles seems off.

The local drive is...

Here are some code snippets based on some read to use sample data (do you recognize the data?)

-- sample data in a ready to use format:

DECLARE @tbl TABLE

(

fund_id INT,...

Glad I could help and welcome aboard!

If you find the time, you...

The SAN is provided by a 3rd party and a different group of our company is responsible for it.

But I'll try to raise the 64k formatting you mentioned. Let's see...

duplicate post. no replies please.

Discussion already started here.

Depending on the classification values being static or not, it's either a CrossTab or a DynamicCrossTab scenario. Both concepts are described in the related links in my signature.

As a side...

Thank you for the prompt response, Elliot. Much appreciated.

I'm concerned, too. Especially, since all of our DBs now would have to share the same physical drives for logs and tempdb....

GilaMonster (12/6/2011)

---

...

We're not singled out, we're just not included.

The only valid countries are USA (except a few states), Canada (except Quebec), UK (except North Ireland) and Australia. (maybe one or...

I hope you're aware of the following limitation of using SQL Server in a virtualized environment:

"Virtualization Snapshots for Hyper-V or for any virtualization vendor are not supported to use with...