- 
                Notifications
    You must be signed in to change notification settings 
- Fork 435
Open
Labels
Description
Input data
UPDATE op
SET
    CalculatorCorporationProductQuoteId = ptu.OriginalCalculatorCorporationProductQuoteId 
OUTPUT inserted.Id,
    inserted.ProductId,
    deleted.CalculatorCorporationProductQuoteId,
    inserted.CalculatorCorporationProductQuoteId,
    inserted.OrderId
INTO
    @UpdatedOrderProducts
FROM
    OrderProduct op
    INNER JOIN ProductsToUpdate ptu ON op.Id = ptu.Id
;Expected Output
UPDATE op
SET
    CalculatorCorporationProductQuoteId = ptu.OriginalCalculatorCorporationProductQuoteId 
OUTPUT inserted.Id,
    inserted.ProductId,
    deleted.CalculatorCorporationProductQuoteId,
    inserted.CalculatorCorporationProductQuoteId,
    inserted.OrderId
INTO
    @UpdatedOrderProducts
FROM
    OrderProduct op
    INNER JOIN ProductsToUpdate ptu ON op.Id = ptu.Id
;Actual Output
UPDATE op
SET
    CalculatorCorporationProductQuoteId = ptu.OriginalCalculatorCorporationProductQuoteId OUTPUT inserted.Id,
    inserted.ProductId,
    deleted.CalculatorCorporationProductQuoteId,
    inserted.CalculatorCorporationProductQuoteId,
    inserted.OrderId
INTO
    @UpdatedOrderProducts
FROM
    OrderProduct op
    INNER JOIN ProductsToUpdate ptu ON op.Id = ptu.Id
;Usage
- How are you calling / using the library? : format on save
- What SQL language(s) does this apply to? SQL server
- Which SQL Formatter version are you using? 4.2.2