There is no way you're going to be able to get that result straight from the pivot. There is only one '301' in the table. SQL won't duplicate a value...

It's a relational theory issue and there are two sides to it. One says nulls are fine to indicate missing or unknown...

Can you explain in more detail?

Check Model. It could be that at...

How many pages?

As I said, smaller tables will not have fragmentation reduced to 0, and it's nothing to be concerned about

It has to do with how the first few pages of the table are allocated. How many pages are there in this table?

How big is the table, how many rows, how many pages? (sys.dm_db_index_physical_stats will tell you that)

If I had to guess, I'd say this is a really small table, less than...

Jeff Moden (10/21/2008)

---

Shifting gears a bit here... What a PITA.... I hate it when they do stuff like that... In 2k, the default was OFF, in 2k5, the default is...

Likewise. I found this site when I was just getting started with SQL. Initially it was the question of the day that...

Grant Fritchey (10/25/2008)

---

I know the kind of snobbery and attack posts you're talking about because I've seen them at other sites. I have yet to see serious infractions here at...

You have to aggregate, but what you can do is to add a fake column in which you then ignore.

This more or less gets want you want. I don't understand...

Here's a schedule for all the SQL 2008 exams:

http://blogs.msdn.com/gerryo/archive/2008/10/24/weekly-exam-status-update.aspx

Can you please post some sample data and your desired output.

Jeff Moden (10/24/2008)

---

YES! I want someone that knows how to write code. There are certain basics that I believe you must know. But, I've had a couple...

On my 2008 box, it varies. First one is faster then the other, but it's a difference of around 20ms over 1000000 executions, So works out at about 20 nanoseconds...