declare @billmastId varchar(40)
set @BillmastId = 'B_29499_48_003'

update billmast set r = 2 where billmastid = @BillmastId 
update narration set r = 2 where billmastid = @BillmastId 
update acrefmast set r = 2 where billmastid = @BillmastId 
update vomast set r = 2 where billmastid = @BillmastId 
update voinsudet set r = 2 where billmastid = @BillmastId 
update vosharedet set r = 2 where billmastid = @BillmastId 
update voLnUsedDet set r = 2 where billmastid = @BillmastId 
update CqTrack set r = 2 where billmastid = @BillmastId 
update DispTrack set r = 2 where billmastid = @BillmastId 
update BillExtra set r = 2 where billmastid = @BillmastId 
update Voucher set r = 2 where billmastid = @BillmastId 
update AcRefDet set r = 2 where billmastid = @BillmastId 
update VoDepoDet set r = 2 where billmastid = @BillmastId 
update VoRentDet set r = 2 where billmastid = @BillmastId 
update VoLoanDet set r = 2 where billmastid = @BillmastId 
update BrVoDet set r = 2 where billmastid = @BillmastId 
update PmcDet set r = 2 where billmastid = @BillmastId 
update VoDepoRef set r = 2 where billmastid = @BillmastId 


delete from  billmast where billmastid = @BillmastId 
delete from  narration where billmastid = @BillmastId 
delete from  acrefmast where billmastid = @BillmastId 
delete from  vomast where billmastid = @BillmastId 
delete from  voinsudet where billmastid = @BillmastId 
delete from  vosharedet where billmastid = @BillmastId 
delete from voLnUsedDet where billmastid = @BillmastId 
delete from CqTrack where billmastid = @BillmastId 
delete from DispTrack where billmastid = @BillmastId 
delete from BillExtra where billmastid = @BillmastId 
delete from Voucher where billmastid = @BillmastId 
delete from AcRefDet where billmastid = @BillmastId 
delete from VoDepoDet where billmastid = @BillmastId 
delete from VoRentDet where billmastid = @BillmastId 
delete from VoLoanDet where billmastid = @BillmastId 
delete from BrVoDet where billmastid = @BillmastId 
delete from PmcDet where billmastid = @BillmastId 
delete from VoDepoRef where billmastid = @BillmastId