Stored Procedure + Return Total Row Affected

Hi..





I have a stored procedure which is used to remove record from database.


Is there anyway to get the total row deleted for each table?








CREATE PROCEDURE dbo.sp_company_delete


(


@Company_Id int,


@Sched int Output,


@Users int Output,


@Asset int Output,


@Fleet int Output





)


AS


SET NOCOUNT OFF;


Begin Transaction delete_company


Select @Sched = COUNT(*) from Scheduler Where Company_id=@Company_Id


Delete From Scheduler Where Company_id=@Company_Id





Select @Users = COUNT(*) From Users Where Company_Id=@Company_Id


Delete From Users Where Company_Id=@Company_Id





Select @Asset = COUNT(*) From Asset Where Company_Id=@Company_Id


Delete From Asset Where Company_Id=@Company_Id


Delete From Fleet Where Company_Id=@Company_Id


Delete From Company Where Company_Id=@Company_Id


Commit Transaction delete_company


GO








Basically I want to get the total row deleted for each table and put it inside output parameters.





I am doing a double job here, first I get the count, put into output parameter, then only I delete the record.





Is there any other way which is more efficient to do this?





I tried using


SET @Sched = Delete From Scheduler Where Company_id=@Company_Id


SET @Users = Delete From Users Where Company_Id=@Company_Id


But doesn't work.





Any suggestion is welcomed.


Thank you in advanced.