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 vote261 views1 answer
Mysql update set sum
SQL
0 vote294 views1 answer
Database schema for mcqs type exam in sql
SQL
0 vote244 views1 answer
Update sqlite
SQL
0 vote253 views1 answer
Postgresql create user roles
SQL
14 votes257 views1 answer
Oracle new column
SQL
0 vote272 views1 answer
ACCEPT nome PROMPT on oracle
SQL
0 vote258 views1 answer
How to add boolean column in postgresql
SQL
14 votes272 views3 answers
Inner join sql oracle
SQL
0 vote271 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
1 vote256 views2 answers
Find nth highest salary of an employee
SQL