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

1 vote137 views2 answers
Postgres cast as decimal
SQL
0 vote131 views1 answer
View acl table oracle
SQL
-1 vote144 views1 answer
Export mysql table to file
SQL
1 vote131 views4 answers
Sequelize migration default value
SQL
1 vote161 views2 answers
Mysql extract number from string
SQL
28 votes136 views4 answers
Delete database mysql
SQL
0 vote157 views1 answer
Get relation data in mysql using query to excel
SQL
12 votes168 views6 answers
How to install sqlite3 in python
SQL
8 votes96 views2 answers
Alter column name in mssql
SQL
244 votes258 views14 answers
Sql n insert
SQL