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

1 vote214 views1 answer
Mysql check table exists
SQL
22 votes205 views3 answers
Join three tables sql
SQL
0 vote226 views2 answers
What is the default password for sql server sa
SQL
3 votes222 views1 answer
Dbms_scheduler drop_job
SQL
0 vote222 views1 answer
Sql DATE = GETDATE()
SQL
0 vote216 views1 answer
Mysql grant grant option
SQL
0 vote221 views1 answer
Postgres set default schema
SQL
0 vote219 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote220 views1 answer
Azure sql server check foreign key
SQL
0 vote214 views1 answer
EnvironmentError: mysql_config not found
SQL