Options
No suggestion before analytical function
buckley
Posts: 69
I took the time to come up with this self contained example.
Can you reproduce ?
SELECT
*,
d. -- no intellisense
COUNT(*) OVER (PARTITION BY col1) AS myCount
FROM
(SELECT
1 col1,
'A' col2
UNION ALL
SELECT
1 col1,
'B' col2
UNION ALL
SELECT
2 col1,
'A' col2
UNION ALL
SELECT
2 col1,
'B' col2) d
It's probably related to the following reported case
http://www.red-gate.com/MessageBoard/vi ... hp?p=67146
Can you reproduce ?
SELECT
*,
d. -- no intellisense
COUNT(*) OVER (PARTITION BY col1) AS myCount
FROM
(SELECT
1 col1,
'A' col2
UNION ALL
SELECT
1 col1,
'B' col2
UNION ALL
SELECT
2 col1,
'A' col2
UNION ALL
SELECT
2 col1,
'B' col2) d
It's probably related to the following reported case
http://www.red-gate.com/MessageBoard/vi ... hp?p=67146
Comments