SQL Prompt v7.0.0.41 merge $action
jsreynolds1
Posts: 96 Silver 2
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.
Best,
John
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
Thanks for raising this, we can reproduce it so we’ll start working on a fix now.
You can work around this temporarily by going into SQL Prompt > Options > Format > Actions and unticking “Add/remove square bracketsâ€.
Thanks
Ali
We think we've got a fix for this issue in this private build, please could you give it a try and let us know how you get on.
Thanks
Ali
Thanks,
John