Activity overview
Latest activity by ccparkhill
Thanks @Dan_J, very useful. It would be nice to see min/max on date columns too. / comments
Thanks @Dan_J, very useful. It would be nice to see min/max on date columns too.
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.
Thanks, appears to be working fine. / comments
Thanks, appears to be working fine.
Thanks Sujay, I am also seeing a similar issue when adding IGNORE NULLS to FIRST_VALUE: SELECT [d].[FullDate] , FIRST_VALUE ([d].[FullDate]) IGNORE NULLS OVER (PARTITION BY [d].[FinancialYear] ORDER BY [d].[FullDate]) AS [FinYearStartDate] FROM [Dim].[Date] AS [d] ORDER BY 1;
SELECT
[d].[FullDate]
, FIRST_VALUE ([d].[FullDate]) [IGNORE] [NULLS] OVER ([PARTITION] BY [d].[FinancialYear] ORDER BY [d].[FullDate]) AS [FinYearStartDate]
FROM [Dim].[Date] AS [d]
ORDER BY 1;
/ comments
Thanks Sujay, I am also seeing a similar issue when adding IGNORE NULLS to FIRST_VALUE:SELECT [d].[FullDate] , FIRST_VALUE ([d].[FullDate]) IGNORE NULLS OVER (PARTITION BY [d].[FinancialYear] O...
Hi Sujay, I have the latest version, I'm using it against Azure SQL, here are my settings: [image] [image] / comments
Hi Sujay,I have the latest version, I'm using it against Azure SQL, here are my settings:
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 executed:SELECT [DATETRUNC] ([YEAR], [d].[FullDate]) AS [YearStartDate] FROM [Dim].[Date] AS [d]; / comments
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...
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...
Initially the newest release formatted the above query fine, but then it just seemed to revert to the previous behaviour. / comments
Initially the newest release formatted the above query fine, but then it just seemed to revert to the previous behaviour.
I saw that IGNORE NULLS was mentioned in the latest release, but I still have the issue detailed above. / comments
I saw that IGNORE NULLS was mentioned in the latest release, but I still have the issue detailed above.
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...