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 |
|
David2455
Starting Member
6 Posts |
 Posted - 2011-04-28 : 11:19:12
|
| Hi allI am pretty new to sql and working with a set of time data that includes errors (which were not controlled in the input process) and I cannot go back and correct the database history. So, for example I encounter a time in my table as 25:00:00 and my sql query throws an error and stops.Is there a way of continuing on with the query and identifying a specific cell error in the table as "error" or something like that?Alterntively I could try and filter in my staging table (if I knew how!) as the errors appear to be either (1) a time that's greater than 23:59:59, or (2) a time that is simple a 2 digit number (such as say 16).Any help would be much appreciated. |
|
|
|
|
|
Coping with data input errors