DELETE FROM [dbo].[T_anagFiltro] WHERE (([idxFiltro] = @Original_idxFiltro) AND ((@IsNull_filtro = 1 AND [filtro] IS NULL) OR ([filtro] = @Original_filtro))) INSERT INTO [dbo].[T_anagFiltro] ([filtro]) VALUES (@filtro); SELECT idxFiltro, filtro FROM T_anagFiltro WHERE (idxFiltro = SCOPE_IDENTITY()) SELECT idxFiltro, filtro FROM dbo.T_anagFiltro UPDATE [dbo].[T_anagFiltro] SET [filtro] = @filtro WHERE (([idxFiltro] = @Original_idxFiltro) AND ((@IsNull_filtro = 1 AND [filtro] IS NULL) OR ([filtro] = @Original_filtro))); SELECT idxFiltro, filtro FROM T_anagFiltro WHERE (idxFiltro = @idxFiltro) DELETE FROM [dbo].[T_logUtente] WHERE (([idxNota] = @Original_idxNota) AND ((@IsNull_dataNota = 1 AND [dataNota] IS NULL) OR ([dataNota] = @Original_dataNota)) AND ((@IsNull_userNota = 1 AND [userNota] IS NULL) OR ([userNota] = @Original_userNota)) AND ((@IsNull_nota = 1 AND [nota] IS NULL) OR ([nota] = @Original_nota)) AND ((@IsNull_idxFiltro = 1 AND [idxFiltro] IS NULL) OR ([idxFiltro] = @Original_idxFiltro)) AND ((@IsNull_val = 1 AND [val] IS NULL) OR ([val] = @Original_val))) INSERT INTO [dbo].[T_logUtente] ([dataNota], [userNota], [nota], [idxFiltro], [val]) VALUES (@dataNota, @userNota, @nota, @idxFiltro, @val); SELECT idxNota, dataNota, userNota, nota, idxFiltro, val FROM T_logUtente WHERE (idxNota = SCOPE_IDENTITY()) SELECT idxNota, dataNota, userNota, nota, idxFiltro, val FROM dbo.T_logUtente UPDATE [dbo].[T_logUtente] SET [dataNota] = @dataNota, [userNota] = @userNota, [nota] = @nota, [idxFiltro] = @idxFiltro, [val] = @val WHERE (([idxNota] = @Original_idxNota) AND ((@IsNull_dataNota = 1 AND [dataNota] IS NULL) OR ([dataNota] = @Original_dataNota)) AND ((@IsNull_userNota = 1 AND [userNota] IS NULL) OR ([userNota] = @Original_userNota)) AND ((@IsNull_nota = 1 AND [nota] IS NULL) OR ([nota] = @Original_nota)) AND ((@IsNull_idxFiltro = 1 AND [idxFiltro] IS NULL) OR ([idxFiltro] = @Original_idxFiltro)) AND ((@IsNull_val = 1 AND [val] IS NULL) OR ([val] = @Original_val))); SELECT idxNota, dataNota, userNota, nota, idxFiltro, val FROM T_logUtente WHERE (idxNota = @idxNota) SELECT T_logUtente.idxNota, T_logUtente.dataNota, T_logUtente.userNota, T_logUtente.nota, T_logUtente.idxFiltro, T_logUtente.val FROM T_logUtente INNER JOIN T_anagFiltro ON T_logUtente.idxFiltro = T_anagFiltro.idxFiltro WHERE (T_anagFiltro.filtro LIKE @filtro + '%') dbo.sp_insLogUtFull SELECT idxNota, filtro, dataNota, userNota, nota, val, numRec FROM dbo.v_logUtente dbo.S_v_logUtente DELETE FROM [dbo].[T_anagRecord] WHERE (([idxTipoRec] = @Original_idxTipoRec) AND ((@IsNull_descrRec = 1 AND [descrRec] IS NULL) OR ([descrRec] = @Original_descrRec))) INSERT INTO [dbo].[T_anagRecord] ([descrRec]) VALUES (@descrRec); SELECT idxTipoRec, descrRec FROM T_anagRecord WHERE (idxTipoRec = SCOPE_IDENTITY()) SELECT idxTipoRec, descrRec FROM dbo.T_anagRecord UPDATE [dbo].[T_anagRecord] SET [descrRec] = @descrRec WHERE (([idxTipoRec] = @Original_idxTipoRec) AND ((@IsNull_descrRec = 1 AND [descrRec] IS NULL) OR ([descrRec] = @Original_descrRec))); SELECT idxTipoRec, descrRec FROM T_anagRecord WHERE (idxTipoRec = @idxTipoRec) DELETE FROM [dbo].[T_logRecords] WHERE (([idxRecord] = @Original_idxRecord) AND ([dataOra] = @Original_dataOra) AND ([userEv] = @Original_userEv) AND ((@IsNull_pagina = 1 AND [pagina] IS NULL) OR ([pagina] = @Original_pagina)) AND ((@IsNull_idxTipoRec = 1 AND [idxTipoRec] IS NULL) OR ([idxTipoRec] = @Original_idxTipoRec)) AND ((@IsNull_idxFiltro = 1 AND [idxFiltro] IS NULL) OR ([idxFiltro] = @Original_idxFiltro)) AND ((@IsNull_valOrig = 1 AND [valOrig] IS NULL) OR ([valOrig] = @Original_valOrig)) AND ((@IsNull_valNew = 1 AND [valNew] IS NULL) OR ([valNew] = @Original_valNew)) AND ((@IsNull_idxNota = 1 AND [idxNota] IS NULL) OR ([idxNota] = @Original_idxNota)) AND ((@IsNull_cestinato = 1 AND [cestinato] IS NULL) OR ([cestinato] = @Original_cestinato))) INSERT INTO [dbo].[T_logRecords] ([dataOra], [userEv], [pagina], [idxTipoRec], [idxFiltro], [valOrig], [valNew], [idxNota], [cestinato]) VALUES (@dataOra, @userEv, @pagina, @idxTipoRec, @idxFiltro, @valOrig, @valNew, @idxNota, @cestinato); SELECT idxRecord, dataOra, userEv, pagina, idxTipoRec, idxFiltro, valOrig, valNew, idxNota, cestinato FROM T_logRecords WHERE (idxRecord = SCOPE_IDENTITY()) SELECT * FROM dbo.T_logRecords UPDATE [dbo].[T_logRecords] SET [dataOra] = @dataOra, [userEv] = @userEv, [pagina] = @pagina, [idxTipoRec] = @idxTipoRec, [idxFiltro] = @idxFiltro, [valOrig] = @valOrig, [valNew] = @valNew, [idxNota] = @idxNota, [cestinato] = @cestinato WHERE (([idxRecord] = @Original_idxRecord) AND ([dataOra] = @Original_dataOra) AND ([userEv] = @Original_userEv) AND ((@IsNull_pagina = 1 AND [pagina] IS NULL) OR ([pagina] = @Original_pagina)) AND ((@IsNull_idxTipoRec = 1 AND [idxTipoRec] IS NULL) OR ([idxTipoRec] = @Original_idxTipoRec)) AND ((@IsNull_idxFiltro = 1 AND [idxFiltro] IS NULL) OR ([idxFiltro] = @Original_idxFiltro)) AND ((@IsNull_valOrig = 1 AND [valOrig] IS NULL) OR ([valOrig] = @Original_valOrig)) AND ((@IsNull_valNew = 1 AND [valNew] IS NULL) OR ([valNew] = @Original_valNew)) AND ((@IsNull_idxNota = 1 AND [idxNota] IS NULL) OR ([idxNota] = @Original_idxNota)) AND ((@IsNull_cestinato = 1 AND [cestinato] IS NULL) OR ([cestinato] = @Original_cestinato))); SELECT idxRecord, dataOra, userEv, pagina, idxTipoRec, idxFiltro, valOrig, valNew, idxNota, cestinato FROM T_logRecords WHERE (idxRecord = @idxRecord) dbo.sp_cestinaLogRecFiltro dbo.sp_cestinaLogRecUt dbo.sp_deleteLogMaxData dbo.sp_deleteLogUser dbo.sp_insRecFull dbo.sp_setLastRec2nota dbo.sp_setRec2nota SELECT idxRecord, dataOra, userEv, SIGLA, pagina, descrRec, filtro, valOrig, valNew, idxNota, cestinato FROM dbo.v_logRecords dbo.S_v_logRecords