Forum Discussion

Copper Contributor

Feb 16, 2025

Error converting data type varchar to numeric when running insert query

Hi , I am getting below error when trying to run insert statement even though data types are same in target table and source view Error details : Msg 8114, Level 16, State 5, Line 1 Error converti...

Need Advice

HolgerRachut

Copper Contributor

Feb 26, 2025

Noti have a column runtime, thats not in pan table.

so for that you should resolve * with the correct column names in

SELECT * FROM [Data].[Noti_EDW_PAN_TempViewIII]

UNION

SELECT * FROM [Data].[Noti_EDW_DOD_TempViewIII]

(same order of course)

try

SELECT Barcode,IATA,.... FROM [Data].[Noti_EDW_PAN_TempViewIII]

UNION

SELECT BarCode,IATA,.... FROM [Data].[Noti_EDW_DOD_TempViewIII]

bhaskarpbi99

Copper Contributor

Feb 27, 2025

Hi HolgerRachut,

Many thanks and kudos for the extreme support.

Appreciate your support and issue is resolved.

Many thanks for your support.

Regards,

Bhaskar