im using the following SQL query to create a recordset,
Can i use somethig similar to update all the tables in on hit. Each table has a field CBIDispatchedDate which is a datetime field. I want to set the CBIDispatchedDate = GetDate(
Select t1.Licence, t1.CompanyName, t1.Software
Case
When Exists
(Select * from dbo.Addacs as t3 Where t3.Licence = t1.licence and t3.CBIDispatchedDate Is NULL) Then Cast(1 as Bit) Else Cast(0 as Bit) end as ADDACS
Case
When Exists
(Select * from dbo.AFAFR_AUDDIS as t3 Where t3.Licence = t1.licence and t3.CBIDispatchedDate Is NULL) Then Cast(1 as Bit) Else Cast(0 as Bit) end as AUDDIS
Case
When Exists
(Select * from dbo.ARUC as t3 Where t3.Licence = t1.licence and t3.CBIDispatchedDate Is NULL) Then Cast(1 as Bit) Else Cast(0 as Bit) end as ARUC
Case
When Exists
(Select * from dbo.Arudd as t3 Where t3.Licence = t1.licence and t3.CBIDispatchedDate Is NULL) Then Cast(1 as Bit) Else Cast(0 as Bit) end as ARUDD
Case
When Exists
(Select * from dbo.AWACS as t3 Where t3.Licence = t1.licence and t3.CBIDispatchedDate Is NULL) Then Cast(1 as Bit) Else Cast(0 as Bit) end as AWACS
Case
When Exists
(Select * from dbo.InputReports as t3 Where t3.Licence = t1.licence and t3.CBIDispatchedDate Is NULL) Then Cast(1 as Bit) Else Cast(0 as Bit) end as INPU
From dbo.ClientAdmin as t
Left Join dbo.ClientFees as t
on t1.Licence = t2.Licenc
Where t1.Software = 'DebBacsFM' OR t2.ClientAcc >
Order By t1.licence