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 votes103 views1 answer
Oracle failed login attempts
SQL
0 vote128 views1 answer
Calculer pourcentage mysql
SQL
0 vote140 views1 answer
Set classpath for mysql-connector.jar
SQL
0 vote121 views1 answer
Query for backup a database at another location in file system
SQL
12 votes96 views5 answers
Sql merge
SQL
0 vote108 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote101 views1 answer
How to search query in python3 sqlite3
SQL
2 votes155 views2 answers
Mysql date range
SQL
0 vote98 views1 answer
What are the aggregate function in sql
SQL
0 vote115 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL