Top "Case-statement" questions

A case statement allows sequences of SQL statements to be selected for execution based on search or comparison criteria, and is typically used in stored procedures.

What is the Python equivalent for a case/switch statement?

I'd like to know, is there a Python equivalent for the case statement such as the examples available on VB.…

python switch-statement case-statement
How to use patterns in a case statement?

The man page says that case statements use "filename expansion pattern matching". I usually want to have short names for …

bash case-statement
Case Statements/Decode Function in Informatica

Could anyone help me with writing case statements in Informatica PowerCenter Designer? I am fairly new to Informatica, and based …

decode case-statement informatica-powercenter informatica
Case statements evaluate to strings

I've caught the functional programming bug, so naturally nothing is good enough for me anymore. ;) So, in bash one could …

bash functional-programming notation case-statement
Ruby class types and case statements

What is the difference between case item.class when MyClass # do something here when Array # do something different here when …

ruby duck-typing case-statement
T-SQL Conditional WHERE Clause

Found a couple of similar questions here on this, but couldn't figure out how to apply to my scenario. My …

sql sql-server tsql where-clause case-statement
Is it possible to perform a "LIKE" statement in a SSIS Expression?

I'm using a Derived Column Task to change column data using a CASE WHEN statement. However, I need to be …

sql ssis sql-like case-statement dataflowtask
Case Statements versus coded if statements

What is more efficient - handling with case statements in sql or handling the same data using if statements in …

sql asp-classic case-statement
SQL Server Convert in Case Statement

I have a column called compositeRate, it is a decimal(10,2) datatype. I am writing a Select statement that should return …

sql-server case case-statement
How to write a select inside case statement

I have a stored procedure that contains a case statement inside a select statement. select Invoice_ID, 'Unknown' as Invoice_…

sql stored-procedures sql-server-2012 case-statement