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 vote79 views1 answer
Mysql 3 months ago
SQL
1 vote47 views1 answer
Mysql get latest duplicate rows
SQL
0 vote48 views1 answer
How to run mysql in git bash
SQL
0 vote43 views1 answer
Mysql auto increment default value with prefix month and year
SQL
1 vote46 views1 answer
Convert varchar to int in sqlite
SQL
0 vote52 views1 answer
Get first 3 letter of department name in sql
SQL
-1 vote40 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
2 votes52 views1 answer
Find all triggers in database
SQL
6 votes42 views1 answer
Update left join mysql
SQL
0 vote48 views1 answer
Sql cnvert bit to nvarchar
SQL