hi friends, 🙂

I got the solution also...

Inside the sp we need to give SET NOCOUNT ON ,ie

CREARE PROCEDURE SP_NAME

(@INPUT1 INT,

@INPUT2 VARCHAR(30)

)

AS

BEGIN

SET NOCOUNT ON

IF(1=2)

BEGIN

-- select all the columns in the final result

END

-- body of sp

END

Thanks&Regards,

MC