DATETIME help

[Shawn Bijou]

Hi everyone,

here is the sql statement I am running:

select convert(varchar(5), last_mod_tmstmp, 108 ), count(*)
from pim_pim2ssb_trans
group by proc_status, last_mod_tmstmp

Here is the output that I get:

07:03 1
07:03 21
09:06 10
09:06 6
14:06 605
14:06 243

I need to find a way to merge the the records with the same minutes together. Since the seconds are different another record was created. Please help.

Thanks,

Shawn