I'll work on that this evening.

Thanks.

Actually this wont wirk because it is a tempurature which dances around.

I will need to set up one of these and trend it for a day or two. Or better...

Got it but there are no failures:

Also the RECORD_TYPE_ must = 2 for all queries. I can add that in.

 53740 209 6/1/2005 2 65.7 0 209 6/1/2005

 53741 209 6/1/2005 12:10:00 AM 2 65.3 0 209 6/1/2005 12:10:00 AM

 53742 209 6/1/2005 12:20:00 AM 2 65.0 0 209 6/1/2005 12:20:00 AM

 53743 209 6/1/2005 12:30:00 AM 2 64.6 0 209 6/1/2005...

I'm not sure how to get and post raw data.

How would I do this ?

Thanks ... here is the table script:

CREATE TABLE [dbo].[TRENDDATA] (

 [SEQUENCENUMBER_] [int] NOT NULL ,

 [TID_] [int] NOT NULL ,

 [DATE_STAMP_] [datetime] NULL ,

 [RECORD_TYPE_] [smallint] NULL ,

 [DATA_VALUE_]...

Thanks indeed but I have a lot of work past this I need to get done.

btw the database is given to me I can't change it. It is from our...

That almost works except DATA_VALUE_ is a VARCHAR(50)

SO I need to CONVERT to decimal.

I tried for days to get group by to work ......

Pardon me while I pull what's left of my hair out.

DO you want to make some cash money?

DO you have...

You mean that even though it is an output parameter you need to put something in it when called ??????

I am totaly confused.

All I...

SQL Querry Anylizer ...

execute demo 1

I ran that and get the same error:

Server: Msg 201, Level 16, State 4, Procedure demo, Line 0

Procedure 'demo' expects parameter '@paramOUT', which...