hi,
bharathi ur SP is perfectly right, i just copied and excuted in query analyser and it worked perfectly fine.. i hope after creating the SP :
***********
CREATE procedure emp_DebugA
(
@IntIn...