_:n4d11b2d9681741abac0ae246771d2da4xb1
<http://schema.org/text>
"Hai all      I Have a tables like belowTable Name  TblOrdrsOrderIdOrderNumOrderStatus1AND123E2CBF124E3DVB168Ehere OrderId is PrimaryKeyTable Name  TblItmsItemIdFKorderIdItemQtyItemStatus113E217E339EHere ItemId is PrimaryKeyFrom Front End I have to pass parameters OrderId ItemIdI want to execute the below conditions1 by Using ItemId we have to update table TblItms ItemStatus as C  2 After updating TblItms we have to check  if the ItemStatus all are C or not using FKorderId if all status are C then Update TblOrdrs OrderStatusC based on OrderId if it all status are not C then no need to update TblOrdrs statusThe above conditions all are execute in single stored procedure so how to achieve all these conditions"
<https://www.aspsnippets.com/questions/415658/Update-Primary-Table-and-records-having-dependencies-in-SQL-Server/>