Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vmchase
Starting Member
5 Posts |
 Posted - 2012-10-10 : 10:45:30
|
| I get this error message when trying to run this query. Adding a value to a 'datetime' column caused an overflow.I know that in the dateadd part, the oqm.evalexp has the max value of 99999. I just don't know how to fix this. SELECT company_users.EmpID, company_users.cu_fname, company_users.cu_lname, oqt.id_tasks, oqt.TaskCode, oqt.TaskName, oqm.id_eval, oqm.methodName, CompanyUserEvaluation.evaluationDate, oqm.EvalExp AS evaluation_exp, DATEADD(M, oqm.Evalexp, CompanyUserEvaluation.evaluationDate) AS evaluation_expdate, oqat.Evalexp AS task_exp, CompanyUserEvaluation.id_users, CompanyUserEvaluation.id_eval AS companyusereval_ideval, CompanyUserEvaluation.id_version, CompanyUserEvaluation.Score, CompanyUserEvaluation.PassFail, CompanyUserEvaluation.ID_Users_EvaluatorFROM OQMethods AS oqm RIGHT OUTER JOIN CompanyUserEvaluation INNER JOIN company_users ON CompanyUserEvaluation.id_users = company_users.id_users ON oqm.id_eval = CompanyUserEvaluation.id_eval LEFT OUTER JOIN OperatorJobSiteTasks AS ojss INNER JOIN CompanyJobsAssignment AS CJA1 ON CJA1.ID_CJ = ojss.id_cj AND (CJA1.CJA_EndDate >= GETDATE() OR CJA1.CJA_EndDate IS NULL) INNER JOIN CompanyJobs AS cj ON cj.ID_CJ = ojss.id_cj AND cj.CJ_Active = 1 RIGHT OUTER JOIN CompanyGroupTasks RIGHT OUTER JOIN OQTasks AS oqt ON CompanyGroupTasks.ID_Tasks = oqt.id_tasks LEFT OUTER JOIN OQAllTasks AS oqat INNER JOIN OQTypes AS oqty ON oqty.id_oqt = oqat.id_oqt AND oqty.Active = 1 ON oqt.id_tasks = oqat.id_tasks ON ojss.id_tasks = oqt.id_tasks ON oqm.id_oqm = oqat.id_oqm AND oqm.Active = 1WHERE (company_users.ID_CP = 995) group by company_users.EmpID, company_users.cu_fname, company_users.cu_lname, oqt.id_tasks, oqt.TaskCode, oqt.TaskName, oqm.id_eval, oqm.methodName, CompanyUserEvaluation.evaluationDate,oqm.EvalExp,oqat.Evalexp, CompanyUserEvaluation.id_users, CompanyUserEvaluation.id_eval, CompanyUserEvaluation.id_version, CompanyUserEvaluation.Score, CompanyUserEvaluation.PassFail, CompanyUserEvaluation.ID_Users_Evaluator |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-10-10 : 11:14:42
|
| The date argument cannot be incremented to a value outside the range of its data type, Could you display the date and the date part that is causing the overlowJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-11 : 00:30:10
|
| if 99999 is a default value make sure you apply logic to change it to valid value using case when------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
|
|
SQL Overflow error