Viewing 8 posts - 1 through 8 (of 8 total)
Thank u for your answer. I ended up adding a flag column to the table and set a flag on each row matching the conditions needed. Then I did an...
November 16, 2018 at 9:00 am
September 29, 2017 at 8:26 am
kruti (4/29/2009)
I think, you need to put where condition into above query, like below.
UPDATE [dbo].[EvalLog] SET[StudentRemarks] = (SELECT StudentsLog.Remarks FROM ClassRemarks WHERE StudentID = @gStudentID))
where StudentID=@gStudentID
Hi Kruti, thanks for taking...
April 29, 2009 at 6:59 am
Hi Jack, played a bit around with your suggestions, and I finally think the temp table approach will work better in my case, since I have all kinds of disparate...
April 28, 2009 at 9:36 pm
Jack Corbett (4/28/2009)
2. Move the [dbo].[EvalLogUpdateSproc] code into the trigger using a join on the inserted table to...
April 28, 2009 at 12:37 pm
Thank u guys for your attention. Well, here goes the code I tried (just 1 column for brevity 'sake):
ALTER TRIGGER EvalLogUpdate
ON dbo.EvalLog
FOR INSERT
AS
DECLARE @gStudentID uniqueidentifier
SELECT @gStudentID = StudentID FROM Inserted...
April 28, 2009 at 10:24 am
Mike, Goldie
Thank u for your answers and attention, but like I said earlier Kemp provided the solution:
ROUND(AVG(CAST(Atraso AS FLOAT)), 0) AS avgAtraso
regards,
April 20, 2009 at 8:48 pm
HI Kemp, thank u, works like a charm.
Chandra: CEILING(AVG(Atraso)) won't cut it: it rounds down to 2 from 2,67
As for the responses from Hayzer and Arun, I think u...
April 20, 2009 at 9:15 am
Viewing 8 posts - 1 through 8 (of 8 total)