Syntax error converting datetime from character st
I m trying to copy data from source table to destination table . The source table columns r of varchar type while the destination columns r either date or int . I have casted the columns into proper data type while selecting it from the source table and try inserting into destination table but i m getting the following errror.
"Syntax error converting datetime from character string."
I already checked for nulls but the problem seems to be improper data format coz i saw some of the data in the source table conatin spaces & thats y cast might be failing..
Can someone help me out pls in tackling the above issue.....
I appreciate it in advance.