DELETE FROM [dbo].[FAKTURY] WHERE (([ID_FAKTURY] = @Original_ID_FAKTURY) AND ((@IsNull_NUMER = 1 AND [NUMER] IS NULL) OR ([NUMER] = @Original_NUMER)) AND ((@IsNull_NUMER_ROZ = 1 AND [NUMER_ROZ] IS NULL) OR ([NUMER_ROZ] = @Original_NUMER_ROZ)) AND ((@IsNull_NUMER_ROK = 1 AND [NUMER_ROK] IS NULL) OR ([NUMER_ROK] = @Original_NUMER_ROK)) AND ((@IsNull_DATA_WYSTAWIENIA = 1 AND [DATA_WYSTAWIENIA] IS NULL) OR ([DATA_WYSTAWIENIA] = @Original_DATA_WYSTAWIENIA)) AND ((@IsNull_MIEJSCOWOSC_WYSTAWIENIA = 1 AND [MIEJSCOWOSC_WYSTAWIENIA] IS NULL) OR ([MIEJSCOWOSC_WYSTAWIENIA] = @Original_MIEJSCOWOSC_WYSTAWIENIA)) AND ((@IsNull_ID_SPRZEDAWCY = 1 AND [ID_SPRZEDAWCY] IS NULL) OR ([ID_SPRZEDAWCY] = @Original_ID_SPRZEDAWCY)) AND ((@IsNull_ID_NABYWCY = 1 AND [ID_NABYWCY] IS NULL) OR ([ID_NABYWCY] = @Original_ID_NABYWCY)) AND ((@IsNull_DATA_SPRZEDAZY = 1 AND [DATA_SPRZEDAZY] IS NULL) OR ([DATA_SPRZEDAZY] = @Original_DATA_SPRZEDAZY)) AND ((@IsNull_PODPIS_WYSTAWIL = 1 AND [PODPIS_WYSTAWIL] IS NULL) OR ([PODPIS_WYSTAWIL] = @Original_PODPIS_WYSTAWIL)) AND ((@IsNull_PODPIS_ODEBRAL = 1 AND [PODPIS_ODEBRAL] IS NULL) OR ([PODPIS_ODEBRAL] = @Original_PODPIS_ODEBRAL)) AND ((@IsNull_SPOSOB_ZAPLATY = 1 AND [SPOSOB_ZAPLATY] IS NULL) OR ([SPOSOB_ZAPLATY] = @Original_SPOSOB_ZAPLATY)) AND ((@IsNull_TERMIN_ZAPLATY = 1 AND [TERMIN_ZAPLATY] IS NULL) OR ([TERMIN_ZAPLATY] = @Original_TERMIN_ZAPLATY)) AND ((@IsNull_ZAPLACONO = 1 AND [ZAPLACONO] IS NULL) OR ([ZAPLACONO] = @Original_ZAPLACONO)) AND ((@IsNull_BYL_WYDRUK = 1 AND [BYL_WYDRUK] IS NULL) OR ([BYL_WYDRUK] = @Original_BYL_WYDRUK)) AND ((@IsNull_SPRZEDAWCA_NIP = 1 AND [SPRZEDAWCA_NIP] IS NULL) OR ([SPRZEDAWCA_NIP] = @Original_SPRZEDAWCA_NIP)) AND ((@IsNull_NABYWCA_NIP = 1 AND [NABYWCA_NIP] IS NULL) OR ([NABYWCA_NIP] = @Original_NABYWCA_NIP)) AND ((@IsNull_FAKTURA_TYP = 1 AND [FAKTURA_TYP] IS NULL) OR ([FAKTURA_TYP] = @Original_FAKTURA_TYP)) AND ((@IsNull_FAKTURA_PODTYP = 1 AND [FAKTURA_PODTYP] IS NULL) OR ([FAKTURA_PODTYP] = @Original_FAKTURA_PODTYP)) AND ((@IsNull_ID_KONTA = 1 AND [ID_KONTA] IS NULL) OR ([ID_KONTA] = @Original_ID_KONTA)) AND ([EKSPORT] = @Original_EKSPORT) AND ([EXPORTED] = @Original_EXPORTED) AND ((@IsNull_ID_TYTUL = 1 AND [ID_TYTUL] IS NULL) OR ([ID_TYTUL] = @Original_ID_TYTUL)) AND ((@IsNull_EXPORTED_DATA = 1 AND [EXPORTED_DATA] IS NULL) OR ([EXPORTED_DATA] = @Original_EXPORTED_DATA)) AND ((@IsNull_suma_zaplat = 1 AND [suma_zaplat] IS NULL) OR ([suma_zaplat] = @Original_suma_zaplat)) AND ((@IsNull_ID_FK_KOR = 1 AND [ID_FK_KOR] IS NULL) OR ([ID_FK_KOR] = @Original_ID_FK_KOR)) AND ([KOREKTA] = @Original_KOREKTA) AND ((@IsNull_zaplata_data = 1 AND [zaplata_data] IS NULL) OR ([zaplata_data] = @Original_zaplata_data)) AND ((@IsNull_zaplata_opis = 1 AND [zaplata_opis] IS NULL) OR ([zaplata_opis] = @Original_zaplata_opis)) AND ((@IsNull_Zaliczka_Brutto = 1 AND [Zaliczka_Brutto] IS NULL) OR ([Zaliczka_Brutto] = @Original_Zaliczka_Brutto)) AND ((@IsNull_Zaliczka_Data = 1 AND [Zaliczka_Data] IS NULL) OR ([Zaliczka_Data] = @Original_Zaliczka_Data)) AND ((@IsNull_waluta_brutto = 1 AND [waluta_brutto] IS NULL) OR ([waluta_brutto] = @Original_waluta_brutto)) AND ((@IsNull_waluta_miano = 1 AND [waluta_miano] IS NULL) OR ([waluta_miano] = @Original_waluta_miano)) AND ((@IsNull_waluta_kurs = 1 AND [waluta_kurs] IS NULL) OR ([waluta_kurs] = @Original_waluta_kurs)) AND ((@IsNull_waluta_przelicznik = 1 AND [waluta_przelicznik] IS NULL) OR ([waluta_przelicznik] = @Original_waluta_przelicznik)) AND ((@IsNull_waluta_kurs_z_dnia = 1 AND [waluta_kurs_z_dnia] IS NULL) OR ([waluta_kurs_z_dnia] = @Original_waluta_kurs_z_dnia)) AND ((@IsNull_waluta_tabela_nr = 1 AND [waluta_tabela_nr] IS NULL) OR ([waluta_tabela_nr] = @Original_waluta_tabela_nr))) INSERT INTO [dbo].[FAKTURY] ([NUMER], [NUMER_ROZ], [NUMER_ROK], [DATA_WYSTAWIENIA], [MIEJSCOWOSC_WYSTAWIENIA], [ID_SPRZEDAWCY], [ID_NABYWCY], [DATA_SPRZEDAZY], [PODPIS_WYSTAWIL], [PODPIS_ODEBRAL], [opis], [SPOSOB_ZAPLATY], [TERMIN_ZAPLATY], [ZAPLACONO], [BYL_WYDRUK], [NABYWCA_ADRES], [SPRZEDAWCA_ADRES], [SPRZEDAWCA_NIP], [NABYWCA_NIP], [FAKTURA_TYP], [FAKTURA_PODTYP], [ID_KONTA], [EKSPORT], [EXPORTED], [ID_TYTUL], [EXPORTED_DATA], [suma_zaplat], [ID_FK_KOR], [KOREKTA], [zaplata_data], [zaplata_opis], [Zaliczka_Brutto], [Zaliczka_Data], [waluta_brutto], [waluta_miano], [waluta_kurs], [waluta_przelicznik], [waluta_kurs_z_dnia], [waluta_tabela_nr]) VALUES (@NUMER, @NUMER_ROZ, @NUMER_ROK, @DATA_WYSTAWIENIA, @MIEJSCOWOSC_WYSTAWIENIA, @ID_SPRZEDAWCY, @ID_NABYWCY, @DATA_SPRZEDAZY, @PODPIS_WYSTAWIL, @PODPIS_ODEBRAL, @opis, @SPOSOB_ZAPLATY, @TERMIN_ZAPLATY, @ZAPLACONO, @BYL_WYDRUK, @NABYWCA_ADRES, @SPRZEDAWCA_ADRES, @SPRZEDAWCA_NIP, @NABYWCA_NIP, @FAKTURA_TYP, @FAKTURA_PODTYP, @ID_KONTA, @EKSPORT, @EXPORTED, @ID_TYTUL, @EXPORTED_DATA, @suma_zaplat, @ID_FK_KOR, @KOREKTA, @zaplata_data, @zaplata_opis, @Zaliczka_Brutto, @Zaliczka_Data, @waluta_brutto, @waluta_miano, @waluta_kurs, @waluta_przelicznik, @waluta_kurs_z_dnia, @waluta_tabela_nr); SELECT ID_FAKTURY, NUMER, NUMER_ROZ, NUMER_ROK, DATA_WYSTAWIENIA, MIEJSCOWOSC_WYSTAWIENIA, ID_SPRZEDAWCY, ID_NABYWCY, DATA_SPRZEDAZY, PODPIS_WYSTAWIL, PODPIS_ODEBRAL, opis, SPOSOB_ZAPLATY, TERMIN_ZAPLATY, ZAPLACONO, BYL_WYDRUK, NABYWCA_ADRES, SPRZEDAWCA_ADRES, SPRZEDAWCA_NIP, NABYWCA_NIP, FAKTURA_TYP, FAKTURA_PODTYP, ID_KONTA, EKSPORT, EXPORTED, ID_TYTUL, EXPORTED_DATA, suma_zaplat, ID_FK_KOR, KOREKTA, zaplata_data, zaplata_opis, Zaliczka_Brutto, Zaliczka_Data, waluta_brutto, waluta_miano, waluta_kurs, waluta_przelicznik, waluta_kurs_z_dnia, waluta_tabela_nr FROM FAKTURY WHERE (ID_FAKTURY = SCOPE_IDENTITY()) SELECT ID_FAKTURY, NUMER, NUMER_ROZ, NUMER_ROK, DATA_WYSTAWIENIA, MIEJSCOWOSC_WYSTAWIENIA, ID_SPRZEDAWCY, ID_NABYWCY, DATA_SPRZEDAZY, PODPIS_WYSTAWIL, PODPIS_ODEBRAL, opis, SPOSOB_ZAPLATY, TERMIN_ZAPLATY, ZAPLACONO, BYL_WYDRUK, NABYWCA_ADRES, SPRZEDAWCA_ADRES, SPRZEDAWCA_NIP, NABYWCA_NIP, FAKTURA_TYP, FAKTURA_PODTYP, ID_KONTA, EKSPORT, EXPORTED, ID_TYTUL, EXPORTED_DATA, suma_zaplat, ID_FK_KOR, KOREKTA, zaplata_data, zaplata_opis, Zaliczka_Brutto, Zaliczka_Data, waluta_brutto, waluta_miano, waluta_kurs, waluta_przelicznik, waluta_kurs_z_dnia, waluta_tabela_nr FROM dbo.FAKTURY UPDATE [dbo].[FAKTURY] SET [NUMER] = @NUMER, [NUMER_ROZ] = @NUMER_ROZ, [NUMER_ROK] = @NUMER_ROK, [DATA_WYSTAWIENIA] = @DATA_WYSTAWIENIA, [MIEJSCOWOSC_WYSTAWIENIA] = @MIEJSCOWOSC_WYSTAWIENIA, [ID_SPRZEDAWCY] = @ID_SPRZEDAWCY, [ID_NABYWCY] = @ID_NABYWCY, [DATA_SPRZEDAZY] = @DATA_SPRZEDAZY, [PODPIS_WYSTAWIL] = @PODPIS_WYSTAWIL, [PODPIS_ODEBRAL] = @PODPIS_ODEBRAL, [opis] = @opis, [SPOSOB_ZAPLATY] = @SPOSOB_ZAPLATY, [TERMIN_ZAPLATY] = @TERMIN_ZAPLATY, [ZAPLACONO] = @ZAPLACONO, [BYL_WYDRUK] = @BYL_WYDRUK, [NABYWCA_ADRES] = @NABYWCA_ADRES, [SPRZEDAWCA_ADRES] = @SPRZEDAWCA_ADRES, [SPRZEDAWCA_NIP] = @SPRZEDAWCA_NIP, [NABYWCA_NIP] = @NABYWCA_NIP, [FAKTURA_TYP] = @FAKTURA_TYP, [FAKTURA_PODTYP] = @FAKTURA_PODTYP, [ID_KONTA] = @ID_KONTA, [EKSPORT] = @EKSPORT, [EXPORTED] = @EXPORTED, [ID_TYTUL] = @ID_TYTUL, [EXPORTED_DATA] = @EXPORTED_DATA, [suma_zaplat] = @suma_zaplat, [ID_FK_KOR] = @ID_FK_KOR, [KOREKTA] = @KOREKTA, [zaplata_data] = @zaplata_data, [zaplata_opis] = @zaplata_opis, [Zaliczka_Brutto] = @Zaliczka_Brutto, [Zaliczka_Data] = @Zaliczka_Data, [waluta_brutto] = @waluta_brutto, [waluta_miano] = @waluta_miano, [waluta_kurs] = @waluta_kurs, [waluta_przelicznik] = @waluta_przelicznik, [waluta_kurs_z_dnia] = @waluta_kurs_z_dnia, [waluta_tabela_nr] = @waluta_tabela_nr WHERE (([ID_FAKTURY] = @Original_ID_FAKTURY) AND ((@IsNull_NUMER = 1 AND [NUMER] IS NULL) OR ([NUMER] = @Original_NUMER)) AND ((@IsNull_NUMER_ROZ = 1 AND [NUMER_ROZ] IS NULL) OR ([NUMER_ROZ] = @Original_NUMER_ROZ)) AND ((@IsNull_NUMER_ROK = 1 AND [NUMER_ROK] IS NULL) OR ([NUMER_ROK] = @Original_NUMER_ROK)) AND ((@IsNull_DATA_WYSTAWIENIA = 1 AND [DATA_WYSTAWIENIA] IS NULL) OR ([DATA_WYSTAWIENIA] = @Original_DATA_WYSTAWIENIA)) AND ((@IsNull_MIEJSCOWOSC_WYSTAWIENIA = 1 AND [MIEJSCOWOSC_WYSTAWIENIA] IS NULL) OR ([MIEJSCOWOSC_WYSTAWIENIA] = @Original_MIEJSCOWOSC_WYSTAWIENIA)) AND ((@IsNull_ID_SPRZEDAWCY = 1 AND [ID_SPRZEDAWCY] IS NULL) OR ([ID_SPRZEDAWCY] = @Original_ID_SPRZEDAWCY)) AND ((@IsNull_ID_NABYWCY = 1 AND [ID_NABYWCY] IS NULL) OR ([ID_NABYWCY] = @Original_ID_NABYWCY)) AND ((@IsNull_DATA_SPRZEDAZY = 1 AND [DATA_SPRZEDAZY] IS NULL) OR ([DATA_SPRZEDAZY] = @Original_DATA_SPRZEDAZY)) AND ((@IsNull_PODPIS_WYSTAWIL = 1 AND [PODPIS_WYSTAWIL] IS NULL) OR ([PODPIS_WYSTAWIL] = @Original_PODPIS_WYSTAWIL)) AND ((@IsNull_PODPIS_ODEBRAL = 1 AND [PODPIS_ODEBRAL] IS NULL) OR ([PODPIS_ODEBRAL] = @Original_PODPIS_ODEBRAL)) AND ((@IsNull_SPOSOB_ZAPLATY = 1 AND [SPOSOB_ZAPLATY] IS NULL) OR ([SPOSOB_ZAPLATY] = @Original_SPOSOB_ZAPLATY)) AND ((@IsNull_TERMIN_ZAPLATY = 1 AND [TERMIN_ZAPLATY] IS NULL) OR ([TERMIN_ZAPLATY] = @Original_TERMIN_ZAPLATY)) AND ((@IsNull_ZAPLACONO = 1 AND [ZAPLACONO] IS NULL) OR ([ZAPLACONO] = @Original_ZAPLACONO)) AND ((@IsNull_BYL_WYDRUK = 1 AND [BYL_WYDRUK] IS NULL) OR ([BYL_WYDRUK] = @Original_BYL_WYDRUK)) AND ((@IsNull_SPRZEDAWCA_NIP = 1 AND [SPRZEDAWCA_NIP] IS NULL) OR ([SPRZEDAWCA_NIP] = @Original_SPRZEDAWCA_NIP)) AND ((@IsNull_NABYWCA_NIP = 1 AND [NABYWCA_NIP] IS NULL) OR ([NABYWCA_NIP] = @Original_NABYWCA_NIP)) AND ((@IsNull_FAKTURA_TYP = 1 AND [FAKTURA_TYP] IS NULL) OR ([FAKTURA_TYP] = @Original_FAKTURA_TYP)) AND ((@IsNull_FAKTURA_PODTYP = 1 AND [FAKTURA_PODTYP] IS NULL) OR ([FAKTURA_PODTYP] = @Original_FAKTURA_PODTYP)) AND ((@IsNull_ID_KONTA = 1 AND [ID_KONTA] IS NULL) OR ([ID_KONTA] = @Original_ID_KONTA)) AND ([EKSPORT] = @Original_EKSPORT) AND ([EXPORTED] = @Original_EXPORTED) AND ((@IsNull_ID_TYTUL = 1 AND [ID_TYTUL] IS NULL) OR ([ID_TYTUL] = @Original_ID_TYTUL)) AND ((@IsNull_EXPORTED_DATA = 1 AND [EXPORTED_DATA] IS NULL) OR ([EXPORTED_DATA] = @Original_EXPORTED_DATA)) AND ((@IsNull_suma_zaplat = 1 AND [suma_zaplat] IS NULL) OR ([suma_zaplat] = @Original_suma_zaplat)) AND ((@IsNull_ID_FK_KOR = 1 AND [ID_FK_KOR] IS NULL) OR ([ID_FK_KOR] = @Original_ID_FK_KOR)) AND ([KOREKTA] = @Original_KOREKTA) AND ((@IsNull_zaplata_data = 1 AND [zaplata_data] IS NULL) OR ([zaplata_data] = @Original_zaplata_data)) AND ((@IsNull_zaplata_opis = 1 AND [zaplata_opis] IS NULL) OR ([zaplata_opis] = @Original_zaplata_opis)) AND ((@IsNull_Zaliczka_Brutto = 1 AND [Zaliczka_Brutto] IS NULL) OR ([Zaliczka_Brutto] = @Original_Zaliczka_Brutto)) AND ((@IsNull_Zaliczka_Data = 1 AND [Zaliczka_Data] IS NULL) OR ([Zaliczka_Data] = @Original_Zaliczka_Data)) AND ((@IsNull_waluta_brutto = 1 AND [waluta_brutto] IS NULL) OR ([waluta_brutto] = @Original_waluta_brutto)) AND ((@IsNull_waluta_miano = 1 AND [waluta_miano] IS NULL) OR ([waluta_miano] = @Original_waluta_miano)) AND ((@IsNull_waluta_kurs = 1 AND [waluta_kurs] IS NULL) OR ([waluta_kurs] = @Original_waluta_kurs)) AND ((@IsNull_waluta_przelicznik = 1 AND [waluta_przelicznik] IS NULL) OR ([waluta_przelicznik] = @Original_waluta_przelicznik)) AND ((@IsNull_waluta_kurs_z_dnia = 1 AND [waluta_kurs_z_dnia] IS NULL) OR ([waluta_kurs_z_dnia] = @Original_waluta_kurs_z_dnia)) AND ((@IsNull_waluta_tabela_nr = 1 AND [waluta_tabela_nr] IS NULL) OR ([waluta_tabela_nr] = @Original_waluta_tabela_nr))); SELECT ID_FAKTURY, NUMER, NUMER_ROZ, NUMER_ROK, DATA_WYSTAWIENIA, MIEJSCOWOSC_WYSTAWIENIA, ID_SPRZEDAWCY, ID_NABYWCY, DATA_SPRZEDAZY, PODPIS_WYSTAWIL, PODPIS_ODEBRAL, opis, SPOSOB_ZAPLATY, TERMIN_ZAPLATY, ZAPLACONO, BYL_WYDRUK, NABYWCA_ADRES, SPRZEDAWCA_ADRES, SPRZEDAWCA_NIP, NABYWCA_NIP, FAKTURA_TYP, FAKTURA_PODTYP, ID_KONTA, EKSPORT, EXPORTED, ID_TYTUL, EXPORTED_DATA, suma_zaplat, ID_FK_KOR, KOREKTA, zaplata_data, zaplata_opis, Zaliczka_Brutto, Zaliczka_Data, waluta_brutto, waluta_miano, waluta_kurs, waluta_przelicznik, waluta_kurs_z_dnia, waluta_tabela_nr FROM FAKTURY WHERE (ID_FAKTURY = @ID_FAKTURY) SELECT ID_FAKTURY, NUMER, NUMER_ROZ, NUMER_ROK, DATA_WYSTAWIENIA, MIEJSCOWOSC_WYSTAWIENIA, ID_SPRZEDAWCY, ID_NABYWCY, DATA_SPRZEDAZY, PODPIS_WYSTAWIL, PODPIS_ODEBRAL, opis, SPOSOB_ZAPLATY, TERMIN_ZAPLATY, ZAPLACONO, BYL_WYDRUK, NABYWCA_ADRES, SPRZEDAWCA_ADRES, SPRZEDAWCA_NIP, NABYWCA_NIP, FAKTURA_TYP, FAKTURA_PODTYP, ID_KONTA, EKSPORT, EXPORTED, ID_TYTUL, EXPORTED_DATA, suma_zaplat, ID_FK_KOR, KOREKTA, zaplata_data, zaplata_opis, Zaliczka_Brutto, Zaliczka_Data, waluta_brutto, waluta_miano, waluta_kurs, waluta_przelicznik, waluta_kurs_z_dnia, waluta_tabela_nr FROM FAKTURY WHERE (NUMER_ROK >= 2008) AND (EXPORTED = 0) ORDER BY ID_NABYWCY DELETE FROM [dbo].[FAKTURA_DETAILS] WHERE (([ID_FAKTURA_DETAILS] = @Original_ID_FAKTURA_DETAILS) AND ((@IsNull_ID_FAKTURY = 1 AND [ID_FAKTURY] IS NULL) OR ([ID_FAKTURY] = @Original_ID_FAKTURY)) AND ((@IsNull_ROK = 1 AND [ROK] IS NULL) OR ([ROK] = @Original_ROK)) AND ((@IsNull_MIESIAC = 1 AND [MIESIAC] IS NULL) OR ([MIESIAC] = @Original_MIESIAC)) AND ((@IsNull_NAZWA_USLUGI = 1 AND [NAZWA_USLUGI] IS NULL) OR ([NAZWA_USLUGI] = @Original_NAZWA_USLUGI)) AND ((@IsNull_SYMBOL_SWW = 1 AND [SYMBOL_SWW] IS NULL) OR ([SYMBOL_SWW] = @Original_SYMBOL_SWW)) AND ((@IsNull_JM = 1 AND [JM] IS NULL) OR ([JM] = @Original_JM)) AND ((@IsNull_ILOSC = 1 AND [ILOSC] IS NULL) OR ([ILOSC] = @Original_ILOSC)) AND ((@IsNull_CENA_JEDN = 1 AND [CENA_JEDN] IS NULL) OR ([CENA_JEDN] = @Original_CENA_JEDN)) AND ((@IsNull_UPUST_PR = 1 AND [UPUST_PR] IS NULL) OR ([UPUST_PR] = @Original_UPUST_PR)) AND ((@IsNull_UPUST_NETTO = 1 AND [UPUST_NETTO] IS NULL) OR ([UPUST_NETTO] = @Original_UPUST_NETTO)) AND ((@IsNull_NETTO = 1 AND [NETTO] IS NULL) OR ([NETTO] = @Original_NETTO)) AND ((@IsNull_S_VAT = 1 AND [S_VAT] IS NULL) OR ([S_VAT] = @Original_S_VAT)) AND ((@IsNull_VAT = 1 AND [VAT] IS NULL) OR ([VAT] = @Original_VAT)) AND ((@IsNull_BRUTTO = 1 AND [BRUTTO] IS NULL) OR ([BRUTTO] = @Original_BRUTTO)) AND ((@IsNull_TYTUL = 1 AND [TYTUL] IS NULL) OR ([TYTUL] = @Original_TYTUL)) AND ((@IsNull_NR_WYDANIA = 1 AND [NR_WYDANIA] IS NULL) OR ([NR_WYDANIA] = @Original_NR_WYDANIA)) AND ((@IsNull_TYP = 1 AND [TYP] IS NULL) OR ([TYP] = @Original_TYP)) AND ((@IsNull_PODTYP = 1 AND [PODTYP] IS NULL) OR ([PODTYP] = @Original_PODTYP))) INSERT INTO [dbo].[FAKTURA_DETAILS] ([ID_FAKTURY], [ROK], [MIESIAC], [NAZWA_USLUGI], [SYMBOL_SWW], [JM], [ILOSC], [CENA_JEDN], [UPUST_PR], [UPUST_NETTO], [NETTO], [S_VAT], [VAT], [BRUTTO], [TYTUL], [NR_WYDANIA], [TYP], [PODTYP]) VALUES (@ID_FAKTURY, @ROK, @MIESIAC, @NAZWA_USLUGI, @SYMBOL_SWW, @JM, @ILOSC, @CENA_JEDN, @UPUST_PR, @UPUST_NETTO, @NETTO, @S_VAT, @VAT, @BRUTTO, @TYTUL, @NR_WYDANIA, @TYP, @PODTYP); SELECT ID_FAKTURA_DETAILS, ID_FAKTURY, ROK, MIESIAC, NAZWA_USLUGI, SYMBOL_SWW, JM, ILOSC, CENA_JEDN, UPUST_PR, UPUST_NETTO, NETTO, S_VAT, VAT, BRUTTO, TYTUL, NR_WYDANIA, TYP, PODTYP FROM FAKTURA_DETAILS WHERE (ID_FAKTURA_DETAILS = SCOPE_IDENTITY()) SELECT ID_FAKTURA_DETAILS, ID_FAKTURY, ROK, MIESIAC, NAZWA_USLUGI, SYMBOL_SWW, JM, ILOSC, CENA_JEDN, UPUST_PR, UPUST_NETTO, NETTO, S_VAT, VAT, BRUTTO, TYTUL, NR_WYDANIA, TYP, PODTYP FROM dbo.FAKTURA_DETAILS UPDATE [dbo].[FAKTURA_DETAILS] SET [ID_FAKTURY] = @ID_FAKTURY, [ROK] = @ROK, [MIESIAC] = @MIESIAC, [NAZWA_USLUGI] = @NAZWA_USLUGI, [SYMBOL_SWW] = @SYMBOL_SWW, [JM] = @JM, [ILOSC] = @ILOSC, [CENA_JEDN] = @CENA_JEDN, [UPUST_PR] = @UPUST_PR, [UPUST_NETTO] = @UPUST_NETTO, [NETTO] = @NETTO, [S_VAT] = @S_VAT, [VAT] = @VAT, [BRUTTO] = @BRUTTO, [TYTUL] = @TYTUL, [NR_WYDANIA] = @NR_WYDANIA, [TYP] = @TYP, [PODTYP] = @PODTYP WHERE (([ID_FAKTURA_DETAILS] = @Original_ID_FAKTURA_DETAILS) AND ((@IsNull_ID_FAKTURY = 1 AND [ID_FAKTURY] IS NULL) OR ([ID_FAKTURY] = @Original_ID_FAKTURY)) AND ((@IsNull_ROK = 1 AND [ROK] IS NULL) OR ([ROK] = @Original_ROK)) AND ((@IsNull_MIESIAC = 1 AND [MIESIAC] IS NULL) OR ([MIESIAC] = @Original_MIESIAC)) AND ((@IsNull_NAZWA_USLUGI = 1 AND [NAZWA_USLUGI] IS NULL) OR ([NAZWA_USLUGI] = @Original_NAZWA_USLUGI)) AND ((@IsNull_SYMBOL_SWW = 1 AND [SYMBOL_SWW] IS NULL) OR ([SYMBOL_SWW] = @Original_SYMBOL_SWW)) AND ((@IsNull_JM = 1 AND [JM] IS NULL) OR ([JM] = @Original_JM)) AND ((@IsNull_ILOSC = 1 AND [ILOSC] IS NULL) OR ([ILOSC] = @Original_ILOSC)) AND ((@IsNull_CENA_JEDN = 1 AND [CENA_JEDN] IS NULL) OR ([CENA_JEDN] = @Original_CENA_JEDN)) AND ((@IsNull_UPUST_PR = 1 AND [UPUST_PR] IS NULL) OR ([UPUST_PR] = @Original_UPUST_PR)) AND ((@IsNull_UPUST_NETTO = 1 AND [UPUST_NETTO] IS NULL) OR ([UPUST_NETTO] = @Original_UPUST_NETTO)) AND ((@IsNull_NETTO = 1 AND [NETTO] IS NULL) OR ([NETTO] = @Original_NETTO)) AND ((@IsNull_S_VAT = 1 AND [S_VAT] IS NULL) OR ([S_VAT] = @Original_S_VAT)) AND ((@IsNull_VAT = 1 AND [VAT] IS NULL) OR ([VAT] = @Original_VAT)) AND ((@IsNull_BRUTTO = 1 AND [BRUTTO] IS NULL) OR ([BRUTTO] = @Original_BRUTTO)) AND ((@IsNull_TYTUL = 1 AND [TYTUL] IS NULL) OR ([TYTUL] = @Original_TYTUL)) AND ((@IsNull_NR_WYDANIA = 1 AND [NR_WYDANIA] IS NULL) OR ([NR_WYDANIA] = @Original_NR_WYDANIA)) AND ((@IsNull_TYP = 1 AND [TYP] IS NULL) OR ([TYP] = @Original_TYP)) AND ((@IsNull_PODTYP = 1 AND [PODTYP] IS NULL) OR ([PODTYP] = @Original_PODTYP))); SELECT ID_FAKTURA_DETAILS, ID_FAKTURY, ROK, MIESIAC, NAZWA_USLUGI, SYMBOL_SWW, JM, ILOSC, CENA_JEDN, UPUST_PR, UPUST_NETTO, NETTO, S_VAT, VAT, BRUTTO, TYTUL, NR_WYDANIA, TYP, PODTYP FROM FAKTURA_DETAILS WHERE (ID_FAKTURA_DETAILS = @ID_FAKTURA_DETAILS) SELECT ID_FAKTURA_DETAILS, ID_FAKTURY, ROK, MIESIAC, NAZWA_USLUGI, SYMBOL_SWW, JM, ILOSC, CENA_JEDN, UPUST_PR, UPUST_NETTO, NETTO, S_VAT, VAT, BRUTTO, TYTUL, NR_WYDANIA, TYP, PODTYP FROM dbo.FAKTURA_DETAILS where Id_faktury = @idFaktury DELETE FROM [KLIENCI] WHERE (([CustomerID] = @Original_CustomerID) AND ((@IsNull_FirstName = 1 AND [FirstName] IS NULL) OR ([FirstName] = @Original_FirstName)) AND ((@IsNull_LastName = 1 AND [LastName] IS NULL) OR ([LastName] = @Original_LastName)) AND ((@IsNull_OrganizationName = 1 AND [OrganizationName] IS NULL) OR ([OrganizationName] = @Original_OrganizationName)) AND ((@IsNull_Address = 1 AND [Address] IS NULL) OR ([Address] = @Original_Address)) AND ((@IsNull_City = 1 AND [City] IS NULL) OR ([City] = @Original_City)) AND ((@IsNull_State = 1 AND [State] IS NULL) OR ([State] = @Original_State)) AND ((@IsNull_PostalCode = 1 AND [PostalCode] IS NULL) OR ([PostalCode] = @Original_PostalCode)) AND ((@IsNull_Country = 1 AND [Country] IS NULL) OR ([Country] = @Original_Country)) AND ((@IsNull_Nip = 1 AND [Nip] IS NULL) OR ([Nip] = @Original_Nip)) AND ((@IsNull_ContactName = 1 AND [ContactName] IS NULL) OR ([ContactName] = @Original_ContactName)) AND ((@IsNull_PhoneNumber = 1 AND [PhoneNumber] IS NULL) OR ([PhoneNumber] = @Original_PhoneNumber)) AND ((@IsNull_FaxNumber = 1 AND [FaxNumber] IS NULL) OR ([FaxNumber] = @Original_FaxNumber)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)) AND ((@IsNull_data = 1 AND [data] IS NULL) OR ([data] = @Original_data)) AND ((@IsNull_osw_nr = 1 AND [osw_nr] IS NULL) OR ([osw_nr] = @Original_osw_nr)) AND ((@IsNull_osw_wazne_do = 1 AND [osw_wazne_do] IS NULL) OR ([osw_wazne_do] = @Original_osw_wazne_do)) AND ((@IsNull_Adres_Fkatura = 1 AND [Adres_Fkatura] IS NULL) OR ([Adres_Fkatura] = @Original_Adres_Fkatura)) AND ((@IsNull_Old_ID = 1 AND [Old_ID] IS NULL) OR ([Old_ID] = @Original_Old_ID)) AND ((@IsNull_Adres_Kor = 1 AND [Adres_Kor] IS NULL) OR ([Adres_Kor] = @Original_Adres_Kor)) AND ([Platnik_VAT] = @Original_Platnik_VAT) AND ([Aktywny] = @Original_Aktywny) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_UserName = 1 AND [UserName] IS NULL) OR ([UserName] = @Original_UserName)) AND ((@IsNull_Last_Modify = 1 AND [Last_Modify] IS NULL) OR ([Last_Modify] = @Original_Last_Modify)) AND ((@IsNull_Modify_User = 1 AND [Modify_User] IS NULL) OR ([Modify_User] = @Original_Modify_User)) AND ((@IsNull_http = 1 AND [http] IS NULL) OR ([http] = @Original_http)) AND ((@IsNull_VIES = 1 AND [VIES] IS NULL) OR ([VIES] = @Original_VIES)) AND ((@IsNull_regon = 1 AND [regon] IS NULL) OR ([regon] = @Original_regon)) AND ((@IsNull_krs = 1 AND [krs] IS NULL) OR ([krs] = @Original_krs)) AND ((@IsNull_nipKraj = 1 AND [nipKraj] IS NULL) OR ([nipKraj] = @Original_nipKraj))) INSERT INTO [KLIENCI] ([FirstName], [LastName], [OrganizationName], [Address], [City], [State], [PostalCode], [Country], [Nip], [ContactName], [PhoneNumber], [FaxNumber], [Note], [data], [osw_nr], [osw_wazne_do], [Adres_Fkatura], [Old_ID], [Adres_Kor], [Platnik_VAT], [Aktywny], [Email], [UserName], [Last_Modify], [Modify_User], [http], [VIES], [regon], [krs], [nipKraj]) VALUES (@FirstName, @LastName, @OrganizationName, @Address, @City, @State, @PostalCode, @Country, @Nip, @ContactName, @PhoneNumber, @FaxNumber, @Note, @data, @osw_nr, @osw_wazne_do, @Adres_Fkatura, @Old_ID, @Adres_Kor, @Platnik_VAT, @Aktywny, @Email, @UserName, @Last_Modify, @Modify_User, @http, @VIES, @regon, @krs, @nipKraj); SELECT CustomerID, FirstName, LastName, OrganizationName, Address, City, State, PostalCode, Country, Nip, ContactName, PhoneNumber, FaxNumber, Note, data, osw_nr, osw_wazne_do, Adres_Fkatura, Old_ID, Adres_Kor, Platnik_VAT, Aktywny, Email, UserName, Last_Modify, Modify_User, http, VIES, regon, krs, nipKraj FROM KLIENCI WHERE (CustomerID = SCOPE_IDENTITY()) SELECT CustomerID, FirstName, LastName, OrganizationName, Address, City, State, PostalCode, Country, Nip, ContactName, PhoneNumber, FaxNumber, Note, data, osw_nr, osw_wazne_do, Adres_Fkatura, Old_ID, Adres_Kor, Platnik_VAT, Aktywny, Email, UserName, Last_Modify, Modify_User, http, VIES, regon, krs, nipKraj FROM KLIENCI UPDATE [KLIENCI] SET [FirstName] = @FirstName, [LastName] = @LastName, [OrganizationName] = @OrganizationName, [Address] = @Address, [City] = @City, [State] = @State, [PostalCode] = @PostalCode, [Country] = @Country, [Nip] = @Nip, [ContactName] = @ContactName, [PhoneNumber] = @PhoneNumber, [FaxNumber] = @FaxNumber, [Note] = @Note, [data] = @data, [osw_nr] = @osw_nr, [osw_wazne_do] = @osw_wazne_do, [Adres_Fkatura] = @Adres_Fkatura, [Old_ID] = @Old_ID, [Adres_Kor] = @Adres_Kor, [Platnik_VAT] = @Platnik_VAT, [Aktywny] = @Aktywny, [Email] = @Email, [UserName] = @UserName, [Last_Modify] = @Last_Modify, [Modify_User] = @Modify_User, [http] = @http, [VIES] = @VIES, [regon] = @regon, [krs] = @krs, [nipKraj] = @nipKraj WHERE (([CustomerID] = @Original_CustomerID) AND ((@IsNull_FirstName = 1 AND [FirstName] IS NULL) OR ([FirstName] = @Original_FirstName)) AND ((@IsNull_LastName = 1 AND [LastName] IS NULL) OR ([LastName] = @Original_LastName)) AND ((@IsNull_OrganizationName = 1 AND [OrganizationName] IS NULL) OR ([OrganizationName] = @Original_OrganizationName)) AND ((@IsNull_Address = 1 AND [Address] IS NULL) OR ([Address] = @Original_Address)) AND ((@IsNull_City = 1 AND [City] IS NULL) OR ([City] = @Original_City)) AND ((@IsNull_State = 1 AND [State] IS NULL) OR ([State] = @Original_State)) AND ((@IsNull_PostalCode = 1 AND [PostalCode] IS NULL) OR ([PostalCode] = @Original_PostalCode)) AND ((@IsNull_Country = 1 AND [Country] IS NULL) OR ([Country] = @Original_Country)) AND ((@IsNull_Nip = 1 AND [Nip] IS NULL) OR ([Nip] = @Original_Nip)) AND ((@IsNull_ContactName = 1 AND [ContactName] IS NULL) OR ([ContactName] = @Original_ContactName)) AND ((@IsNull_PhoneNumber = 1 AND [PhoneNumber] IS NULL) OR ([PhoneNumber] = @Original_PhoneNumber)) AND ((@IsNull_FaxNumber = 1 AND [FaxNumber] IS NULL) OR ([FaxNumber] = @Original_FaxNumber)) AND ((@IsNull_Note = 1 AND [Note] IS NULL) OR ([Note] = @Original_Note)) AND ((@IsNull_data = 1 AND [data] IS NULL) OR ([data] = @Original_data)) AND ((@IsNull_osw_nr = 1 AND [osw_nr] IS NULL) OR ([osw_nr] = @Original_osw_nr)) AND ((@IsNull_osw_wazne_do = 1 AND [osw_wazne_do] IS NULL) OR ([osw_wazne_do] = @Original_osw_wazne_do)) AND ((@IsNull_Adres_Fkatura = 1 AND [Adres_Fkatura] IS NULL) OR ([Adres_Fkatura] = @Original_Adres_Fkatura)) AND ((@IsNull_Old_ID = 1 AND [Old_ID] IS NULL) OR ([Old_ID] = @Original_Old_ID)) AND ((@IsNull_Adres_Kor = 1 AND [Adres_Kor] IS NULL) OR ([Adres_Kor] = @Original_Adres_Kor)) AND ([Platnik_VAT] = @Original_Platnik_VAT) AND ([Aktywny] = @Original_Aktywny) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_UserName = 1 AND [UserName] IS NULL) OR ([UserName] = @Original_UserName)) AND ((@IsNull_Last_Modify = 1 AND [Last_Modify] IS NULL) OR ([Last_Modify] = @Original_Last_Modify)) AND ((@IsNull_Modify_User = 1 AND [Modify_User] IS NULL) OR ([Modify_User] = @Original_Modify_User)) AND ((@IsNull_http = 1 AND [http] IS NULL) OR ([http] = @Original_http)) AND ((@IsNull_VIES = 1 AND [VIES] IS NULL) OR ([VIES] = @Original_VIES)) AND ((@IsNull_regon = 1 AND [regon] IS NULL) OR ([regon] = @Original_regon)) AND ((@IsNull_krs = 1 AND [krs] IS NULL) OR ([krs] = @Original_krs)) AND ((@IsNull_nipKraj = 1 AND [nipKraj] IS NULL) OR ([nipKraj] = @Original_nipKraj))); SELECT CustomerID, FirstName, LastName, OrganizationName, Address, City, State, PostalCode, Country, Nip, ContactName, PhoneNumber, FaxNumber, Note, data, osw_nr, osw_wazne_do, Adres_Fkatura, Old_ID, Adres_Kor, Platnik_VAT, Aktywny, Email, UserName, Last_Modify, Modify_User, http, VIES, regon, krs, nipKraj FROM KLIENCI WHERE (CustomerID = @CustomerID) SELECT Address, Adres_Fkatura, Adres_Kor, Aktywny, City, ContactName, Country, CustomerID, Email, FaxNumber, FirstName, LastName, Last_Modify, Modify_User, Nip, Note, Old_ID, OrganizationName, PhoneNumber, Platnik_VAT, PostalCode, State, UserName, VIES, data, http, krs, nipKraj, osw_nr, osw_wazne_do, regon FROM KLIENCI WHERE (CustomerID = @custId) SELECT TOP 10 Address, Adres_Fkatura, Adres_Kor, Aktywny, City, ContactName, Country, CustomerID, Email, FaxNumber, FirstName, LastName, Last_Modify, Modify_User, Nip, Note, Old_ID, OrganizationName, PhoneNumber, Platnik_VAT, PostalCode, State, UserName, VIES, data, http, krs, nipKraj, osw_nr, osw_wazne_do, regon FROM KLIENCI