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 vote209 views1 answer
Customer using hdfc bank sql query
SQL
0 vote193 views1 answer
Mysql date equals to current_date plus days
SQL
0 vote184 views1 answer
Mariadb used space
SQL
23 votes171 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote177 views1 answer
Median mysql
SQL
7 votes189 views2 answers
Oracle sql drop index
SQL
4 votes176 views1 answer
Wilayah indonesia sql
SQL
0 vote186 views2 answers
Sql max count
SQL
4 votes191 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
3 votes187 views2 answers
Oracle sql select all days between two dates except weekends
SQL