CASE WHEN isnull(SUM(Opening) ,0))<0 THEN --Here i need to make two columns One with the value of opening and another with zer0 ELSE --Here i need to make two columns One with the value of opening and another with zer0CAST -
select Column_Name= CASE Column_Name WHEN SUM(isnull(Opening,0))< 0 THEN '' ELSE 'do something' END from table_name
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)