There was nothing to misunderstand because you never explained before what result you realy wanted. :)

>No, no. You misunderstand. But I found the solution.
>
>I am trying to return a cursor with the count of the number of records in each group.
>
>Instead of:
>
>

>1	2006-01-03 00:00:00.000	0	135	WEST	1
>2	2006-01-03 00:00:00.000	0	135	WEST	1
>3	2006-01-03 00:00:00.000	0	135	WEST	1
>4	2006-01-03 00:00:00.000	0	135	WEST	1
>5	2006-01-03 00:00:00.000	0	135	WEST	1
>

>
>I want back:
>
>

>1	2006-01-03 00:00:00.000	0	135	WEST	5
>

>
>
>The solution was to remove the Id column.
>