how to handle below error,
Operand type clash: text is incompatible with decimali must data trans for text datatype to decimal data type. in first table all values are decimals.
I would suggest you stop using the text datatype and instead use the varchar(max) datatype.
But to cast from text to decimal you'll have to go over a varchar. Like this:
answered Apr 17 '12 at 06:02 AM