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 vote251 views1 answer
Sql if clause within where clause
SQL
1 vote227 views2 answers
Populate sql table with random data
SQL
1 vote229 views1 answer
Oracle sql assign unique number to each grouping
SQL
4 votes271 views1 answer
Postgres delete last row
SQL
3 votes256 views1 answer
Sql insert inserted id
SQL
7 votes261 views6 answers
Mysql group concat
SQL
0 vote233 views1 answer
How to find username and password in oracle 18c
SQL
-1 vote237 views1 answer
Sql set max value in column
SQL
2 votes220 views1 answer
Mysql select random id from table
SQL
0 vote264 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL