How can we help you today? How can we help you today?

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

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
      );


DominicV
0

Comments

1 comment

Sort by
  • 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.
    Sergio R
    0

Add comment

Please sign in to leave a comment.