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

38 votes431 views6 answers
Ubuntu install mysql client
SQL
3 votes384 views2 answers
Synonym oracle
SQL
0 vote347 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
13 votes348 views1 answer
Sql join 3 tables on id
SQL
7 votes342 views2 answers
Add column table pl sql
SQL
0 vote377 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
0 vote317 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
4 votes324 views1 answer
Oracle show errors compilation
SQL
0 vote333 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
1 vote351 views1 answer
Sql dcl
SQL