jsheldon (4/16/2009)
Hi Rajib,I did the following query:
SELECT ISNUMERIC(column_13) from #temp
The column brought back 0 and 1s
Again this column that has budget data. So values like 100, 105, 105.67, 9845.43, #MISS appear
I tried to do a SELECT CONVERT(numeric 18,2),column_13) AS convert_col13 INTO #temp2 from #temp but I still get error about unable to convert nvarchar to numeric
The bolded item in your list is at least one of the things that is causing the error. You can't convert '#MISS' to a numeric. You could try doing:
SELECT
CONVERT(numeric(18, 2), column_13) AS convert_col13
INTO
#temp2
from
#temp
WHERE -- only do ones that could be numeric.
ISNUMERIC(column_13) = 1
You could still get some errors as currency characters, '-', and '.' are among characters that cause isnumeric to return 1.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question