Recent content by TimothyCederdahl

You were right thanks my date in my table was set to nvar so it was causing an error during the comparison.

Even when i add the max i still get the same error. (0 row(s) affected) Msg 8115, Level 16, State 2, Line 23 Arithmetic overflow error converting expression to data type datetime. The statement has been terminated. begin Update SC_Trophies Set Value = Value + 1 where SC_TROPHIES.USERID in...

it just suppose to check to see if a week has gone by if so it needs to update the data in the table. Meaning the update only runs if a week has gone by. Thanks, Tim

I get this error now. Thanks, Tim (4 row(s) affected) (0 row(s) affected) (4 row(s) affected) Msg 8115, Level 16, State 2, Procedure TrophyCase_CalcWeeklyTopTen, Line 60 Arithmetic overflow error converting expression to data type datetime. The statement has been terminated. (0 row(s)...

something like this should work. Select a.colA from table1 a inner join table2 b on a.col_Id = b.col_id Update table1 set a.cola = b.colb

I get this error when using "> dateadd(day,7,(select TRDate from SC_Trophies Where UserId = 29))" the full query is below with the error. Any ideas on how I could resolve this problem would be most welcomed. The query works fine it seems with out the date part. Thanks in Advance, Tim Msg...