SELECT value, label FROM dbo.v_selTipo SELECT value, label FROM dbo.[v_selCli] order by label SELECT * FROM dbo.v_docsExpl dbo.stp_docs_clone dbo.stp_fatt_ForceSetPagato dbo.stp_docs_getByAnno dbo.stp_docs_getByKey dbo.stp_docs_getFilt dbo.stp_docs_insert dbo.stp_docs_updateCodExt dbo.stp_docs_update SELECT Id, idxDoc, Descrizione, um, prezzoUm, qta, sconto, c_iva, no_ritenuta, valuta, iva, netto, quotaIva, importo FROM dbo.v_docRowsExpl dbo.stp_docRows_addNew dbo.stp_docRows_copy2doc dbo.stp_docRows_deleteQuery dbo.stp_docRows_getByC_iva dbo.stp_docRows_getByIdxDoc dbo.stp_docRows_updateQuery SELECT value, label FROM dbo.v_sel_IVA DELETE FROM [C_iva] WHERE (([C_iva] = @Original_C_iva) AND ((@IsNull_upsize_ts = 1 AND [upsize_ts] IS NULL) OR ([upsize_ts] = @Original_upsize_ts))) INSERT INTO [C_iva] ([iva], [descrizione], [enabled], [splitPay]) VALUES (@iva, @descrizione, @enabled, @splitPay); SELECT C_iva, iva, descrizione, upsize_ts, enabled, splitPay FROM C_iva WHERE (C_iva = SCOPE_IDENTITY()) ORDER BY enabled DESC, iva DESC, descrizione SELECT * FROM C_iva ORDER BY enabled DESC, iva DESC, descrizione UPDATE [C_iva] SET [iva] = @iva, [descrizione] = @descrizione, [enabled] = @enabled, [splitPay] = @splitPay WHERE (([C_iva] = @Original_C_iva) AND ((@IsNull_upsize_ts = 1 AND [upsize_ts] IS NULL) OR ([upsize_ts] = @Original_upsize_ts))); SELECT C_iva, iva, descrizione, upsize_ts, enabled, splitPay FROM C_iva WHERE (C_iva = @C_iva) ORDER BY enabled DESC, iva DESC, descrizione dbo.stp_VAT_deleteQuery dbo.stp_VAT_updateQuery DELETE FROM [dbo].[clienti] WHERE (([idxCli] = @Original_idxCli) AND ((@IsNull_codiceCliente = 1 AND [codiceCliente] IS NULL) OR ([codiceCliente] = @Original_codiceCliente)) AND ((@IsNull_RagSoc = 1 AND [RagSoc] IS NULL) OR ([RagSoc] = @Original_RagSoc)) AND ((@IsNull_P_iva = 1 AND [P_iva] IS NULL) OR ([P_iva] = @Original_P_iva)) AND ((@IsNull_C_Fisc = 1 AND [C_Fisc] IS NULL) OR ([C_Fisc] = @Original_C_Fisc)) AND ([pec] = @Original_pec) AND ([codUnivoco] = @Original_codUnivoco) AND ((@IsNull_via = 1 AND [via] IS NULL) OR ([via] = @Original_via)) AND ((@IsNull_località = 1 AND [località] IS NULL) OR ([località] = @Original_località)) AND ((@IsNull_cap = 1 AND [cap] IS NULL) OR ([cap] = @Original_cap)) AND ((@IsNull_provincia = 1 AND [provincia] IS NULL) OR ([provincia] = @Original_provincia)) AND ((@IsNull_pagamento = 1 AND [pagamento] IS NULL) OR ([pagamento] = @Original_pagamento)) AND ((@IsNull_idxGruppo = 1 AND [idxGruppo] IS NULL) OR ([idxGruppo] = @Original_idxGruppo)) AND ((@IsNull_valuta = 1 AND [valuta] IS NULL) OR ([valuta] = @Original_valuta)) AND ([attivo] = @Original_attivo) AND ([Cod_cli] = @Original_Cod_cli) AND ((@IsNull_codice_cliente = 1 AND [codice cliente] IS NULL) OR ([codice cliente] = @Original_codice_cliente)) AND ([id_ext] = @Original_id_ext)) INSERT INTO [dbo].[clienti] ([codiceCliente], [RagSoc], [P_iva], [C_Fisc], [pec], [codUnivoco], [via], [località], [cap], [provincia], [pagamento], [note], [idxGruppo], [valuta], [attivo], [id_ext]) VALUES (@codiceCliente, @RagSoc, @P_iva, @C_Fisc, @pec, @codUnivoco, @via, @località, @cap, @provincia, @pagamento, @note, @idxGruppo, @valuta, @attivo, @id_ext); SELECT idxCli, codiceCliente, RagSoc, P_iva, C_Fisc, pec, codUnivoco, via, località, cap, provincia, pagamento, note, idxGruppo, valuta, attivo, Cod_cli, [codice cliente], id_ext FROM clienti WHERE (idxCli = SCOPE_IDENTITY()) ORDER BY attivo DESC, RagSoc SELECT * FROM dbo.clienti ORDER BY attivo DESC, RagSoc UPDATE [dbo].[clienti] SET [codiceCliente] = @codiceCliente, [RagSoc] = @RagSoc, [P_iva] = @P_iva, [C_Fisc] = @C_Fisc, [pec] = @pec, [codUnivoco] = @codUnivoco, [via] = @via, [località] = @località, [cap] = @cap, [provincia] = @provincia, [pagamento] = @pagamento, [note] = @note, [idxGruppo] = @idxGruppo, [valuta] = @valuta, [attivo] = @attivo, [id_ext] = @id_ext WHERE (([idxCli] = @Original_idxCli) AND ((@IsNull_codiceCliente = 1 AND [codiceCliente] IS NULL) OR ([codiceCliente] = @Original_codiceCliente)) AND ((@IsNull_RagSoc = 1 AND [RagSoc] IS NULL) OR ([RagSoc] = @Original_RagSoc)) AND ((@IsNull_P_iva = 1 AND [P_iva] IS NULL) OR ([P_iva] = @Original_P_iva)) AND ((@IsNull_C_Fisc = 1 AND [C_Fisc] IS NULL) OR ([C_Fisc] = @Original_C_Fisc)) AND ([pec] = @Original_pec) AND ([codUnivoco] = @Original_codUnivoco) AND ((@IsNull_via = 1 AND [via] IS NULL) OR ([via] = @Original_via)) AND ((@IsNull_località = 1 AND [località] IS NULL) OR ([località] = @Original_località)) AND ((@IsNull_cap = 1 AND [cap] IS NULL) OR ([cap] = @Original_cap)) AND ((@IsNull_provincia = 1 AND [provincia] IS NULL) OR ([provincia] = @Original_provincia)) AND ((@IsNull_pagamento = 1 AND [pagamento] IS NULL) OR ([pagamento] = @Original_pagamento)) AND ((@IsNull_idxGruppo = 1 AND [idxGruppo] IS NULL) OR ([idxGruppo] = @Original_idxGruppo)) AND ((@IsNull_valuta = 1 AND [valuta] IS NULL) OR ([valuta] = @Original_valuta)) AND ([attivo] = @Original_attivo) AND ([Cod_cli] = @Original_Cod_cli) AND ((@IsNull_codice_cliente = 1 AND [codice cliente] IS NULL) OR ([codice cliente] = @Original_codice_cliente)) AND ([id_ext] = @Original_id_ext)); SELECT idxCli, codiceCliente, RagSoc, P_iva, C_Fisc, pec, codUnivoco, via, località, cap, provincia, pagamento, note, idxGruppo, valuta, attivo, Cod_cli, [codice cliente], id_ext FROM clienti WHERE (idxCli = @idxCli) ORDER BY attivo DESC, RagSoc dbo.stp_clienti_deleteQuery dbo.stp_clienti_getByAnno dbo.stp_clienti_getByKey dbo.stp_clienti_updateCodExt dbo.stp_clienti_updateQuery DELETE FROM [dbo].[Scadenze] WHERE (([Id_fatt] = @Original_Id_fatt) AND ([data] = @Original_data) AND ((@IsNull_netto = 1 AND [netto] IS NULL) OR ([netto] = @Original_netto)) AND ((@IsNull_importo = 1 AND [importo] IS NULL) OR ([importo] = @Original_importo)) AND ((@IsNull_note = 1 AND [note] IS NULL) OR ([note] = @Original_note))) INSERT INTO [dbo].[Scadenze] ([Id_fatt], [data], [netto], [importo], [note]) VALUES (@Id_fatt, @data, @netto, @importo, @note); SELECT Id_fatt, data, netto, importo, note FROM Scadenze WHERE (Id_fatt = @Id_fatt) AND (data = @data) SELECT Id_fatt, data, netto, importo, note FROM dbo.Scadenze UPDATE [dbo].[Scadenze] SET [Id_fatt] = @Id_fatt, [data] = @data, [netto] = @netto, [importo] = @importo, [note] = @note WHERE (([Id_fatt] = @Original_Id_fatt) AND ([data] = @Original_data) AND ((@IsNull_netto = 1 AND [netto] IS NULL) OR ([netto] = @Original_netto)) AND ((@IsNull_importo = 1 AND [importo] IS NULL) OR ([importo] = @Original_importo)) AND ((@IsNull_note = 1 AND [note] IS NULL) OR ([note] = @Original_note))); SELECT Id_fatt, data, netto, importo, note FROM Scadenze WHERE (Id_fatt = @Id_fatt) AND (data = @data) dbo.stp_creaScadenze dbo.stp_setPagato dbo.stp_StatoIPS_getFilt DELETE FROM [dbo].[Pagamenti] WHERE (([Id_fatt] = @Original_Id_fatt) AND ([data] = @Original_data) AND ((@IsNull_netto = 1 AND [netto] IS NULL) OR ([netto] = @Original_netto)) AND ((@IsNull_importo = 1 AND [importo] IS NULL) OR ([importo] = @Original_importo)) AND ((@IsNull_note = 1 AND [note] IS NULL) OR ([note] = @Original_note))) INSERT INTO [dbo].[Pagamenti] ([Id_fatt], [data], [netto], [importo], [note]) VALUES (@Id_fatt, @data, @netto, @importo, @note); SELECT Id_fatt, data, netto, importo, note FROM Pagamenti WHERE (Id_fatt = @Id_fatt) AND (data = @data) SELECT Id_fatt, data, netto, importo, note FROM dbo.Pagamenti UPDATE [dbo].[Pagamenti] SET [Id_fatt] = @Id_fatt, [data] = @data, [netto] = @netto, [importo] = @importo, [note] = @note WHERE (([Id_fatt] = @Original_Id_fatt) AND ([data] = @Original_data) AND ((@IsNull_netto = 1 AND [netto] IS NULL) OR ([netto] = @Original_netto)) AND ((@IsNull_importo = 1 AND [importo] IS NULL) OR ([importo] = @Original_importo)) AND ((@IsNull_note = 1 AND [note] IS NULL) OR ([note] = @Original_note))); SELECT Id_fatt, data, netto, importo, note FROM Pagamenti WHERE (Id_fatt = @Id_fatt) AND (data = @data) dbo.stp_pag_deleteQuery dbo.stp_pag_getByIdxFatt dbo.stp_StatoMarg_getFilt SELECT IdxFatt, anno, num, netto, note FROM dbo.v_CostiAss dbo.stp_CA_deleteQuery dbo.stp_CA_getByIdxFatt dbo.stp_CA_upsertQuery dbo.stp_fatt_uplStats SELECT value, label FROM dbo.[v_selGruppi] dbo.stp_fattureAperte