Yes, that did it.

Thank you very much.

Still only shows the two rows and not the one that has nothing.

Here is my code. Not sure if this is what you meant.

SELECT Table1.Name, ISNULL(COUNT(Table2.ID),0) AS CNum, ISNULL(SUM(Table2.Value),0) AS...

Thanks for responding. Yes, this is inherited and I didn't create the table. I am working on a product feed and need to have the size and color in the...

Perfect!! Thanks to both of you for helping me with this. It works perfect for what I need.

manjuke (1/9/2012)

---

If you want to retrieve all the pictures to a single column, you can use similar syntax:

declare @table1 as table (

ProductId int

,SKU varchar(10)

,[Description] varchar(50)

)

insert into @table1

...

Thanks for the info but...

Worked great! Thank you.

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

Great! That worked to add the number at the end.

Thanks.

When I try to execute this I receive the following error:

"Syntax error converting the varchar value 'MasterList' to a column of data type int."

Any suggestion what this error is?

Thanks.

Thanks for the info. This is what I am currently doing (except I am not using a view) I am just creating each table with a script similar to this.

What...

Unfortunately, the software we use doesn't allow scripting. It just asks for the table name and email field to use. I can't update this program to allow stepping through the...

Thanks for the info. The only reason I am doing this is from another program limitation that can only process 10,000 records at a time. It is an e-mail campaign...