You could have two near-identical ORDER BY items, one ASC and one DESC, and extend your CASE statement to make one or other of them always equal a single value: ORDER BY CASE WHEN @OrderDirection = 0 THEN 1 ELSE CASE WHEN @OrderByColumn = ‘AddedDate’ THEN CONVERT(varchar(50), AddedDate) WHEN @OrderByColumn = ‘Visible’ THEN CONVERT(varchar(2), Visible) … Read more
s = s.replace(/(\w)(\w*)/g, function(g0,g1,g2){return g1.toUpperCase() + g2.toLowerCase();}); The regex finds words (here defined using \w – alphanumerics and underscores), and separates them to two groups – first letter and rest of the word. It then uses a function as a callback to set the proper case. Example: http://jsbin.com/uvase Alternately, this will also work – a … Read more
I think what you are asking for will work by joining the Initial table to both Option_A and Option_B using LEFT JOIN, which will produce something like this: Initial LEFT JOIN Option_A LEFT JOIN NULL OR Initial LEFT JOIN NULL LEFT JOIN Option_B Example code: SELECT i.*, COALESCE(a.id, b.id) as Option_Id, COALESCE(a.name, b.name) as Option_Name … Read more
You can’t use a condition to change the structure of your query, just the data involved. You could do this: update table set columnx = (case when condition then 25 else columnx end), columny = (case when condition then columny else 25 end) This is semantically the same, but just bear in mind that both … Read more
If you can create a function then you can do something like: SQL Fiddle Oracle 11g R2 Schema Setup: CREATE OR REPLACE FUNCTION is_Valid_Date ( p_date IN VARCHAR2, p_format IN VARCHAR2 DEFAULT ‘DD-MON-YY’ ) RETURN NUMBER IS d DATE; BEGIN d := TO_DATE( p_date, p_format ); RETURN 1; EXCEPTION WHEN OTHERS THEN RETURN 0; END; … Read more
No, you can’t refer to the alias elsewhere in the same level of select, other than in the order by clause, because of when Oracle assigns it internally. From the documentation (emphasis added): You can use a column alias, c_alias, to label the immediately preceding expression in the select list so that the column is … 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”;
The simplest and probably the best way performance-wise would be: switch ($var2) { case 1: case 2: $var3 = ‘Weekly’; break; case 3: $var3 = ‘Monthly’; break; case 4: case 5: $var3 = ‘Quarterly’; break; } Also, possible for more complex situations: switch ($var2) { case ($var2 == 1 || $var2 == 2): $var3 = … Read more
To do conditional write operations you need to use the FOREACH trick. Using CASE you either return a one element array or a empty one. FOREACH iterates over the CASE expression and therefore conditionally executes the action. If you want an ELSE part as well you need to have a another FOREACH using the inverse … Read more
The CASE expression evaluates to a value, i.e. it is used to evaluate to one of a set of results, based on some condition. Example: SELECT CASE WHEN type = 1 THEN ‘foo’ WHEN type = 2 THEN ‘bar’ ELSE ‘baz’ END AS name_for_numeric_type FROM sometable` The CASE statement executes one of a set of … Read more