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 vote138 views1 answer
Ubuntu connect to mssql database
SQL
5 votes106 views1 answer
Oracle get nls settings
SQL
1 vote132 views1 answer
Insert pg result of select
SQL
1 vote63 views1 answer
File /etc/init.d/mysql not exists
SQL
0 vote152 views5 answers
How to make trigger in phpmyadmin
SQL
0 vote110 views1 answer
Get max salary from each department sql
SQL
2 votes114 views1 answer
Oracle drop table free up space
SQL
0 vote118 views1 answer
Mariadb search columns
SQL
2 votes113 views1 answer
How to add where command in update comand with joins
SQL
4 votes109 views1 answer
Sql group by year
SQL