#DateForumTypeThreadPost
311 Apr 2013 @ 08:52 PDTDatabaseReplyString Concat - returning multiple rows in one string cocat row  If the number of elements you want to concatenate is low, you can do something like this:   sel   databasename  ,tablename  ,max(case when rnk = 1...
212 Jul 2012 @ 12:18 PDTGeneralReplyCASE WHEN with fall through   I've figured out myself. Any further ideas still welcome.   CREATE VOLATILE TABLE Revenues ( Revenue INT, COUNTRY_DESC VARCHAR(20), COUNTRY_ID I...
111 Jul 2012 @ 03:27 PDTGeneralTopicCASE WHEN with fall through I want to use the CASE statement for multiple groupings, such as: SEL   CASE country WHEN 'US' THEN 'North America' WHEN 'US' THEN 'World'...