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 votes203 views1 answer
Modify column name in tsql
SQL
42 votes272 views6 answers
Sql query duplicate rows
SQL
0 vote229 views1 answer
How to update date value in sql
SQL
0 vote204 views1 answer
Sql server Cost Fifo query
SQL
2 votes196 views1 answer
Columns Present in a table
SQL
3 votes260 views1 answer
Query less than datetime sql
SQL
0 vote193 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote195 views1 answer
Redudancy in SQL
SQL
1 vote194 views2 answers
Install mysqldump ubuntu
SQL
10 votes181 views2 answers
Linux command line import mysql database
SQL