Skip to navigation
How to update a mssql left joined table when the entry does not exist
01.12.14
update b set type= 'C' FROM table AS b left join othertable as c on b.id = c.id where b.type != 'C' and c.id !='NULL'
Reply
Anonymous
update e SET can_wait = 1 FROM [SL].[dbo].[zz_customers] AS e LEFT JOIN sl.dbo.lkh_customer_supplier as c ON e.lkh_short_customer_name = c.lkh_short_customer_name WHERE c.lkh_customer_code IN (621,10144,2550,937,5,14,2232)
01.12.14
Reply
Anonymous
UPDATE e set slusa_moq = '0' FROM av0_style_extra AS e LEFT JOIN av0_style AS s on e.av0_style = s.av0_style where s.av0_code = '{}';
01.12.14
Reply
Anonymous
Information Epoch 1732559112
Live free or die.
Home
Notebook
Contact us
