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 votes185 views1 answer
How to check schema privileges in oracle
SQL
0 vote193 views1 answer
Sql delete dastabase
SQL
0 vote184 views1 answer
If null don't update
SQL
0 vote255 views1 answer
Mariadb date equals to current_date plus days
SQL
2 votes186 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
13 votes189 views3 answers
Insert mysql ifile nto database
SQL
1 vote217 views3 answers
Divide by zero error in sql
SQL
0 vote167 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
0 vote265 views1 answer
ORA-00942
SQL
3 votes178 views2 answers
Sql add year to date
SQL