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 |
|
detlion1643
Yak Posting Veteran
67 Posts |
 Posted - 2010-05-20 : 14:27:51
|
| So I've been using the same setup for about 6 months now, tweaking little things here and there to keep it up to date. Today, I ran into a big snag.I fill a table based on an excel sheet. The table has 5 columns all nchar(255). The 5 columns in excel are all left as general data types.I backup the table and excel sheet every night, clear the sql table, and start filling it again from the sheet with changes made the next day.All of a sudden, I started getting nvarchar cannot be converted to float. The only sql table that has data changing (but not the types) is all set up as nchar(255) because I don't need the other types. The excel sheet is left alone as general type, I had no reason to be picky with it.I join about 4 other tables and 3 other temp tables I make on the fly. None of these 4 other tables ever change data or datatypes.I am stumped! |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-05-21 : 01:47:28
|
I think the error comes from a join condition with implicit conversion.If you need more help then we need more info about table structure, sample data and maybe wanted result.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
datatype error, no table design changes