Derived table support -- FINALLY!!! Seems to be working pretty well. I've tested both inner joins and CROSS APPLY. Only problem I've found is an annoyance... Type:
SELECT p.
FROM
(
SELECT * from
[HumanResources].Employee
) n
CROSS APPLY
(
Now hit [enter] (at least, I would) and the first column name in the database, alphabetically for all tables, will appear.
I am waiting on some CTE support!
SELECT p.
FROM
(
SELECT * from
[HumanResources].Employee
) n
CROSS APPLY
(
Now hit [enter] (at least, I would) and the first column name in the database, alphabetically for all tables, will appear.
I am waiting on some CTE support!