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 vote278 views1 answer
Sql count total by foreign key
SQL
1 vote297 views1 answer
Insert value to new table by joining 2 different tables
SQL
8 votes274 views1 answer
Declare table variable sql server
SQL
2 votes243 views1 answer
Latest record in sql
SQL
0 vote280 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
1 vote288 views1 answer
ORA-01950
SQL
0 vote228 views1 answer
Oracle function select into
SQL
7 votes265 views1 answer
Forge server hosting
SQL
1 vote291 views3 answers
What is union in sql
SQL
0 vote265 views1 answer
SQL Server modify_timestamp trigger
SQL