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

2 votes137 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
4 votes167 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
1 vote221 views1 answer
Aqua Data studio postgresql ssl
SQL
0 vote143 views2 answers
2nd max salary query in sql
SQL
1 vote130 views1 answer
Sql headers delphi
SQL
0 vote133 views1 answer
Delete * from where id = 1;
SQL
5 votes135 views6 answers
Sql add days to date
SQL
0 vote149 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote141 views1 answer
Declare or use variable in snowflake
SQL
6 votes125 views3 answers
Can you update NULL in sql
SQL