Hey All

I have made a Server Side Trace, and have TRC file.

I need to load data, and group this data

template with group only groups on eventid.

If I have following statements

exec usp_GetData @personid=1000

exec usp_GetData @personid=1001

exec usp_GetData @personid=1002

exec usp_GetData @personid=1003

exec usp_GetData @personid=1004

select personid, fullname, role, last_login_time from dbo.servicelog where personid = 1000

select personid, fullname, role, last_login_time from dbo.servicelog where personid = 1001

select personid, fullname, role, last_login_time from dbo.servicelog where personid = 1002

select personid, fullname, role, last_login_time from dbo.servicelog where personid = 1003

select personid, fullname, role, last_login_time from dbo.servicelog where personid = 1004

select count(1) members, role from dbo.servicelog where personid < 10000 and personid > 999 group by role order by members

Then I want to end up with 3 rows

TextData Hits Duration

----- ----- ------

exec usp_GetData 5 15101

select personid, fullname, role, last_login_time from dbo.servicelog where personid = ... 5 16126

select count(1) members, role from dbo.servicelog where personid < ... and personid > ... group by role order by members 1 244335

This will give me a impression on how many times a statements has been run, how long time users has spend waiting, what average is on a single run

From what I can see is this not possible using group by ;(

Hope someone can help me