Greetings experts. I'm trying to figure something out and I'm having no luck. This query works fine as a direct query but my requirement is to make it into a procedure. The error from the proc is "Invalid object name 'Query'". Here is the query.
-
SELECT TOP 5 Name, Sev, COUNT(SimID) AS Count
-
FROM (
-
SELECT C.Name, B.SimID, (CASE
-
WHEN C.Sev = 1 THEN 'Low'
-
WHEN C.Sev = 2 THEN 'Medium'
-
WHEN C.Sev = 3 THEN 'High' END) AS Severity
-
FROM [LINKEDSRV].[MYDB2].[Entities].[Scan] AS A
-
INNER JOIN [LINKEDSRV].[MYDB2].[Entities].[Result] AS B ON A.Id = B.ScanId
-
INNER JOIN Query AS C ON B.QueryVersionId = C.QueryId
-
WHERE (C.Sev = 1)) AS Z
-
GROUP BY Name, Severity
-
ORDER BY Severity, Count DESC;
-