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 vote379 views1 answer
How to list function in psql
SQL
3 votes366 views2 answers
Sql select data from last week
SQL
1 vote352 views1 answer
Create new table in SQL from old table with data
SQL
0 vote351 views1 answer
Increment id in mysql
SQL
24 votes366 views4 answers
Mysql datetime
SQL
0 vote342 views1 answer
Microsoft word insert sql code
SQL
0 vote416 views1 answer
Sql query to select even numbers
SQL
0 vote391 views1 answer
Influxdb list all tags for a measurement
SQL
1 vote385 views1 answer
Oracle get current schema
SQL
0 vote355 views1 answer
Find largest table in mysql database
SQL