Comments
Sort by recent activity
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.
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...
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.
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.
Thanks for the URL, I can use that and replace the build number as later versions are released. I have been keeping any eye on this URL but it's pointing at 10.6 instead of 10.7: https://www.red-gate.com/sqlprompt/latestreleasenotes This URL has the wrong date for 10.7 by the way: https://documentation.red-gate.com/sp/release-notes-and-other-versions / comments
Thanks for the URL, I can use that and replace the build number as later versions are released.I have been keeping any eye on this URL but it's pointing at 10.6 instead of 10.7:https://www.red-gate...