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

1 vote149 views1 answer
Mysql how to reset primary key
SQL
0 vote145 views1 answer
How to reset AI in sql
SQL
0 vote149 views1 answer
Tsql default value when no value returned by query
SQL
0 vote163 views1 answer
Difference between 2 query results sql server
SQL
3 votes153 views1 answer
Laravel database Using Named Bindings
SQL
0 vote165 views1 answer
Replace divide by zero error with 0 in sql
SQL
10 votes143 views1 answer
Dba_dependencies
SQL
3 votes194 views1 answer
Sql several or
SQL
0 vote146 views1 answer
Fix sqlite3 ruby on rails
SQL
1 vote141 views1 answer
Delete triger pl pg sql
SQL