update vs4tquickproduct set tqpdtbracode=(SELECT tbracode FROM vs4tbranch WHERE tbraTBRTALIAS = 'HEADOFFICE') WHERE tqpdtbracode is null
GO
update vs4tPricelist set tppltbracode=(SELECT tbracode FROM vs4tbranch WHERE tbraTBRTALIAS = 'HEADOFFICE') WHERE tppltbracode is null
GO
UPDATE vs4tPurPricelist SET TPUPTBRaCode=(SELECT tbracode FROM vs4tbranch WHERE tbraTBRTALIAS = 'HEADOFFICE') WHERE tpuptbracode is null
GO