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 vote153 views2 answers
Pop sql insert value into
SQL
0 vote162 views3 answers
Delete in SQL SERVER
SQL
0 vote194 views1 answer
Reindexing all tables sql server
SQL
2 votes199 views1 answer
Sql compare strings
SQL
1 vote152 views2 answers
Mysql order by date asc null last
SQL
4 votes155 views4 answers
Sqlite describe table
SQL
3 votes166 views2 answers
Order by postgresql
SQL
0 vote159 views1 answer
Flask sqlalchemy remove duplicates
SQL
1 vote174 views1 answer
Spark sql convert string to date
SQL
0 vote146 views1 answer
Get first name and last name from full name string in SQL
SQL