I have a problem running this query on a query tag it returns "A result set was generated for update", but when I run it as a named query (substituting the parameters for test) it works, the problem isn't the parameters since the test query also shows this error in the query tag. The thing is I need this query in the query tag since it has parameters referencing other tags.
SELECT COUNT(DISTINCT CAST(Fecha AS VARCHAR) + '_' + CAST(Hora AS VARCHAR)) AS TotalHorasMalas
FROM (
-- Horas malas de Orujos
SELECT CONVERT(DATE, FechaHora) AS Fecha, DATEPART(hour, FechaHora) AS Hora
FROM Laboratorio_NIR
WHERE Orujo_{[.]../Parameters.Line} > 2.8
AND FechaHora <= CAST('{[~]FinTurnoActual}' AS DATETIME)
AND FechaHora > CAST('{[~]InicioTurnoActual}' AS DATETIME)
UNION ALL
-- Horas malas de Sólidos
SELECT CONVERT(DATE, FechaHora) AS Fecha, DATEPART(hour, FechaHora) AS Hora
FROM Laboratorio_Solidos
WHERE (Porcentaje_C1 > 0.2
OR Porcentaje_C2 > 0.2
OR Porcentaje_C3 > 0.2
OR Porcentaje_C4 > 0.2
OR Porcentaje_C5 > 0.2
OR Porcentaje_C6 > 0.2
OR Porcentaje_C7 > 0.2
OR Porcentaje_C8 > 0.2)
AND FechaHora <= CAST('{[~]FinTurnoActual}' AS DATETIME)
AND FechaHora > CAST('{[~]InicioTurnoActual}' AS DATETIME)
UNION ALL
-- Horas malas de Acidez
SELECT CONVERT(DATE, FechaHora) AS Fecha, DATEPART(hour, FechaHora) AS Hora
FROM Laboratorio_FFA
WHERE (FFA_C1 > 5
OR FFA_C2 > 5
OR FFA_C3 > 5
OR FFA_C4 > 5
OR FFA_C5 > 5
OR FFA_C6 > 5
OR FFA_C7 > 5
OR FFA_C8 > 5)
AND FechaHora <= CAST('{[~]FinTurnoActual}' AS DATETIME)
AND FechaHora > CAST('{[~]InicioTurnoActual}' AS DATETIME)
UNION ALL
-- Horas malas de Humedad
SELECT CONVERT(DATE, FechaHora) AS Fecha, DATEPART(hour, FechaHora) AS Hora
FROM Laboratorio_Humedad
WHERE (Porcentaje_C1 > 0.3
OR Porcentaje_C2 > 0.3
OR Porcentaje_C3 > 0.3
OR Porcentaje_C4 > 0.3
OR Porcentaje_C5 > 0.3
OR Porcentaje_C6 > 0.3
OR Porcentaje_C7 > 0.3
OR Porcentaje_C8 > 0.3)
AND FechaHora <= CAST('{[~]FinTurnoActual}' AS DATETIME)
AND FechaHora > CAST('{[~]InicioTurnoActual}' AS DATETIME)
) AS HorasMalas;
