select Seq , CASE WHEN [Change Value] = 0 THEN [Value] ELSE [Change Value] END AS [ALL Value] FROM dbo.YourTable
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)