SQLTeam.com | Weblogs | Forums

Update problem


when i update [view_10] set instruction = [sales order] my information of [ sales order] is not comming right in instruction

[ sales order] is 50858196
instruction after update is 5.08582e+007

what is wrong?


What's the Data Type for the [sales order] and [instruction] columns?

Looks like [instruction] might be FLOAT or similar?