conversion error

hargun · Post by **hargun** » Sat Dec 14, 2013 12:08 pm

hi,.

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")

but still same error coming.

the data from source coming as 01,03 etc.

Please help me on this.

chulett · Post by **chulett** » Sat Dec 14, 2013 4:37 pm

Sorry but what are you attempting to do with the substring operators? The "[5,0]" part... remove it. Don't see any need for the "ceil" rounding either. What happens with a straight-up function call?

Code: Select all

StringToDecimal(select_stats.CYCLE_DAY_OF_MONTH)

hargun · Post by **hargun** » Sat Dec 14, 2013 5:32 pm

i use the following function as suggested

Code: Select all

StringToDecimal(select_stats.CYCLE_DAY_OF_MONTH)

Still the same error is coming( Conversion error calling conversion routine decimal_from_string data may have been lost)

hargun · Post by **hargun** » Sun Dec 15, 2013 3:01 pm

Can somebody help me on thi.s

chulett · Post by **chulett** » Sun Dec 15, 2013 4:54 pm

Probably. Be patient...

Also verify your data types and sizes, source to target. I for one do not expect that kind of warning going from a small field to a larger one, it is generally the other way round that causes issues.

bicap · Post by **bicap** » Mon Dec 16, 2013 1:33 am

Hi,

Can you give few values of input data and required out put?

Thanks,
Phani