<div>
<div class="content wysiwyg-content">
TableA (AId (int), AText (varchar(50)), BMoreThen1(bit))<br />
TableB (BId(int), BText(varhar(50)), AId(int))<br />
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. <br />
How is best to do that?
</div>
</div>


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?

Update - tabel

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.