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

3 votes278 views2 answers
Postgres alter table owner
SQL
1 vote305 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote283 views1 answer
Groupby sort sql hive
SQL
1 vote277 views2 answers
Postgres cast as decimal
SQL
5 votes270 views2 answers
Oracle rename table
SQL
11 votes273 views1 answer
Sql insert multiple rows from select
SQL
0 vote299 views1 answer
Mysql case when on date
SQL
1 vote263 views1 answer
Get url of cpanel database hostname
SQL
0 vote272 views1 answer
Inserted row count tsql
SQL
0 vote294 views1 answer
Shrink database file in sql server
SQL