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

94 votes176 views4 answers
Create database postgres
SQL
-1 vote169 views3 answers
SQL MM/dd/yyyy format
SQL
0 vote137 views1 answer
SQL FROM-Klausel
SQL
4 votes128 views1 answer
Psql get sequences
SQL
1 vote146 views1 answer
Oracle user last connection date
SQL
1 vote143 views2 answers
Mysql between
SQL
1 vote122 views1 answer
Sql server reseed single table
SQL
1 vote128 views1 answer
Create sample data postgresql
SQL
7 votes128 views2 answers
Show size database mysql
SQL
1 vote124 views1 answer
How to get mysql db size
SQL