SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Need help in DB FormattinG

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Need help in DB FormattinG
Author Message
lee.kindle



Joined: 11 Dec 2014
Posts: 2

Post Need help in DB FormattinG Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
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 View user's profile Send private message
lee.kindle



Joined: 11 Dec 2014
Posts: 2

Post Reply with quote
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 View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.