So I guess it's reall time to start implementing some coding standards so that at least the new apps are documented correctly.

Ya that could help too . Can I come help??

have you tried running the debugger on the proc (query analyser, right click in the proc/debug)?

Sounds like you should ask your little army of programmers to comment their code... might take them a few days/weeks, but at least it'll be done.

I posted 2 different sps because I didn't know which one you really needed.

Have you tried running them?

Have you considered hiring a real programmer to do this task? I'm...

Could you try that version to at least see if it works?... that way you won't have to come back here if you run into this situation again.

I don't remember writting it that way, bot oh well :

CREATE PROCEDURE dbo.TrendMax_AbsoluteMinMax

@TID int,

@StartDate datetime,

@EndDate datetime

AS

SELECT max(CONVERT(decimal(19,4), DATA_VALUE_ )) as Maximum, min(CONVERT(decimal(19,4), DATA_VALUE_ )) as Minimum

FROM dbo.TRENDDATA

WHERE TID_...

Wtf Dev????????

Gonna have to have a little talk with my boss!!!!!!

Hehe... too many guys with too much time on their hands.

Hey Mike, what's this query supposed to return?? The min amount per date, or just the min amount?

Have you tried :

Insert into MessagesArchive.dbo.ActivityLog2005June (col1, col2, coln)

Select col1, col2, coln from ActivityLogView Where SessionID = '{9C49937F-4533-4540-B121-0A776191A54A}'

And you didn't answer these questions :

Define extremely large??

Will you have...

HTH.

This doesn't work??

CREATE PROCEDURE dbo.TrendMax

@TID int,

@StartDate datetime,

@EndDate datetime

AS

SELECT top 1 DATE_STAMP_ "Date_Time", min(CONVERT(decimal(19,4), DATA_VALUE_ )) "Value"

FROM TRENDDATA

WHERE TID_ = @TID AND @StartDate = DATE_STAMP_ AND RECORD_TYPE_ = 2

group...

Select @@ServerName

"2005/a/b/001" Doh!!, read this one too fast.

I would tend to agree with Frank on this one and ask the same thing??

Just to pre answer your problem, have you tried just printing the statement instead of executing it??? You'll probably see the error then.