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 vote202 views1 answer
Merge clause with inner join
SQL
5 votes196 views1 answer
Sql asynchronous stored procedure call
SQL
0 vote200 views1 answer
Power bi union columns
SQL
0 vote232 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
0 vote212 views1 answer
Sql select sum group by id laravel join
SQL
5 votes213 views2 answers
Postgres update with if condition query
SQL
-1 vote204 views1 answer
Ssms connect with connection string
SQL
0 vote194 views1 answer
Sql select min row
SQL
0 vote201 views1 answer
Optimize sql query
SQL
0 vote211 views1 answer
Run mysql xampp shell
SQL