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 vote192 views1 answer
Sql cheetsheet
SQL
-1 vote231 views1 answer
Ms sql select datetime as date
SQL
0 vote187 views1 answer
SQL Server format datetime
SQL
1 vote190 views1 answer
Oracle apex prevent initial load
SQL
0 vote192 views1 answer
Qt qsql check if table exist
SQL
0 vote194 views2 answers
How to start postgresql laravel
SQL
10 votes194 views2 answers
Reset mysql root password mac
SQL
10 votes207 views4 answers
Primary key in sql
SQL
0 vote196 views1 answer
Mysql terminal list table
SQL
3 votes216 views5 answers
Foreign keys
SQL