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 vote178 views1 answer
How to avoid duplicate records in sqlite
SQL
0 vote178 views1 answer
Sql query for select from specific columns in a table
SQL
0 vote126 views1 answer
Bigquery information_schema schema all columns
SQL
7 votes177 views2 answers
Mysql check db size
SQL
-1 vote179 views1 answer
How to change the auto increment in existing table mysql
SQL
0 vote162 views1 answer
Mysql with
SQL
0 vote175 views1 answer
Mysql beautifier terminla
SQL
9 votes202 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote157 views1 answer
Running query in redshift
SQL
0 vote158 views1 answer
Drop all tables in azure sql database
SQL