To Remove Tranportation Fee From Everywhere , Make Sure about Backup Before Action

Solution

update dbo.F_Admissions set chkTransportation = 0 where chkTransportation = 1 select * from dbo.F_Admissions_FeeStru where numFeeType_ID = 2 delete from dbo.F_Admissions_OtherFeeDet where numFeeType_ID = 2 delete from dbo.F_FeeReceiptNewDetail where numFeeType_ID = 2 delete from dbo.F_Admissions_FeeStru where numFeeType_ID = 2 update dbo.F_Admissions_ClassDetail set chkTransportRequired = 0 where chkTransportRequired = 1