Update OPENQUERY linked server
Hello. I have a massive request for help. I didn't sleep through the night trying to UPDATE OPENQUERY linked server. INSER and DELET was easy. However, I cannot cope with UPDATE. --GO -- usuwanie zawartości tabeli --DELETE FROM OPENQUERY(ImageArte, 'SELECT * FROM subiekt_stany') --Go -- Wstawianie do tabeli --INSERT INTO OPENQUERY(ImageArte, 'SELECT * FROM subiekt_stany') --(products_model,products_quantity,purchase_price,minimum_price,products_price_g,products_weight) ---- START UPDATE ---- UPDATE MYSQL SET MYSQL.products_weight = a.products_weight FROM OPENQUERY(ImageArte, 'SELECT products_quantity FROM subiekt_stany') MYSQL INNER JOIN [Nexo_IMAGE].[ModelDanychContainer].[Asortymenty] a ON a.products_model = MYSQL.products_model --- END UPDATE --- SELECT cast(a.[Symbol] AS varchar) products_model, cast(CASE WHEN (COALESCE(sum([Nexo_IMAGE].[ModelDanychContainer].[StanyMagazynowe].[IloscDostepna]),0)-COALESCE(sum([Nexo_IMAGE].[ModelDanychContainer].[StanyMagazynowe].[IloscZadysponowana]),0)) > 0 THEN (COALESCE(sum([Nexo_IMAGE].[ModelDanychContainer].[StanyMagazynowe].[IloscDostepna]),0)-COALESCE(sum([Nexo_IMAGE].[ModelDanychContainer].[StanyMagazynowe].[IloscZadysponowana]),0)) ELSE 0 END as int) products_quantity, cast(a.[CenaEwidencyjna]*1.23 as decimal (15,2)) purchase_price, cast(c1.CenaNetto as decimal(15,2)) minimum_price, cast(c.[CenaBrutto] as decimal(15,2)) products_price_g, cast([Nexo_IMAGE].[ModelDanychContainer].[JednostkiMiarAsortymentow].[Masa] as decimal (6,3)) products_weight FROM [Nexo_IMAGE].[ModelDanychContainer].[PozycjeCennika] c inner join [Nexo_IMAGE].[ModelDanychContainer].[PozycjeCennika] c1 on c.[Asortyment_Id]=c1.[Asortyment_Id] and c.[Cennik_Id]=100016 and c1.[Cennik_Id]=100017 inner join [Nexo_IMAGE].[ModelDanychContainer].[Asortymenty] a on c.[Asortyment_Id]=a.[Id] inner join [Nexo_IMAGE].[ModelDanychContainer].[JednostkiMiarAsortymentow] on a.[Id]=[Nexo_IMAGE].[ModelDanychContainer].[JednostkiMiarAsortymentow].[Asortyment_Id] left join [Nexo_IMAGE].[ModelDanychContainer].[StanyMagazynowe] on a.[Id]=[Nexo_IMAGE].[ModelDanychContainer].[StanyMagazynowe].[Asortyment_Id] inner join [Nexo_IMAGE].[ModelDanychContainer].[GrupyAsortymentu] on a.[Grupa_Id]=[Nexo_IMAGE].[ModelDanychContainer].[GrupyAsortymentu].[Id] inner join [Nexo_IMAGE].[ModelDanychContainer].[NaglowkiEncji] on a.[Naglowek_Id]=[Nexo_IMAGE].[ModelDanychContainer].[NaglowkiEncji].[Id] WHERE [Nexo_IMAGE].[ModelDanychContainer].[GrupyAsortymentu].[Nazwa] Like 'Z – %' and a.[IsInRecycleBin]=0 and (a.[SprzedazMobilna]=1 or a.[SklepInternetowy]=1) and cast([Nexo_IMAGE].[ModelDanychContainer].[NaglowkiEncji].[Zmieniono] as datetime2(0)) > cast(DATEADD(HOUR, -5, GETDATE()) as datetime2(0)) group by c.Asortyment_Id, a.Symbol, a.CenaEwidencyjna, c.CenaBrutto, c1.CenaNetto, Nexo_IMAGE.ModelDanychContainer.JednostkiMiarAsortymentow.Masa I don't know how to bind WHERE in UPDATE OPENQUERY with MsSQL query