Posts
Sort by recent activity
Show Aggregate Result
Great new feature but can we please also have distinct count?Also, all I seem to be able to get with dates is a count, distinct count, min and max would also be useful.
DATETRUNC
SQL prompt doesn't seem to handle DATETRUNC when formatting, instead of this:SELECT DATETRUNC (YEAR, [d].[FullDate]) AS [YearStartDate] FROM [Dim].[Date] AS [d];I get this, which errors when execut...
GREATEST and LAST_VALUE IGNORE NULLS
SQL Prompt incorrectly formats GREATEST and IGNORE NULLS ( as well as PARTITION) with square brackets, which breaks the query, I'm using Azure SQL Database. So you end up with:[GREATEST] ([x].[ColB...
Latest version
When downloading SQL Prompt or SQL Toolbelt installer the included version is 10.6.16 but the documentation says 10.6.18, I'm behind a firewall and can't update directly.
XML sync rule
Is it possible to have something like a Sync rule which can consistently update XML data, for example if the Currency Code element has been masked to USD can the Currency Name element be synced to ...