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...
We would want the data consistently masked, for example the data may be extracted and used for reporting. One report might filter on the currency code where as another report might filter on the currency name, if the data is not consistently masked the first report would give you a different value for USD compared with the second report when selecting US Dollars. Your suggested solution might work if there were just one value per row but what if we had something like "Countries visited in last 90 days", this might have two countries with codes and names as separate elements, e.g. GBR/United Kingdom and USA/United States of America. Are we better off using XML "replace value of" via a SQL command rule? / comments
We would want the data consistently masked, for example the data may be extracted and used for reporting. One report might filter on the currency code where as another report might filter on the cu...
Still not working correctly in 10.0.1.12389. / comments
Still not working correctly in 10.0.1.12389.