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 votes339 views1 answer
Mysql change data type of column
SQL
2 votes339 views1 answer
Sql to char function with date
SQL
-1 vote301 views2 answers
How to display top 50 rows?
SQL
0 vote354 views2 answers
Many to many flask-sqlalchemy
SQL
6 votes330 views1 answer
Wordpress change user password sql
SQL
2 votes347 views1 answer
Postgresql update sequence next value
SQL
7 votes358 views5 answers
Max 3 salary in sql
SQL
0 vote372 views1 answer
Mysqldump: error:
SQL
24 votes309 views5 answers
Sql reset auto increment
SQL
0 vote321 views1 answer
Retornar apenas o ano mysql date
SQL