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 vote122 views2 answers
Csv into data postgres
SQL
0 vote129 views1 answer
Sql max min
SQL
2 votes120 views2 answers
Exec procedure pl sql
SQL
0 vote133 views1 answer
How to set up an anonymous function to variable in swift
SQL
0 vote117 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
0 vote123 views1 answer
Delete insert record in sql server
SQL
0 vote155 views1 answer
Add new column in sql with foreign key
SQL
4 votes117 views4 answers
What is primary key
SQL
0 vote125 views1 answer
Mysql_error replacement
SQL
0 vote130 views1 answer
H2 auto increment and unique
SQL