Is there an option in SQL Prompt Styles to format the Merge statements

DominicV

Is there an option in SQL Prompt Styles to format the Merge statements like below:

From:

  MERGE dbo.TableName AS TARGET

  USING

    (

      SELECT

        @ScheduleId ScheduleId,

        @AgreementID AgreementID

    ) AS SOURCE

  ON (TARGET.ID = SOURCE.ScheduleId)

  WHEN MATCHED THEN UPDATE SET

                      TARGET.AgreementID = SOURCE.AgreementID,

                      TARGET.ScheduleName = SOURCE.ScheduleName

  WHEN NOT MATCHED BY TARGET THEN

    INSERT

      (

        AgreementID,

        ScheduleName

      )

    VALUES

      (

        SOURCE.AgreementID,

        SOURCE.ScheduleName

      );


TO:

  MERGE dbo.TableName AS TARGET

  USING

    (

      SELECT

        @ScheduleId ScheduleId,

        @AgreementID AgreementID

    ) AS SOURCE

  ON (TARGET.ID = SOURCE.ScheduleId)

  WHEN MATCHED
    THEN UPDATE SET

      TARGET.AgreementID = SOURCE.AgreementID,

      TARGET.ScheduleName = SOURCE.ScheduleName

  WHEN NOT MATCHED BY TARGET 

    THEN INSERT

      (

        AgreementID,

        ScheduleName

      )

    VALUES

      (

        SOURCE.AgreementID,

        SOURCE.ScheduleName

      );

Sergio R

I have checked and it doesn't look like it's possible to put  TARGET.AgreementID = SOURCE.AgreementID, in a new line, I am sorry.