Viewing 15 posts - 17,296 through 17,310 (of 18,926 total)
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...
June 7, 2005 at 8:56 am
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...
June 7, 2005 at 8:52 am
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??...
June 7, 2005 at 8:48 am
So I guess it's reall time to start implementing some coding standards so that at least the new apps are documented correctly.
June 7, 2005 at 8:44 am
Ya that could help too
. Can I come help??
June 7, 2005 at 8:42 am
have you tried running the debugger on the proc (query analyser, right click in the proc/debug)?
June 7, 2005 at 8:39 am
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.
June 7, 2005 at 8:38 am
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...
June 7, 2005 at 8:36 am
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.
June 7, 2005 at 8:28 am
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_...
June 7, 2005 at 8:26 am
Wtf Dev????????
Gonna have to have a little talk with my boss!!!!!!
June 7, 2005 at 8:19 am
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?
June 7, 2005 at 8:14 am
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...
June 7, 2005 at 8:12 am
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...
June 7, 2005 at 8:09 am
Viewing 15 posts - 17,296 through 17,310 (of 18,926 total)