Comments
Sort by recent activity
This appears to work. Thank you for your help and patience. / comments
This appears to work. Thank you for your help and patience.
So the dev team broke something and doesn't have time to fix it in the "foreseeable future". Is this correct? / comments
So the dev team broke something and doesn't have time to fix it in the "foreseeable future". Is this correct?
Number of spaces in tabs = 4; I still have the same trouble / comments
Number of spaces in tabs = 4; I still have the same trouble
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....