mirde
asked on
SQL SSIS/TSQL convert table column from varchar to numeric?
Hello,
I have a table that stores all of my columns as "varchar(150)".
Some of the columns in the table only contain money values and I would like to convert them to such (numeric datatype is best for money?).
Here is how the table looks like:
The table has about 1.6m rows, how can I using TSQL or SSIS efficiently convert the three columns from varchar to a more appropriate datatype for money?
Please let me know, I am looking for a descriptive example of how to make this work.
Thanks.
I have a table that stores all of my columns as "varchar(150)".
Some of the columns in the table only contain money values and I would like to convert them to such (numeric datatype is best for money?).
Here is how the table looks like:
The table has about 1.6m rows, how can I using TSQL or SSIS efficiently convert the three columns from varchar to a more appropriate datatype for money?
Please let me know, I am looking for a descriptive example of how to make this work.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER