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

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.

kevriley April 20, 2017 13:39

Comments

2 comments

Hi Kev,

Thanks for the suggestion. If I'm understanding correctly, you are suggesting that SELECT statements should be expandable in the Summarize Script feature so that you can see any subqueries in the tree.

At the moment we have basic SELECT statement handling in Summarize Script, we only show whether it is a SELECT FROM <table> or SELECT <expression>.

If you think this would be a useful feature, would it be possible to add the suggestion on our UserVoice page to allow other users to vote on it?
https://redgate.uservoice.com/forums/94413-sql-prompt

Best wishes,

Michael Clark
Technical Lead, SQL Prompt

Michael Clark April 21, 2017 11:56

0
Done!

Link here for anyone else reading this post who wants to vote: https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/19043938-include-any-referenced-object-in-summarize-script

kevriley April 25, 2017 12:36

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Summarize script ignoring certain query patterns

Comments

Add comment