sql transform list another formed id match
i have database account numbers card numbers. i review record update any tag numbers comment number, i am wholly operative comment numbers.
i combined perspective fasten list account/card database relapse table id associated comment number, i need transform those annals where id matches comment number.
this sales_import table, where account number domain needs updated:
leadid accountnumber
147 5807811235
150 5807811326
185 7006100100007267039
and retrieveaccountnumber table, where i need transform from:
leadid accountnumber
147 7006100100007266957
150 7006100100007267039
i attempted below, nonetheless fitness far:
update [sales_lead].[dbo].[sales_import]
set [accountnumber] = (select retrieveaccountnumber.accountnumber
retrieveaccountnumber
where [sales_lead].[dbo].[sales_import]. leadid =
retrieveaccountnumber.leadid)
it updates tag numbers comment numbers, nonetheless comment numbers gets transposed null
Comments
Post a Comment