Store case result sql

declare
    @val int = 0;

select     
    @val = CASE 
        WHEN MONTH([DATE]) = MONTH(getdate()) AND
        YEAR([DATE]) = YEAR(getdate())
        THEN SUM(PROFIT)
        OVER (PARTITION BY [Name], 
            MONTH([DATE]), YEAR([DATE])) 
        ELSE 0 
        END 
FROM table_name
WHERE [Name] = @Name AND
      MONTH([DATE]) = @Month AND
      YEAR([DATE]) = @Year

print @val

Source: stackoverflow.com

Similar codes

0 vote109 views1 answer
Mysql sum with group by
SQL
8 votes92 views1 answer
Oracle add month
SQL
0 vote100 views1 answer
Big table in mysql
SQL
3 votes105 views3 answers
Your password does not satisfy the current policy requirements
SQL
0 vote146 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
5 votes105 views2 answers
Oracle tables with column name
SQL
-1 vote106 views2 answers
Full join sql
SQL
0 vote104 views1 answer
Sql alternative to max statement
SQL
0 vote94 views1 answer
Mysql start of today
SQL
3 votes142 views1 answer
Oracle nextval insert
SQL