Activity overview
Latest activity by srosenbach
Actually, I have the opposite problem - it seems as if SQL Prompt adds a newline after FROM and JOIN and puts the rest of the FROM and JOIN clauses on the next line, like this:
SELECT
fp.PatientID
, tc.ProgID
, fp.DataCollectionDate
FROM
dbo.FormPat fp
JOIN
dbo.TxCyclePhase tcp ON fp.TxCyclePhase = tcp.TxCyclePhaseID
JOIN
dbo.TxCycle tc ON tcp.TxCycle = tc.TxCycleID
JOIN
dbo.Patient p ON fp.PatientID = p.PatientID
whereas what I want is this:
SELECT
fp.PatientID
, tc.ProgID
, fp.DataCollectionDate
FROM dbo.FormPat fp
JOIN dbo.TxCyclePhase tcp ON fp.TxCyclePhase = tcp.TxCyclePhaseID
Can anyone help me with this? Many thanks! / comments
Actually, I have the opposite problem - it seems as if SQL Prompt adds a newline after FROM and JOIN and puts the rest of the FROM and JOIN clauses on the next line, like this:
SELECT
fp.PatientID
...