Flowing Fount of Yak Knowledge
Almighty SQL Goddess
quote:Originally posted by beatkeeper25Why would something be converting when just selecting from view?
Very Important crosS Applying yaK Herder
quote:Originally posted by beatkeeper25I have a view that is involved in an import. Sometimes the import will fail with the following error:Msg 242, Level 16, State 3, Line 2The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.I can recreate the error just from selecting from the view. Why would something be converting when just selecting from view?