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