Should I have an output parameter then? I declared one.. @status int out.

When I execute the SP from SS2008, it gives two results - @status - 0 ; Return Value - 0. - For every record.

Updated my query . please have a look