Sorgu 0x3B99B2D11D42D216

(@srv int,@dbName nvarchar(4000),@to datetime)SELECT k.ServerID, k.DatabaseName, k.QueryHash, IIF(k.TrackHash = k.QueryHash, NULL, k.TrackHash) AS LineageOf, t.*
INTO #t
FROM (SELECT DISTINCT a.ServerID, a.DatabaseName, a.QueryHash, a.QueryHash AS TrackHash FROM rag.AnalysisRequest AS a
      WHERE a.TargetType = 'Query' AND a.QueryHash IS NOT NULL
        AND (@srv IS NULL OR a.ServerID = @srv) AND (@dbName IS NULL OR a.DatabaseName = @dbName)
        AND NOT EXISTS (SELECT 1 FROM rag.QueryLineage AS l
                        WHERE l.ServerID = a.ServerID AND l.DatabaseName = a.DatabaseName AND l.NewQueryHash = a.QueryHash)
      UNION
      SELECT ServerID, DatabaseName, QueryHash, QueryHash FROM rag.QuerySnooze AS s
      WHERE (@srv IS NULL OR ServerID = @srv) AND (@dbName IS NULL OR DatabaseName = @dbName)
        AND NOT EXISTS (SELECT 1 FROM rag.QueryLineage AS l
                        WHERE l.ServerID = s.ServerID AND l.DatabaseName = s.DatabaseName AND l.NewQueryHash = s.QueryHash)
      UNION
      SELECT ServerID, DatabaseName, NewQueryHash, OldQueryHash FROM rag.QueryLineage
      WHERE (@srv IS NULL OR ServerID = @srv) AND (@dbName IS NULL OR DatabaseName = @dbName)) AS k
CROSS APPLY rag.fn_QueryTrackState(k.ServerID, k.DatabaseName, k.TrackHash, @to) AS t