0 THEN 'Red'
WHEN CHARINDEX('!2',Org.[Abbreviation]) <> 0 THEN 'Yellow'
WHEN CHARINDEX('!3',Org.[Abbreviation]) <> 0 THEN 'Green'
WHEN CHARINDEX('!4',Org.[Abbreviation]) <> 0 THEN 'Blue'
WHEN CHARINDEX('!5',Org.[Abbreviation]) <> 0 THEN 'Orange'
WHEN CHARINDEX('!6',Org.[Abbreviation]) <> 0 THEN 'Teal'
WHEN CHARINDEX('!7',Org.[Abbreviation]) <> 0 THEN 'Violet'
WHEN CHARINDEX('!8',Org.[Abbreviation]) <> 0 THEN 'Black'
WHEN CHARINDEX('!9',Org.[Abbreviation]) <> 0 THEN 'Black'
WHEN CHARINDEX('!0',Org.[Abbreviation]) <> 0 THEN 'Black'
ELSE 'Black'
END AS StatusBarColor
,HOST_NAME() AS HostName
,@@SERVICENAME AS InstanceName
FROM
dbo.[PDXpertInfo_View] Info
CROSS APPLY [EmailSettings_View] Email
CROSS APPLY [PDXpertLic_View] Lic
INNER JOIN Organization_View Org ON Org.Name = Lic.Organization
]]>
Table2