You should look into WITH ROLLUP (see BOL for details) to get your total value instead of using the UNION.

It's easy, but complicated 😉

SQL Server will evaluate each expression within your equation and will determine the returned data type. Based on that it will define each subresult as well...

SUM() is an aggregate function.

You need to group your data by using GROUP BY in your query. Please have a look at BOL (BooksOnLine, the SQL Server help system usually...

I guess what Chris refers to is the FOR XML PATH() concept.

You might find a suitable solution by searching for "string concatenate for xml path" on either this forum or...

Are you sure you're using SQL Server 2008????

The ORA-... error number indicates something different....

I would load the Donation Amount file (maybe the Donation Maker, too) into staging tables first and move into the final table from there. This would allow for any logic...

steve-760524 (10/25/2010)

---

Thanks for the help. I read your article on cross tabs but the examples look like they are from 1 table. I have two tables I am trying to...

You still haven't provided any of the error messages you mentioned. Please post those errors.

First of all: EXCELLENT job providing ready to use sample data, your current solution, current result and expected result. Nothing more to ask for!! THANK YOU!!

I stopped using PIVOT a...

What are the error messages you get? The query itself looks fine...

There can be anything like permission issues, mis-spelled table or column name, data type conflict, foreign key references -...

Toms solution will work if you need to get the image names into one column.

But if you need to do a pivot (or cross tab) with separate columns per picture...

Hmmm...

I've re-run your code and get the same results now.

Must have been a problem with my system back then - either the part behind the screen or in front if...

spam reported

Ok, here's a slightly different approach.

When running your second sample, I didn't get yuor expected result. Is that intentional?

If not, here's a query that will return your expected result and...

I hope this link will show you some ways to do it...