Top "Case" questions

top 1 case in select statement on TSQL

I am having problem on this query. How can I fix this: select (select case top 1 STATUS when 'Inprocess' then …

sql tsql case top-n

Case classes inheriting from abstract class

I'm currently learning Scala and I have some problems designing my case classes. I need two case classes that have …

class scala inheritance case

Cypher Neo4J - CASE Expression with MERGE

I'm trying to implement the logic in Cypher where, based on a particular condition (CASE Statement), I would create some …

merge neo4j logic case cypher

Case Statements and Pattern Matching

I'm coding in SML for an assignment and I've done a few practice problems and I feel like I'm missing …

functional-programming pattern-matching case sml

Trapping getopt invalid options

I'm using getopt (not getops) to provide the ability for my bash script to process options and switches (both long …

bash shell case getopt

ruby string match ignore case

I am trying to create a match query which selects text from a string between two words. I can't seem …

ruby regex string case match

ruby - using include method in a case statement

I'm using something like this: case referer when (referer.include? "some_string") redirect_link = edit_product_path when (referer.include? "…

ruby-on-rails ruby switch-statement case

Netsuite Formula - "blank" or "null" field

I'm trying to use a formula to get a field populated with the word "false" in NetSuite, but currently when …

case formula netsuite

Multiple conditions for Select Case using ChassisType

We use MDT in our environment to image computers. We are using a script in order to name computers based …

vbscript case computer-name mdt

Using CHARINDEX and SUBSTRING in a CASE statement

I need to evaluate a field with a CASE statement. The field name is Commodity and is a varchar(255). The …

sql-server sql-server-2012 substring case charindex