Is It Possible To Use CASE Statement With SERVERPROPERTY Element

• JC-3113

  SSCrazy Eights

  Points: 8371

  More actions

  February 11, 2010 at 10:22 am

  #216747

  Hi Folks

  is there anyway to incorporate a CASE statement with SERVERPROPERTY such as in the example (that does not work) below ?

  Thanks

  Jim

  -------------

  select

  CAST (SERVERPROPERTY('EngineEdition') as varchar (20)) AS 'EngineEdition',

  CASE SERVERPROPERTY('EngineEdition')

  WHEN '1' THEN 'Personal/Desktop'

  WHEN '2' THEN 'Standard/Workgroup'

  WHEN '3' THEN 'Enterprise/Evaluation/Developer'

  WHEN '4' THEN 'Express/Advanced Services/Embeded SQL'

  ELSE

  'Unknown EngineEdition'

  END SERVERPROPERTY('EngineEdition')

  go

• GSquared

  SSC Guru

  Points: 260824

  More actions

  February 11, 2010 at 10:25 am

  #1117653

  Try this:

  select case (select serverproperty('engineedition'))

  WHEN '1' THEN 'Personal/Desktop'

  WHEN '2' THEN 'Standard/Workgroup'

  WHEN '3' THEN 'Enterprise/Evaluation/Developer'

  WHEN '4' THEN 'Express/Advanced Services/Embeded SQL'

  ELSE

  'Unknown EngineEdition'

  END as Engine

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  February 11, 2010 at 10:44 am

  #1117658

  I'd do what Gus has listed.

• JC-3113

  SSCrazy Eights

  Points: 8371

  More actions

  February 11, 2010 at 11:00 am

  #1117664

  Hi GSquared

  thanks very much, it worked

  i did have to take the quotes off the numbers as the value is integer (my fault)

  other than that, BEAUTIFUL !

  Appreciate it

  Jim