Comments
Sort by recent activity
Hi Phil,
I couldn't reproduce your problem running on the latest version of SQL Prompt. When I execute "Format SQL" I am given: SELECT ROW_NUMBER() OVER ( ORDER BY ( SELECT NULL
) )
FROM ( VALUES ( 0), ( 0), ( 0), ( 0), ( 0), ( 0), ( 0), ( 0), ( 0),
( 0) ) a ( n )
CROSS JOIN ( VALUES ( 0), ( 0), ( 0), ( 0), ( 0), ( 0),
( 0), ( 0), ( 0), ( 0) ) b ( n );
Would it be possible to upgrade to SQL Prompt 7.4 beta and try again?
Are you using our new experimental formatter?
Thanks,
Michael / comments
Hi Phil,
I couldn't reproduce your problem running on the latest version of SQL Prompt. When I execute "Format SQL" I am given:SELECT ROW_NUMBER() OVER ( ORDER BY ( SELECT NULL
...
Hi Torsten,
We have added this to our backlog - reference SP-6070.
Thanks,
Michael / comments
Hi Torsten,
We have added this to our backlog - reference SP-6070.
Thanks,
Michael
Hi Torsten,
Our formatting system aligns the first value clause to the second value by default: IF OBJECT_ID('RowOffsetArray', 'U') IS NOT NULL
DROP TABLE RowOffsetArray;
GO
CREATE TABLE dbo.RowOffsetArray ( col1 INT NOT NULL );
GO
-- Insert 20 records
INSERT dbo.RowOffsetArray ( col1 )
VALUES ( 4 )
, ( 12 )
, ( 6 );
GO
Could you confirm that you are using our new beta formatting system?
In the new beta formatting system, we tried to align the first value in the values clause to the second value and it doesn't seem to be possible.
We will add this to our formatting backlog of items to consider before releasing the full version.
Thanks,
Michael / comments
Hi Torsten,
Our formatting system aligns the first value clause to the second value by default:IF OBJECT_ID('RowOffsetArray', 'U') IS NOT NULL
DROP TABLE RowOffsetArray;
GO
CREATE TABLE dbo.Ro...
Hi Tommy,
Unfortunately what you are trying to do is not possible with our current formatting system.
However, we have a new and improved formatting system in beta at the moment which you can enable by ticking "Use new formatting styles" in our "Experimental Features" menu. You can get the beta here - Download SQL Prompt 7.4 beta. [image]
You can then click "Edit styles" to create a custom style: [image]
Our new formatting system will allow you to have both parameters and columns on the same line.
We hope that helps, let us know how you get on :-)
Best,
Michael / comments
Hi Tommy,
Unfortunately what you are trying to do is not possible with our current formatting system.
However, we have a new and improved formatting system in beta at the moment which you can enabl...
Thank you for your email, we have logged a bug SP-6079 and will let you know if we find a fix.
Best,
Michael / comments
Thank you for your email, we have logged a bug SP-6079 and will let you know if we find a fix.
Best,
Michael
Our latest SQL Prompt 7.4 beta fixes this issue: https://forums.red-gate.com/viewtopic.php?f=169&t=80560 / comments
Our latest SQL Prompt 7.4 beta fixes this issue:https://forums.red-gate.com/viewtopic.php?f=169&t=80560
Thanks for reporting this beta formatting issue Torsten. We've got this logged as SP-6092 and will get back to you when we have an update. / comments
Thanks for reporting this beta formatting issue Torsten. We've got this logged as SP-6092 and will get back to you when we have an update.
Thanks for the feedback, I think you have a point there -- we've logged this as SP-6093 and will get back to you if we get a chance to fix it [image] / comments
Thanks for the feedback, I think you have a point there -- we've logged this as SP-6093 and will get back to you if we get a chance to fix it
Thanks for reporting this formatting issue Torsten. We've got this logged as SP-6091 and we will get back to you when we have an update. / comments
Thanks for reporting this formatting issue Torsten. We've got this logged as SP-6091 and we will get back to you when we have an update.
Hi @NCTideFan,
Thanks for reporting, we've made a support ticket for this so they will be investigating the problem shortly.
We want to eliminate Out Of Memory exceptions, so any detail you have are immensely valuable. Like you mentioned, it seems to be worse when running more tools -- this can make it complex to diagnose but we do realise it is a key area for improvement.
Best,
Michael / comments
Hi @NCTideFan,
Thanks for reporting, we've made a support ticket for this so they will be investigating the problem shortly.
We want to eliminate Out Of Memory exceptions, so any detail you have ar...