Matt,

That was it - I missed that completely. It works like a chemp now.

Can't thank you enough - take last weekend off!

Gary

Matt,

Here's the latest code:

--clean up messy dates supplied

SELECT

substring(TAG , 10,50) as 'ALARM NAME',

...

Matt,

This code will process under Preview, but no data shows up in the table.

--clean up messy dates supplied

DECLARE @enddate VARCHAR(MAX)

select @enddate=

...

Matt,

Hmmm... The code you see is the entire code I use. I don't delcare anything.

Thanks,

Gary

Matt,

I stole a couple minutes to try the new code:

--clean up on aisle 5 - messy dates supplied

select @enddate=

...

Matt,

Thanks again for your help. I'll get busy on this code in a couple days (I'm on a different project momentarily)

I'll let you know the results.

Thanks,

Gary

Matt,

Here's the code:

SELECT substring (TAG , 10,50) as 'ALARM NAME',

Case when value=0 then 'RESET' else 'ON' end as 'STATUS',

CONVERT (CHAR(27),(TIME),109) as 'DATE & TIME'

FROM dbo.OMRON_1_ALARMS where TAG...

I have revisited this problem to make sure I understand what is happening. If I use just @EndDate and enter 1/23/2008, I will get data up to Midnight 1/22/2008. If...

Chad,

BINGO! That solved my problem! Thanks a million!

Gary

I'm real close now. This code works:

SELECT substring (TAG , 10,50) as 'ALARM NAME',

Case when value=0 then 'RESET' else 'ON' end as 'STATUS',

CONVERT (CHAR(27),(TIME),109) as 'DATE &...

Now I'm trying to allow the user to input the search text.

--DECLARE @enteralarm as VARCHAR(50), --; SET enteralarm = @AlarmName,

SELECT substring (TAG , 10,50) as 'ALARM...

Ignore these posts, this works:

SELECT substring (TAG , 10,50) as 'ALARM NAME',

Case when value=0 then 'RESET' else 'ON' end as 'STATUS',

CONVERT (CHAR(27),(TIME),109) as 'DATE & TIME'

FROM dbo.OMRON_1_ALARMS...

After seaching more reference code, I now have this:

SELECT substring (TAG , 10,50) as 'ALARM NAME',

Case when value=0 then 'RESET' else 'ON' end as 'STATUS',

CONVERT (CHAR(27),(TIME),109) as...

That did the trick - thanks a million.

Gary

That's what I was afraid of - guess I can't have my cake and eat it too!

I thinkg I'll just leave it alone and instruct our customers that they always...