I use this delete query to update 4 tables. Is there a way to set a parameter for the field "siteno" so I only have to enter 1 time. Thanks
use [acr]
go
delete sb.SiteContractBill
where SiteNo = 'PA0041'
go
delete sb.SitePMInspection
where SiteNo = 'PA0041'
delete sb.SitePMInspectionSubtaskList
where SiteNo = 'PA0041'
go
delete sb.siteRenewalPrice
where SiteNo = 'PA0041'
go
use [acr]
go
delete sb.SiteContractBill
where SiteNo = 'PA0041'
go
delete sb.SitePMInspection
where SiteNo = 'PA0041'
delete sb.SitePMInspectionSubtaskList
where SiteNo = 'PA0041'
go
delete sb.siteRenewalPrice
where SiteNo = 'PA0041'
go