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 vote136 views1 answer
Using SQL in rails migration
SQL
0 vote141 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
17 votes154 views4 answers
Postgres list users
SQL
0 vote182 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
3 votes194 views3 answers
List columns in table postgres
SQL
0 vote144 views1 answer
Create table Statement Syntax in SQL Server
SQL
0 vote142 views1 answer
Select other columns with distinct
SQL
3 votes157 views1 answer
Postgres add not null to existing column
SQL
2 votes143 views1 answer
Plsql block
SQL
0 vote139 views1 answer
Syntax for changing column size in mysql
SQL