(useful for scripting small tables of static data) or in native BCP files Source link: https://github.com/ktaranov/sqlserver-kit/blob/master/Powershell/Scripting_Out ...
WHEN purchase_id = 1 THEN DATE_ADD(purchase_date, INTERVAL 1 MONTH) -- May WHEN purchase_id = 2 THEN DATE_ADD(purchase_date, INTERVAL 2 MONTH) -- June WHEN purchase_id = 3 THEN DATE_ADD(purchase_date, ...