Using OPENQUERY
Hi,
Is there any documentation on how to best use OPENQUERY wirth Active QueryBuilder?
I have an example query which produces results, but very little shows in the query builder pane:
Select *From OpenQuery(LinkedServer, 'SELECT TOP 100 * FROM TABLE')
Many thanks,
Michael
Is there any documentation on how to best use OPENQUERY wirth Active QueryBuilder?
I have an example query which produces results, but very little shows in the query builder pane:
Select *From OpenQuery(LinkedServer, 'SELECT TOP 100 * FROM TABLE')
Many thanks,
Michael
It is not possible to get the diagram of the inner query. You can only copy the inner query text and design as a separate query.