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

3 votes187 views2 answers
Mysql create timestamp column
SQL
0 vote184 views1 answer
Psql check if value in array
SQL
-1 vote201 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
3 votes191 views2 answers
Mysql time
SQL
0 vote176 views1 answer
Check if a word appears at the end sql query
SQL
0 vote247 views1 answer
Tsql find procedure with name
SQL
2 votes207 views3 answers
Sql interview query questions
SQL
0 vote216 views1 answer
Running percentage of total postgres
SQL
3 votes194 views1 answer
Locate sql server
SQL
1 vote227 views3 answers
Default password of mysql
SQL