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 vote426 views2 answers
Sqlalchemy default value for column
SQL
0 vote314 views1 answer
Sql database connectivity
SQL
0 vote328 views1 answer
Less than date query sqlachemy
SQL
1 vote332 views1 answer
Right outer vs left outer join
SQL
0 vote289 views2 answers
Spring properties file for db
SQL
0 vote339 views2 answers
Add colum in sql
SQL
0 vote326 views1 answer
SQL SELECT-Klausel
SQL
51 votes554 views6 answers
Opera gx
SQL
0 vote323 views1 answer
Mysql workbench view
SQL
12 votes326 views6 answers
Between in sql
SQL