Thank you Steve that looks like it could work. 🙂 now i just need to implement it.

Actually i cannot change the table schema at all, the sample i provided are...

Hi Erin thanks for your reply.. But my problem remains that it counts every row.

CREATE TABLE Calls

(

ID int NULL,

caller nvarchar(50) NULL,

Agent nvarchar(50) NULL,

Missed bit NULL

) ON [PRIMARY]

GO

insert into Calls

values...