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 vote319 views1 answer
Influxdb list all tags for a measurement
SQL
1 vote272 views1 answer
Stop mysql server mac
SQL
0 vote276 views1 answer
Drop all tables in azure sql database
SQL
0 vote315 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
0 vote290 views1 answer
Sql mod even odd
SQL
1 vote298 views1 answer
Postgresql round double precision
SQL
0 vote277 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
9 votes302 views5 answers
Laravel to sql
SQL
0 vote304 views1 answer
In query in sql
SQL
0 vote270 views1 answer
Raiserror nowait sql server
SQL