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 votes398 views1 answer
Mysql select true or false
SQL
4 votes412 views1 answer
Mysql delete last row
SQL
0 vote366 views1 answer
Adding primery key constraint to a column
SQL
28 votes355 views6 answers
Mysql change user password
SQL
1 vote381 views1 answer
T-sql find object by name
SQL
31 votes345 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote342 views1 answer
Query on date sqlite flutter
SQL
1 vote340 views1 answer
Postgresql transaction discard all
SQL
46 votes404 views4 answers
Create column sql
SQL
2 votes363 views1 answer
Oracle sql merge
SQL