This kind of code perhaps should work for You SELECT *, CASE WHEN (pvc IS NULL OR pvc=””) AND (datepose < 1980) THEN ’01’ WHEN (pvc IS NULL OR pvc=””) AND (datepose >= 1980) THEN ’02’ WHEN (pvc IS NULL OR pvc=””) AND (datepose IS NULL OR datepose = 0) THEN ’03’ ELSE ’00’ END … Read more
declare @locationType varchar(50); declare @locationID int; SELECT column1, column2 FROM viewWhatever WHERE @locationID = CASE @locationType WHEN ‘location’ THEN account_location WHEN ‘area’ THEN xxx_location_area WHEN ‘division’ THEN xxx_location_division END
This won’t directly solve your problem as you want to switch on your own user-defined types, but for the benefit of others who only want to switch on built-in types, you can use the TypeCode enumeration: switch (Type.GetTypeCode(node.GetType())) { case TypeCode.Decimal: // Handle Decimal break; case TypeCode.Int32: // Handle Int32 break; … }
I think I found the answer: convert(nvarchar(36), RequestID) Here’s the link where I found this info: http://msdn.microsoft.com/en-us/library/ms187928.aspx
A CASE expression returns a value from the THEN portion of the clause. You could use it thusly: SELECT * FROM sys.indexes i JOIN sys.partitions p ON i.index_id = p.index_id JOIN sys.allocation_units a ON CASE WHEN a.type IN (1, 3) AND a.container_id = p.hobt_id THEN 1 WHEN a.type IN (2) AND a.container_id = p.partition_id THEN … Read more
Install the additional module tablefunc once per database, which provides the function crosstab(). Since Postgres 9.1 you can use CREATE EXTENSION for that: CREATE EXTENSION IF NOT EXISTS tablefunc; Improved test case CREATE TABLE tbl ( section text , status text , ct integer — “count” is a reserved word in standard SQL ); INSERT … Read more
switch ($value) { case 1: case 2: echo “the value is either 1 or 2.”; break; } This is called “falling through” the case block. The term exists in most languages implementing a switch statement.
That format requires you to use either: CASE ebv.db_no WHEN 22978 THEN ‘WECS 9500’ WHEN 23218 THEN ‘WECS 9500’ WHEN 23219 THEN ‘WECS 9500’ ELSE ‘WECS 9520’ END as wecs_system Otherwise, use: CASE WHEN ebv.db_no IN (22978, 23218, 23219) THEN ‘WECS 9500’ ELSE ‘WECS 9520’ END as wecs_system
Python 3.10 and above In Python 3.10, they introduced the pattern matching. Example from the Python documentation: def http_error(status): match status: case 400: return “Bad request” case 404: return “Not found” case 418: return “I’m a teapot” # If an exact match is not confirmed, this last case will be used if provided case _: … Read more
The CASE statement is the closest to IF in SQL and is supported on all versions of SQL Server. SELECT CAST( CASE WHEN Obsolete=”N” or InStock = ‘Y’ THEN 1 ELSE 0 END AS bit) as Saleable, * FROM Product You only need to use the CAST operator if you want the result as a … Read more