Thanks for the reply,

When i run that procedure, i am getting error like below

Server: Msg 232, Level 16, State 3, Procedure DummyReport, Line 26

Arithmetic overflow error for type int, value = 2561015000.000000.

The 'DummyReport' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.

Please some some body tell me that is that procedure is correct or not, if it is wrong what is the correct procedure statement for that

Thanks

Chandrashekar