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

4 votes295 views4 answers
Update select mysql
SQL
2 votes323 views2 answers
Postgres add column integer
SQL
0 vote292 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
0 vote302 views1 answer
Character count sql
SQL
0 vote313 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
0 vote291 views1 answer
Mariadb maximum left join
SQL
0 vote315 views2 answers
Mysql decimal remove trailing zeros
SQL
1 vote320 views1 answer
Sql server insert into temp table
SQL
0 vote318 views1 answer
Set Mamp mysql globally
SQL
4 votes311 views1 answer
Mysql copy table with new name
SQL