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

2 votes228 views2 answers
Calculate percentage in sql
SQL
0 vote199 views1 answer
Mysql create table columns with spaces
SQL
3 votes202 views3 answers
How to add month in update sql
SQL
-1 vote204 views1 answer
Mysql order by on condition
SQL
0 vote223 views2 answers
Transaction php
SQL
0 vote211 views1 answer
Postpresql relation not found
SQL
1 vote314 views1 answer
Python clean sql string
SQL
19 votes222 views3 answers
Grant mysql
SQL
0 vote202 views1 answer
Luu ckeditor vao mysql
SQL
3 votes192 views1 answer
Select without null values sql
SQL