Avatar of johnkainn

asked on 

Update - tabel

TableA (AId (int), AText (varchar(50)), BMoreThen1(bit))
TableB (BId(int), BText(varhar(50)), AId(int))
If there are more then 1 row in TableB with same AId, I would like to set BMoreThen1 column in TableA to true, else false.
How is best to do that?
Microsoft SQL Server 2008

Avatar of undefined
Last Comment
Alpesh Patel

8/22/2022 - Mon