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 vote120 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote135 views1 answer
Trigger stock phpmyadmin
SQL
0 vote115 views1 answer
Django mssql backend
SQL
0 vote117 views1 answer
Sql server select top 2 of each group
SQL
4 votes109 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
1 vote121 views1 answer
Oracle difference between two dates in years
SQL
0 vote122 views1 answer
Ajax error exception handeling
SQL
49 votes131 views6 answers
Install mysql ubuntu
SQL
0 vote117 views1 answer
Components/Fields of Internal Table
SQL
2 votes113 views1 answer
Mysql set value as null
SQL