output file and row count

[Guest_imported]

I have a stored proc that returns grouped result sets. The output is a file. In the header, I want to put a total 'group' count. I can get the count by doing a simple count(*) of the temp table after it is grouped. But how do I output this single value in my final select?

 

[Guest_imported]

I will insert a row in the table with the count. I will create a numbered column with the first row = 1. Then I will order by the numbered column which will place the count value at the head of the file.