Wow, Jeff! I am going to have to study this one long and hard! Thank you so much - I will post back with either more questions or...

I could not convert it to 2008. I feel like I have tried all types of convolutions of it, lastly...

ColdCoffee (5/11/2010)

---

Now that you have posted the sample data and table structure, half the job is prettily done 🙂 Now can you give us some visual representation of how your...

Jeff Moden (5/11/2010)

---

Heh... you do realize that by using the 2008 VALUES clause, that all of the people still stuck in the world of 2005 or earlier either can't help...

Okay, I've read how I was to post my question and I think I have done it correctly now. 🙂

I am still having problems. The first query has too...

After being appropriately and rightly chastised for not including all that I should have, I will strive to do things correctly next time.

Nag, your response was what I needed and...

So much closer, but not quite! Now it runs, but I am getting all 1s in the last column instead of the actual count, COUNT(*) AS 'Nr By Gender/Type/Breed'.

Any...

Paul White NZ (4/18/2010)

---

This is true by default, but a PK will be created as non-clustered if it is added to a table that already has...

Thank you, Lowell. I had played around with many combinations but not the right one apparently. I will be making a note of your answer in my "book...

Lowell (4/16/2010)

---

defining a constraint name is optional...primary key, foreign key, defaults, check constraints...all of them will be auto named unless you explicitly define it:

here's your table with the named constraint...

Because I like it to be clean and just contain the necessary info in the title. The...