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

3 votes276 views2 answers
Oracle sql drop sequence
SQL
0 vote320 views1 answer
Datatables server side filter where clause
SQL
1 vote292 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
0 vote280 views1 answer
Order by number of character in sql
SQL
0 vote327 views2 answers
How to drop mili second in sql
SQL
1 vote283 views1 answer
How to check the mysql version mac
SQL
8 votes284 views1 answer
Database backup in mysql server recovery
SQL
0 vote308 views1 answer
Psql show db
SQL
0 vote283 views1 answer
Sql select by content lenght
SQL
0 vote283 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL