i tried to insert the column CYCLE_DAY_OF_MONTH varchar(2) to decimal
CYCLE_DAY_OF_MONTH(decimal(5)) however i getting error
conversion error decimal from string data may have been lost.
i have search a lot of forums and then tried with function
Code: Select all
StringToDecimal(select_stats.CYCLE_DAY_OF_MONTH[5,0],"ceil")
the data from source coming as 01,03 etc.
Please help me on this.