New features added to SQL Prompt Watch now.

No suggestion before analytical function

buckleybuckley Posts: 69
edited March 6, 2014 9:53AM in SQL Prompt
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

Comments

Sign In or Register to comment.