Comments
Sort by recent activity
I'm sorry about this - it's becoming a bigger problem than necessary. I simply would like this SQL: select
x
, date1
, date2
, username
from tablename
where x = 1 and date1 between '2017-01-01' and '2017-01-31';
to be formatted like this: select
x
, date1
, date2
, username
from tablename
where
x = 1
and date1 between '2017-01-01' and '2017-01-31';
The indent is one tab created only with standard tabs (not spaces) so that our documentation system will copy the code correctly. This used to work prior to the December 2017 release when the behavior for 'subsequent items' changed. Earlier in this thread, I attached the style file. If this is possible, please let me know which SQL Prompt style settings will accomplish this. If this is not possible and there will be no patch for this, please let me know and I will request a refund from my recent renewal. / comments
I'm sorry about this - it's becoming a bigger problem than necessary. I simply would like this SQL:select
x
, date1
, date2
, username
from tablename
where x = 1 and date1 between '2017-01-01' and...
Yes, I meant to use "Only Tabs". / comments
Yes, I meant to use "Only Tabs".
I am experiencing different behavior after upgrade, but it is also not the expected behavior. I am expecting that selecting the "Indent List Items" checkbox should indent not only the first list item, but all subsequent list items; see attached picture [image] / comments
I am experiencing different behavior after upgrade, but it is also not the expected behavior. I am expecting that selecting the "Indent List Items" checkbox should indent not only the first list i...
select
TerritoryID
, Name
, [Group] -- nvarchar(50)
, SalesYTD as YearToDate -- money
, SalesLastYear as LastYear -- money
from Sales.SalesTerritory / comments
select
TerritoryID
, Name
, [Group] -- nvarchar(50)
, SalesYTD as YearToDate -- money
, SalesLastYear as LastYear -- money
from Sales.SalesTerritory
Attached is the style file (zipped). For the above query, I am expecting SQLPrompt to format using all tabs for the list items, starting with the first list item and all subsequent column names indented. / comments
Attached is the style file (zipped). For the above query, I am expecting SQLPrompt to format using all tabs for the list items, starting with the first list item and all subsequent column names in...
the style file extension (.log) needs to be removed - the upload tool wouldn't let me use this file without putting a 3 character extension on the file / comments
the style file extension (.log) needs to be removed - the upload tool wouldn't let me use this file without putting a 3 character extension on the file
SQL Prompt 8.0.5.1758
Prompt will change Line 6 of this statement by adding 'as' before 'at time zone':
SELECT
*
FROM (
SELECT
CONVERT(Date, lpr.scandatetimeutc AT TIME ZONE 'UTC' at time zone dlr.tz_name) AS scandate_local
, CONVERT(Time, lpr.scandatetimeutc AT TIME ZONE 'UTC' AT TIME ZONE dlr.tz_name) AS scantime_local
FROM mdlwhs_reporting.dbo.vw_test1 AS lpr
INNER JOIN mdlwhs_reporting.dbo.tmp_test2 AS dlr ON lpr.dealerinfo_dealercode = dlr.dealerinfo_dealercode
) AS sub; / comments
SQL Prompt 8.0.5.1758
Prompt will change Line 6 of this statement by adding 'as' before 'at time zone':
SELECT
*
FROM (
SELECT
CONVERT(Date, lpr.scandatetimeutc AT TIME ZONE 'UTC' at time zone dlr....
This is now working in v8.0.5.1758. / comments
This is now working in v8.0.5.1758.
I have a few queries where I convert a timestamp to utc and then to a local timezone (from a joined table) as such:
convert(date, x.timestamp at time zone 'UTC' at time zone tz_name) as timestamp_local
SQL Prompt will sometimes try to add 'AS' before each 'at' in the statement. / comments
I have a few queries where I convert a timestamp to utc and then to a local timezone (from a joined table) as such:
convert(date, x.timestamp at time zone 'UTC' at time zone tz_name) as timestamp_l...
1) What version of SQL Prompt are you using?
SQL Prompt 7.5.0.675 2) What option do you have set for SQL Prompt > Options > Actions > Apply column alias style?
column AS alias 3) Does this issue still occur if you just use the inbuilt timezones (e.g 'UTC') and not the local timezone from the joined table?
If I use a literal value, this problem does not occur. / comments
1) What version of SQL Prompt are you using?
SQL Prompt 7.5.0.6752) What option do you have set for SQL Prompt > Options > Actions > Apply column alias style?
column AS alias3) Does this issue stil...