Created the linked server.

Why do you recomend to use the raw IP address?

I just re-wrote the whole thing. Does this look like what I want?

--K. Mike Bradley

--kmb@mikienet.com

--with help from:

--Remi Gregoire and Michael Du Bois @ qa.sqlservercentral.com

CREATE PROCEDURE TrendPeakTotal

-- declare the...

DATA_VALUE_ is a column of type VARCHAR(50)

and I want to convert it to decimal(19,4)

CONVERT(decimal(19,4), DATA_VALUE_ )

should do it right?

The problem is definetly the converts I added.

Don't know what I did wrong.

Here is a working test table script for anyone who wants to try and help a poor newbie man.

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TESTDATA]') and OBJECTPROPERTY(id,...

LOL!

well if you remember Remi I offered you money to your pay pall account to make it work.

You said you where to busy (I can relate to that).

I need four...

Thanks but I need two separate sp's

and I dont see why when I do this is still returns the max?

--K. Mike Bradley

--kmb@mikienet.com

--with...

Remi,

This is the one you wrote for me (btw I added your name in comment on the server just not on my local copy which is old).

with max it returns...

Thanks Michael,

I'll give this a try Monday!

I loaded it and started massaging it. I still need to set up CONVERTS before it will run.

Here is what I have so far:

CREATE PROCEDURE sp_TrendPeakTotal

-- declare the input...

&nbsp  ON [PRIMARY]

GO

The Close paranthesis got replaced with a smiley LOL!

I think I got It:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TRENDDATA]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[TRENDDATA]

GO

CREATE TABLE [dbo].[TRENDDATA]...

Still trying to figure a way to generate a table script with 30 rows of data for one point.

Also here is the script to make the table. Hope this works.

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TRENDDATA]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[TRENDDATA]

GO

CREATE TABLE [dbo].[TRENDDATA]...

Here is a text file I generated from DTS which you should be able to import back in using same?

"SEQUENCENUMBER_","TID_","DATE_STAMP_","RECORD_TYPE_","DATA_VALUE_","STATUS_FLAGS_","Expr1","Expr2","Expr3"

1,11,2003-06-10 14:00:00,2,"20.00",0,11,2003-06-10 14:00:00,2

2,11,2003-06-10 16:00:00,2,"35.484997",0,11,2003-06-10 16:00:00,2

3,11,2003-06-10 18:00:00,2,"65.895",0,11,2003-06-10 18:00:00,2

4,11,2003-06-10 20:00:00,2,"65.895",0,11,2003-06-10 20:00:00,2

5,11,2003-06-10 22:00:00,2,"65.895",0,11,2003-06-10 22:00:00,2

6,11,2003-06-11...