Hi Grant

I didn't actually need the actual count itself - I just needed max(unitID) - the count itself wasn't necessary.

Thanks

Kal

Hi Grant

I dodn't actually need the actual count itself - I just needed max(unitID) - the count itself wasn't necessary.

Thanks

Kal

Hi Grant

I had to make a slight change but it now works - thank you for taking the trouble to help.

WITH X AS (SELECT ...

Hi Grant

My actuals products table contains 1485 rows. If I do a

select distinct productID, unitID from products

I get 121 records

and

select distinct productID from products

I get 93 rows.

So I would...

abhijeetv & Grant - thanks for taking the trouble to reply however neither solutions seem to do what I want... I'll reread my post to make sure I've...

Hi Remmi

That did the trick

Hi Remi

I'm hoping you can help me here.

I am getting the following error when executing the sql

"Cannot resolve collation conflict for equal to operation."

I've checked my table and the...

Ok, I see what you are doing (I think :ermm Will give it a try.

Many Thanks for your help...

I have a table called customer_invoices and need to sum the invoice value for a given customer or given set of customers. My stored proc would receive a '' separated...