 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
lee.kindle
Joined: 11 Dec 2014 Posts: 2
|
|
Need help in DB FormattinG |
|
I'm trying to no avail to modify the DB Formatting --> Select template to get my "LEFT OUTER" statement on the same line as the JOIN; see below. I just can't seem to find how to make this happen. Everytime I Ctrl+F11 my code gets reformatted from Desired to Current. Any ideas? Thanks!
Current:
FROM CustomerCode AS sc WITH (NOLOCK)
LEFT OUTER
JOIN (
SELECT sl.CustomerCode.....
Desired:
FROM CustomerCode AS sc WITH (NOLOCK)
LEFT OUTER JOIN (
SELECT sl.CustomerCode.....
[/b][/i]
|
|
Thu Dec 11, 2014 5:58 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
I get LEFT OUTER JOIN on single line. Please try reverting everything to the factory default settings, might be some other customization is impacting the formatting results.
|
|
Thu Dec 11, 2014 6:09 pm |
|
 |
lee.kindle
Joined: 11 Dec 2014 Posts: 2
|
|
|
|
I reverted back to the defaults, but still no luck. Here's my formatting template:
SELECT ... AS ...,
... = ...
INTO ...,
...
FROM ... AS ...,
...
JOIN ...
ON ... = ...
AND ...
WHERE ... = ...
The sql I'm trying to format is:
SELECT 'x' AS ClientID
FROM Client AS c WITH (NOLOCK)
LEFT
JOIN lei
ON lei.[Pre-LEI] = c.LEI
No matter what I try, if I enter any prefix (like left, inner etc) to JOIN it gets put above the JOIN line as in example above.
I'd like to be able to add a LEFT OUTER, or other qualifier and have it just prefix JOIN on same line.
Please help... thanks.
|
|
Tue Jan 06, 2015 2:54 pm |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|