you can just populate a log table with select Last_Disp , Kount=count(*) ,en_date=getdate() from dbo.vw_AZ_Leads_Dialable group by Last_Disp also its more general ,and works even if you add more Last_Disp types ,regards john ,nb sorry I was bit bussy but you are really good programmer