i want to block the system message.

exception handling is possible in sql .if yes the how it can be handle?

Try this

select distinct ID from table_name

query returns :

A

1

2

3

i think here problem is with the assigning the value to variable

select  

    @purgecount = count(D.EventID), 

    @totcovchrg = sum(CoverChrgAmt), 

    @totpaymntamt = sum(PaymntAmt), 

    @totreimamt = sum(CalcTotalReimAmt)