Hi there ,
I have the below script

select
count(*),
b.intbranchid,
h.intCatID
from
tblcontent_hac_cat h inner join tbl_br_branch b on b.intbranchid = h.intbranchid
group by
b.intbranchid,
h.intCatID

order by b.intbranchid

It works however count count(*) isn't counting. next to each record, I get 1 where as I wish the count to increment each time intBranchID the same and reset when changes.



1 1 69
1 1 71
1 3 70
1 3 67
1 7 68
1 8 72
1 9 73
1 10 74
1 11 75

I want the results to be as :

1 1 69
2 1 71
1 3 70
2 3 67
1 7 68
1 8 72
1 9 73
1 10 74
1 11 75

So as I can output the total number of records per column 2

Any input would be appreciated

You are grouping on two columns, so every group turns out to be unique (ie it counts 1 69 and 1 71 as different groups cos the second ID is different).

Even if you wen to only one column it probably wouldn't work, and instead come out
2 1 71
2 3 67
1 7 68
1 8 72
1 9 73
1 10 74
1 11 75

This is because count(*) is there to tell you how many of some group there are, not how many there have been so far. Depending on how your script handles these results, I would just loop through the results and keep a counter in PHP/ASP, that I reset if the branch id is different to last time.