I'm importing data from a tab delimited file into SQL Server with Bulk Insert.
Two of the fields are percentages formatted as "100%" or "95.83%", ..., but I have to import those columns into my temp table as nvarchar().
However, when I push this data into my production table, I want to do so as a numeric value. What syntax can I use to convert this text value to numeric values like 1.0000 and 0.9583?
Is there a better syntax than:
Cast(LEFT(Dashboard_SSQ_Score_Percentage, LEN(Dashboard_SSQ_Score_Percentage)-1) as float)/100 as SSQ_Pct