common table expression (CTE)

USE AdventureWorks;
GO
WITH DirReps(ManagerID, DirectReports) AS
(
SELECT ManagerID, COUNT(*)
FROM HumanResources.Employee AS e
WHERE ManagerID IS NOT NULL
GROUP BY ManagerID
)
SELECT ManagerID, DirectReports
FROM DirReps
ORDER BY ManagerID;
GO

SQL Assistant is not able to handle output from CTE... does not recognize columns generated from a CTE

It doesn't currently support Intellisense for CTE. For more details please see http://www.softtreetech.com/support/phpBB2/viewtopic.php?t=23247