OK, maybe try to ask the question another way. Is 10GB (8%) of available free space OK / acceptable?

ummm, ok thanks

Well, I am not even close to a SQL server expert... trying to learn. Our SQL guy is out and we have been having problems with our one database...

Ha, you are correct. I just ended up keeping the previous as is and created all new. And entire switchboard of different results. However, this is awesome....

Here is the last complete I was working with:

WITH SampleData ([Group], [Type], Amount) AS (

SELECT 'Dog', 'Typea', 1 UNION ALL

...

I need to figure out one last solution with this. Is it possible to do the PIVOT SQL function with this solution?

(http://blogs.msdn.com/b/spike/archive/2009/03/03/pivot-tables-in-sql-server-a-simple-sample.aspx)

such as:

Group as the rows (Dog,...

Thank you!! I will try this too.

Perfect... so far so good. Now just to test to make sure all of my numbers are coming out correct. Thank you again! This site is awesome!

OK, I was closer.

Also, I applied this to my live query and I got this error:

Divide by zero error encountered.

Got it!!!!!!!!

WITH SampleData ([Group], [Type], Amount) AS (

SELECT 'Dog', 'Typea', 1 UNION ALL

SELECT 'Dog', 'Typeb', 2 UNION ALL

SELECT 'Dog', 'Typec', 3 UNION ALL

SELECT 'Cat', 'Typea', 10 UNION ALL

SELECT...

That is where I was stuck before. How would I change this?

SELECT

[Group],

[Type],

Amount,...

WITH SampleData ([Group], [Type], Amount) AS (

SELECT 'Dog', 'Typea', 1 UNION ALL

SELECT 'Dog', 'Typeb', 2 UNION ALL

SELECT 'Dog', 'Typec', 3 UNION ALL

SELECT 'Cat', 'Typea', 10 UNION ALL

SELECT 'Cat', 'Typea', 10...

These all are working great except that I forgot the first step... I need to SUM the values first. So if I have multiple group / types... I don't...

This is working great too. What if I add multiple types per animal in first. How do I group and total first and then get the same unique...

Also how did you get the code highlighted above?