Still don't have time.

I'm gonna repeat again that the min and max portions of the report can be calculeted by crystal report on the report itself so you don't have...

Ya it's a shame that we didn't hear from him again. But I'm not sure you understood what I meant bu running the debugger on the proc. Are...

All I need is a ride (first class ticket from canada ) and I'm on my way.

Did you know I'm a black belt??...

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...