That’s fine. The point is that the end of a case block should be unreachable – which it is here, because you’ve returned. Why are you returning new string(new char[0]) rather than just “” or string.Empty though? If you’re trying to make sure it’s a different string each time, you’ll actually run into a very … Read more
You need to use the whole CASE statement in the GROUP BY clause if you don’t wrapped it in a subquery. SELECT CASE WHEN DATEDIFF(o.EndDate, o.StartDate) < 30 THEN ‘<1 Month’ WHEN DATEDIFF(o.EndDate, o.StartDate) < 90 THEN ‘1 – 2 Months’ WHEN DATEDIFF(o.EndDate, o.StartDate) < 210 THEN ‘3 – 4 Months’ ELSE ‘>4 Months’ END … Read more
This is the syntax you need: CASE WHEN countries LIKE ‘%’+@selCountry+’%’ THEN ‘national’ ELSE ‘regional’ END Although, as per your original problem, I’d solve it differently, splitting the content of @selcountry int a table form and joining to it.
Simply: SELECT NULLIF(regexp_replace(po_number, ‘\D’,”,’g’), ”)::numeric AS result FROM tbl; \D being the class shorthand for “not a digit”. And you need the 4th parameter ‘g’ (for “globally”) to replace all occurrences. Details in the manual. For a known, limited set of characters to replace, plain string manipulation functions like replace() or translate() are substantially cheaper. … Read more
Call me pedantic but while nobody here was outright wrong, nobody provided the correct code for the final solution either. You need to change this line: $NullSessionPipes = $NullSessionPipes.replace(“browser”, “”) to this: $NullSessionPipes = $NullSessionPipes -ireplace [regex]::Escape(“browser”), “” The strange [regex] text isn’t strictly necessary as long as there are no regular expression characters (ex. … Read more
1. Standard-SQL: LEFT JOIN a single row of values You could LEFT JOIN a row of values using the condition (thereby evaluating it once). Then you can add fallback values per column with COALESCE(). This syntax variant is shorter and slightly faster with multiple values – especially interesting for an expensive / lengthy condition: SELECT … Read more
The value that is returned will be the value of the THEN expression for the earliest WHEN clause (textually) that matches. That does mean that if your line 2 conditions are met, the result will be A2. But, if your THEN expressions were more complex than just literal values, some of the work to evaluate … Read more
Try: select id, StartDate, CASE WHEN StartDate IS NULL THEN ‘Awaiting’ ELSE ‘Approved’ END AS StartDateStatus FROM myTable You code would have been doing a When StartDate = NULL, I think. NULL is never equal to NULL (as NULL is the absence of a value). NULL is also never not equal to NULL. The syntax … Read more
Select SUM(CASE When CPayment=”Cash” Then CAmount Else 0 End ) as CashPaymentAmount, SUM(CASE When CPayment=”Check” Then CAmount Else 0 End ) as CheckPaymentAmount from TableOrderPayment Where ( CPayment=”Cash” Or CPayment=”Check” ) AND CDate<=SYSDATETIME() and CStatus=”Active”;
Yes you can also do: switch (true) { case (var1 === true && var2 === true) : //do something break; case (var1 === false && var2 === false) : //do something break; default: } This will always execute the switch, pretty much just like if/else but looks cleaner. Just continue checking your variables in the … Read more