bar0822
asked on
importing numbers from access into sql with different format
I am importing a column from access to sql 2005 but the numbers in the column are formatted differently: e.g.
2000
0.50
2.8
22.55
I would like all to have decimal 2 places. the sql column is money format. thanks
2000
0.50
2.8
22.55
I would like all to have decimal 2 places. the sql column is money format. thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER