hi, Output parameters are used to pass results back from the stored procedure. You need to use OUTPUT keyword to specify the output parameter. The following link might be very helpful to you in this regard: http://www.sqlservercentral.com/articles/Stored+Procedures/usingparameterswithstoredprocedures/2004/