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 vote168 views1 answer
Sql developer format sql
SQL
0 vote181 views1 answer
Date datatype in livesql
SQL
1 vote210 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
2 votes183 views2 answers
Mysql count rows returned
SQL
6 votes155 views4 answers
Sqlite drop table
SQL
6 votes175 views4 answers
Eloquent to sql with bindings
SQL
3 votes166 views1 answer
Delete all content in table mysql
SQL
0 vote157 views1 answer
Mysql start of today
SQL
0 vote182 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
28 votes181 views6 answers
Foreign key
SQL