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

2 votes359 views1 answer
Add new column not null sql server
SQL
3 votes358 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
0 vote324 views1 answer
How to drop columns with constraint from a table in sql script
SQL
3 votes332 views1 answer
Oracle apex message quit website
SQL
1 vote292 views1 answer
Prevent duplicate rows in postgres
SQL
2 votes332 views1 answer
Insert from table tsql
SQL
0 vote336 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
6 votes340 views2 answers
Mysql set primary key
SQL
0 vote347 views3 answers
Joins and views sql
SQL
0 vote402 views2 answers
Disallowed function mysql to_date()
SQL