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 vote179 views1 answer
Copy data from one postgres container to another
SQL
0 vote176 views1 answer
Sql query to get contact form 7 fields
SQL
0 vote166 views1 answer
Oracle archivelog usage
SQL
0 vote170 views1 answer
Mysql query single row
SQL
1 vote176 views1 answer
Type int in mysql maxlenght
SQL
0 vote166 views1 answer
Mysql command line ubuntu
SQL
2 votes157 views2 answers
Spring import sql
SQL
0 vote180 views1 answer
Sqlserver now
SQL
2 votes167 views1 answer
How to insert string variable into sqlite database
SQL
0 vote166 views1 answer
Sql count null values in all columns
SQL