case – Tarik Billa

ERROR: CASE types character varying and numeric cannot be matched

January 5, 2024 by Tarik

All the branches of a case expression should return the same datatype. One way to achieve that is to explicitly cast where needed: ,(case when all_loc.country = ‘DE’ then msc_si.buyer_id::varchar else msc_si.buyer_name end) as “purchasing_group_name_buyer_name” — Here ———————————————–^ ,(case when all_loc.country = ‘DE’ then msc_si.planner_code::varchar else mscp.description end) as “mrp_controller_name” — And here ———————————————–^

SQL use CASE statement in WHERE IN clause

January 3, 2024 by Tarik

No you can’t use case and in like this. But you can do SELECT * FROM Product P WHERE @Status=”published” and P.Status IN (1,3) or @Status=”standby” and P.Status IN (2,5,9,6) or @Status=”deleted” and P.Status IN (4,5,8,10) or P.Status IN (1,3) BTW you can reduce that to SELECT * FROM Product P WHERE @Status=”standby” and P.Status … Read more

Mysql SELECT CASE WHEN something then return field

January 1, 2024 by Tarik

You are mixing the 2 different CASE syntaxes inappropriately. Use this style (Searched) CASE WHEN u.nnmu =’0′ THEN mu.naziv_mesta WHEN u.nnmu =’1′ THEN m.naziv_mesta ELSE ‘GRESKA’ END as mesto_utovara, Or this style (Simple) CASE u.nnmu WHEN ‘0’ THEN mu.naziv_mesta WHEN ‘1’ THEN m.naziv_mesta ELSE ‘GRESKA’ END as mesto_utovara, Not This (Simple but with boolean search … Read more

Use CASE statement to check if column exists in table – SQL Server

January 1, 2024 by Tarik

Final answer was a combination of two of the above (I’ve upvoted both to show my appreciation!): select case when exists ( SELECT 1 FROM Sys.columns c WHERE c.[object_id] = OBJECT_ID(‘dbo.Tags’) AND c.name=”ModifiedByUserId” ) then 1 else 0 end

Switch: Multiple values in one case?

December 29, 2023 by Tarik

1 – 8 = -7 9 – 15 = -6 16 – 100 = -84 You have: case -7: … break; case -6: … break; case -84: … break; Either use: case 1: case 2: case 3: etc, or (perhaps more readable) use: if(age >= 1 && age <= 8) { … } else if … Read more

MySQL CASE to update multiple columns

December 24, 2023 by Tarik

UPDATE tablename SET col1 = CASE WHEN name=”name1″ THEN 5 WHEN name=”name2″ THEN 3 ELSE 0 END , col2 = CASE WHEN name=”name1″ THEN ” WHEN name=”name2″ THEN ‘whatever’ ELSE ” END ;

SWITCH with LIKE inside SELECT query in MySQL

December 23, 2023 by Tarik

Mysql supports two variants of case, the one you use in query 2 is less flexible but supports only equality on a single variable. The other version specifies no variable after case and then conditions need not be only equality: select id_tag, case when tag LIKE “%class%” then “class” when tag LIKE “%new%” then “new” … Read more

Dynamic order direction

December 22, 2023 by Tarik

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

How to catch Errno::ECONNRESET class in “case when”?

December 12, 2023 by Tarik

This is because of how the === operator works on the class Class The case statement internally calls the === method on the object you are evaluating against. If you want to test for e class, you just test against e, not e.class. That’s because e.class would fall into the when Class case, because, well, … Read more

What is a good substitute for a big switch-case?

December 9, 2023 by Tarik

You can store country-power pairs into a Dictionary<string, int> then just get the score of a particular country by using indexer: var points = new Dictionary<string,int>(); // populate the dictionary… var usa = points[“USA”]; Edit: As suggested in comments you should store the information in external file, for example an xml would be a good … Read more