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

11 votes158 views2 answers
Sql rank
SQL
1 vote166 views1 answer
Mysql search like order by best match
SQL
0 vote146 views1 answer
Resullt all update knex mysql
SQL
0 vote143 views1 answer
Change role postgres
SQL
0 vote163 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
2 votes151 views1 answer
Oracle convert run_duration to number
SQL
0 vote208 views1 answer
Mac os zsh: command not found: mysql
SQL
1 vote144 views1 answer
Set autoincrement to 0
SQL
1 vote151 views4 answers
Mysqldump 1 table only
SQL
0 vote140 views1 answer
Copy Table from SQL to CSV
SQL