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...

How about

SELECT your_statement1

UNION ALL

SELECT your_statement2

?

Side note: you don't really need to store it in two temp tables before the UNION operation (as long as you don't need those separate...

ALZDBA (10/22/2010)

---

Jeff Moden (10/21/2010)

---

Thanks for the input, Johan. Heh... from what I've seen,...