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 vote234 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
0 vote153 views1 answer
Oracle function select into
SQL
6 votes255 views3 answers
Mysql change auto_increment start value
SQL
1 vote265 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
6 votes186 views2 answers
Mysql concatenate two columns into one
SQL
5 votes239 views3 answers
Sql limit offset
SQL
1 vote194 views1 answer
Sql order by where condition
SQL
0 vote196 views1 answer
Change magento database url usimg musql
SQL
0 vote237 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote222 views1 answer
Redshift running queries
SQL