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 vote230 views1 answer
Write sql query to show the details start from digit
SQL
1 vote240 views1 answer
Sql count value greater than
SQL
0 vote219 views1 answer
Inser into example
SQL
1 vote255 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
2 votes217 views1 answer
Update trigger
SQL
1 vote226 views1 answer
Postgres concat_ws
SQL
35 votes251 views5 answers
Sql alter column
SQL
1 vote224 views1 answer
Show per page table in xampp
SQL
1 vote242 views1 answer
Pl sql create table from another table
SQL
0 vote221 views2 answers
Mysql disable foreign key checks
SQL