You are a star!

Thanks heaps, I am eternally in your debt.

So from this I would expect

Totals

5

5

4

5

5

4

As these are the totals of columns populated with figures other than zero.

SELECT 10.1, 11.1, 12.1, 13.1, 14.1 UNION ALL

SELECT 10.1, 11.1, 12.1, 13.1,...

Hi,

I don't think I have been clear in what I require. I will use your example.

DECLARE @T Table (Id INT, COL1 INT, COL2 INT,Val int)

INSERT INTO @T SELECT

1,2,3,10 UNION ALL...

Hi thanks for that but it is still giving me a count of 4 where I know there should be at least one row showing a count of 2.

Thanks.