Generate query whith MS Excel

=”UPDATE documents SET igv_doc = ‘” & 0 & “‘ WHERE id_agree = ‘” & ENTERO(A2) & “‘ and number_doc = ‘” & SUSTITUIR(E2;”‘”;”””) & “‘ ;”

Two columns

=”UPDATE documents SET igv_doc = ‘” & 0 & “‘ WHERE id_agree = ‘” & SUSTITUIR(B2;”‘”;”””) & “‘ and sap_doc = ‘” & SUSTITUIR(S2;”‘”;”””) & “‘ ;”

=”UPDATE documents SET number_doc = ‘” & P2 & “‘, sap_doc = ‘” & S2 & “‘ WHERE id_agree = ‘” & SUSTITUIR(A2;”‘”;”””) & “‘ and number_doc = ‘” & SUSTITUIR(O2;”‘”;”””) & “‘ ;”

Katen Doe

Katen Doe

Hello, I’m a content writer who is fascinated by content fashion, celebrity and lifestyle. She helps clients bring the right content to the right people.

Press ESC to close