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 votes133 views3 answers
How to get second highest salary in each department in sql
SQL
1 vote145 views1 answer
Sample clause in sql
SQL
6 votes147 views2 answers
Mysql timestamp to date
SQL
0 vote144 views1 answer
Truncate a table then insert data
SQL
-1 vote126 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
3 votes126 views2 answers
Sql add year to date
SQL
3 votes135 views1 answer
Null sql
SQL
1 vote151 views2 answers
Intersect sql
SQL
0 vote179 views1 answer
How to compile a function in oracle
SQL
3 votes120 views1 answer
Oracle list user grants
SQL