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 votes264 views1 answer
Sql to char function with date
SQL
16 votes288 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
1 vote257 views1 answer
Postgres delete from where date is greater than specific date
SQL
6 votes270 views2 answers
What is non relational database
SQL
6 votes262 views5 answers
Mysql get last insert id
SQL
1 vote260 views1 answer
Sqlite3 read only
SQL
10 votes288 views1 answer
Oracle view dependencies
SQL
25 votes270 views6 answers
Change column name mysql
SQL
0 vote278 views1 answer
Lost connection to mysql
SQL
0 vote257 views1 answer
C# select Mysql
SQL