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

6 votes351 views2 answers
Subtr Oracle ?
SQL
1 vote329 views1 answer
Sql server insert into temp table
SQL
0 vote333 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote303 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
1 vote307 views2 answers
Last working day in week date function in sql
SQL
0 vote341 views1 answer
Run sql script file and changes db name in this file using c#
SQL
0 vote330 views1 answer
R write csv without index
SQL
14 votes355 views5 answers
Set password for postgres user ubuntu
SQL
13 votes339 views3 answers
List all the tables in sql
SQL
3 votes322 views1 answer
How to find names includes in sql
SQL