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

8 votes173 views1 answer
Oracle add month
SQL
3 votes175 views1 answer
Start mysql server linux terminal
SQL
10 votes189 views4 answers
Drop primary key
SQL
4 votes200 views2 answers
Xampp mysql database server is not starting mac m1
SQL
13 votes194 views5 answers
Sql default
SQL
0 vote181 views3 answers
Joins and views sql
SQL
0 vote182 views1 answer
Mysql earlier than date
SQL
0 vote197 views1 answer
Psql check table fields
SQL
5 votes197 views1 answer
Mysql select greater than yesterday
SQL
0 vote176 views1 answer
Django how to get query result count
SQL