Please start any new threads on our new
site at http://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Our new SQL Server Forums are live!
Come on over! We've restricted the ability to create new threads on these forums.
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?