Skip to content
← SQL Prompt

How can we improve SQL Prompt?

SQL Prompt: Qualify object names

Categories

JUMP TO ANOTHER FORUM

(thinking…)

VALUES

Correctly qualify the Table Value Constructor.

I frequently use a TVC to find the Max value among several values on a single row, as with the following:

;WITH MyCte AS (SELECT 1 AS a, 2 AS b, 3 AS c)
SELECT
MyCte.a,
MyCte.b,
MyCte.c,
HighestNumber = (SELECT MAX(Value.Val) FROM (VALUES (MyCte.a), (MyCte.b), (MyCte.c)) AS Value(Val))
FROM MyCte

When I qualify object names within that script, it incorrectly tries to add the 'Value' as a qualifier within the constructor:

;WITH MyCte AS (SELECT 1 AS a, 2 AS b, 3 AS c)
SELECT 
    MyCte.a,
    MyCte.b,
    MyCte.c,
    HighestNumber = (SELECT MAX(Value.Val) FROM (VALUES (MyCte.a), (MyCte.b), (MyCte.c)) AS Value(Value.Val))
FROM MyCte
1 vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Andrew Higgins shared this idea  ·   ·  Report…  ·  Admin →
completed  ·  Aaron Law responded  · 

Thanks for letting us know about this issue. It should now be fixed in the latest build of SQL Prompt (7.1.0.314)

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Andrew Higgins commented  ·   ·  Report

    That is UNBELIEVABLE customer support. Redgate has seriously impressed me by doing this.

    I've tested the release, and it now works correctly.