I have a table which I created by importing a flat file (using SSIS). The table is set to all nvarchar datatypes at the moment. I would like to convert the columns of the table into specific datatypes mosty numeric. However before I do this I would like to convert all the blank spaces into NULLS.
In addition, I would like to be able to perform a CREATE > INSERT a New Table out of this data and cast all the columns to numeric datatypes, while leaving the blanks NULL and not '0'.
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…