January 24, 2008 at 10:28 am
This query results in TRUE or FALSE entries in the VALUE column. Is there a way to report TRUE as ON and FALSE as OFF?
SELECT substring (TAG , 10,50) as 'ALARM NAME', VALUE,
CONVERT (CHAR(27),(TIME),109) as 'DATE & TIME'
FROM dbo.OMRON_1_ALARMS where TIME between @StartDate and @EndDate
Thanks,
Gary
January 24, 2008 at 10:56 am
how about
...
Case when value=0 then 'OFF' else 'ON' end
...
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
January 24, 2008 at 11:00 am
That did the trick - thanks a million.
Gary
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply