On-demand training: More Gems from the SQL Prompt Treasure Chest. Watch now.
Removal of space before FROM in sub-query undesired, how to stop it?
I have the following Sql query and Sql Prompt insists on removing the space before the FROM in the sub-query every time. How do I stop this?
SELECT TOP (50000000)
SELECT COUNT(r.Id)FROM dbo.Results r WHERE r.RunId = Run.Id
WHERE 1 = 1
AND CreationTime >= '2021-03-01'
AND Duration IS NOT NULL
ORDER BY Run.Id;
0 · Share on Twitter