-
Notifications
You must be signed in to change notification settings - Fork 433
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