Intellisense doesn't work when using CROSS/OUTER APPLY of a user defined table-valued function
When filling in the parameters for the TVF and it has been CROSS/OUTER APPLY'd with a table, the intellisense does not show any of the fields from the table even though they are allowed in the TVF. Even if the parenthesis is closed on the TVF, the table's fields don't show up. The intellisense options that come up are the generic list of dbs, tables, functions, snippets, etc.
E.g. -
SELECT * FROM Users u
CROSS APPLY dbo.FindInvoiceFiles([INTELLISENSE DOESN'T SHOW FIELDS FROM Users table]) fif
3
votes
par20pinspot
shared this idea