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 votes90 views3 answers
Mysql unix timestamp to date
SQL
0 vote108 views1 answer
Pl/ sql change currency
SQL
0 vote94 views3 answers
Joins and views sql
SQL
1 vote115 views1 answer
Sql server today minus n
SQL
7 votes112 views3 answers
Python and mysql connectivity
SQL
1 vote99 views1 answer
Best sql course
SQL
0 vote110 views1 answer
Guid string to binary better
SQL
3 votes114 views2 answers
Host is not allowed to connect to this mysql server
SQL
1 vote112 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
0 vote132 views2 answers
Search stored procedures by name
SQL