Competition: What’s your favorite Redgate tool? Enter now.

Insert on new lines

MikeONeillMikeONeill Posts: 131
edited February 23, 2007 1:12AM in SQL Refactor Previous Versions
Hi

Am I missing a setting ?

I set up the Colums Placement option to first and subsequent columns on new line , ie both boxes ticked

I found the code although nicely readable spread over to much page

I reversed the settings and now the select columns go back to a line but the inserts don't

eg

INSERT INTO @LotsCreated
(
ProcessArea ,
LotCode ,
CreateDate ,
MaterialName
)
SELECT 'WortProduction' , BrewCode , Mash , SpecName
FROM Brew
INNER JOIN SpecNames sn
ON dbo.Brew.SpecNo = sn.SpecNo
WHERE Mash >= @Startdate
AND Mash < @EndDate


I would like to revert to


INSERT INTO @LotsCreated (ProcessArea , LotCode , CreateDate , MaterialName)
SELECT 'WortProduction' , BrewCode , Mash , SpecName
FROM Brew
INNER JOIN SpecNames sn
ON dbo.Brew.SpecNo = sn.SpecNo
WHERE Mash >= @Startdate
AND Mash < @EndDate

Is this a bug or a missing setting or as usual am I doing it wrong somewhere

TA
Sign In or Register to comment.