What are the challenges you face when working across database platforms? Take the survey
Options

Summarize script ignoring certain query patterns

I'm using SQL Prompt 7.5.1.1000

When I choose Summarize Script for the following query
USE [AdventureWorks2014]
GO
select
	(select top 1 emailaddress from Person.EmailAddress),
	dbo.ufnGetPurchaseOrderStatusText(1)
from Person.Person

I get the results
1q93x6nr9yd5.png

Notice how the outer table reference is listed but not the table in the subquery, nor the scalar function.

I would expect these to show in the summary, as they are user objects referenced by the query.

Comments

Sign In or Register to comment.