What are the challenges you face when working across database platforms? Take the survey
Options

Possible Formating Bug I found

MattOMattO Posts: 8
edited August 1, 2017 12:56PM in SQL Refactor Previous Versions
I have the following statment:
INSERT INTO TATX1030
                      (TRX_I, EMPID_I, JOBTITLE, DEPRTMNT, DIVISIONCODE_I, TIMECODE_I, TRXDATE, HOURS_I, ACCFLG, ATTTYP, ATTRSN, ATTTRXSTATUS, 
                      PAYRCORD, CHANGEBY_I, CHANGEDATE_I, CHANGETIME_I)
VALUES     (@nextTrxID,@empID,@jobtitle,@Deprtmnt,@divisionCode,@timecode,@currentDate,@hoursToAdjust, 1,@type,@reason, 5,@paycode, 
                      LEFT(SUSER_NAME(), 15),@currentDate,@currentTime)

Which is on a few lines. If I have refactor do the Layout SQL option it always formats it like this:
INSERT
INTO TATX1030
  (
    TRX_I,
    EMPID_I,
    JOBTITLE,
    DEPRTMNT,
    DIVISIONCODE_I,
    TIMECODE_I,
    TRXDATE,
    HOURS_I,
    ACCFLG,
    ATTTYP,
    ATTRSN,
    ATTTRXSTATUS,
    PAYRCORD,
    CHANGEBY_I,
    CHANGEDATE_I,
    CHANGETIME_I )
VALUES
  (
    @nextTrxID,
    @empID,
    @jobtitle,
    @Deprtmnt,
    @divisionCode,
    @timecode,
    @currentDate,
    @hoursToAdjust,
    1,
    @type,
    @reason,
    5,
    @paycode,
    LEFT(SUSER_NAME(), 15),
    @currentDate,
    @currentTime
  )

I have disabled all the options to prohibit this, and yet it still is persistent on doing a new line for every column/parameter.

You can see screenshots of ALL of my settings here:

http://www.ottechnologies.com/downloads ... ttings.doc

We plan on purchasing this product. Any assistance with this issue would be greatly appreciated.

FYI, I am using SQL 2005 Management Studio.

Comments

Sign In or Register to comment.