thanks again. I was able to write it with the isnumeric function and got the same result set. It took 3.5 minutes longer to run, but I think...

Thanks for your help. I found that there was another text phrase that I needed to explicitly exclude. I can see this happening again if a lab changes...

Thank you all for your help!

I found an invalid date of 20080900 using the IsDate() function. The application is not supposed to allow this type of entry, of...

When I check the data in the table for the practice that fails - the dates all have length 8. The practices that succeed also have length 8. ...

I am not actually writing any code - I am taking apart someone else's code. Can you tell me if the line numbers are generally accurate in the error...

Are the line numbers that SQL puts in the error accurate? I am trying to compare the code (the select clause that begins) in lines 1 and 260 of...

I replaced all the smalldatetime conversions with datetime and now I get the following error:

Msg 242, Level 16, State 3, Line 1

The conversion of a char data type to a...

Where do I set the frequency for Transaction Log writes.  Someone else set up this database and they only write out the logs weekly (not much good to me), but...