SQL Prompt v7.0.0.41 merge $action

jsreynolds1jsreynolds1 Posts: 82 Silver 1
edited September 8, 2015 7:11PM in SQL Prompt
Hello,

It seems that SQL Prompt is placing brackets around a merge statement's $action and thus rendering it problematic.
Below when I do a ctrl-k-y (format sql) it slaps brackets around the $action.
        WHEN NOT MATCHED BY SOURCE AND ([FileListing].[StoreNum] = @Store
                                        AND [FileListing].[BusinessDate] BETWEEN @From AND @Thru
                                       ) THEN
            DELETE
        OUTPUT
            $action AS [Action],
            [Deleted].[FileListingID],
            [Deleted].[StoreNum],
            [Deleted].[BusinessDate],
            [Deleted].[ProductionFileID],
            [Deleted].[Bytes] AS [OriginalBytes],
            [Source].[Bytes] AS [NewBytes],
            [Deleted].[Created] AS [OldCreated],
            [Source].[Created] AS [NewCreated],
            [Deleted].[Modified] AS [OldModified],
            [Source].[Modified] AS [NewModified]

	) AS [Merger]
            WHERE   [Action] <> 'INSERT';


Best,

John

Comments

Sign In or Register to comment.