Forum Discussion

bhaskarpbi99's avatar
bhaskarpbi99
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 converting data type varchar to numeric.

Insert Query

INSERT INTO [Data].[Noti_Window]
SELECT 
CONVERT(VARCHAR(16), SYSDATETIME())  AS 'RunTime',
EDW.* 
 
--INTO [Data].[Noti_Window]
FROM (
 
SELECT * FROM [Data].[Noti_EDW_PAN_TempViewIII]
UNION
SELECT * FROM [Data].[Noti_EDW_DOD_TempViewIII]
 
) AS EDW 
INNER JOIN [Data].[Noti_Dim_PageID] AS PgID ON EDW.PageID = PgID.PageID
;
 
Noti Window table structure.
 

PAN and DOD View Structure.

 

Could you please let me know how to find  out which column is causing this issue bco'z from last 1 year working fine without any issues.

Thanks in Advance for your great support.

 

Regards,

Bhaskar

 
 
 
 

 

 

 

 

 

 

 

Need Advice

3 Replies

  • HolgerRachut's avatar
    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's avatar
      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

       

       

Resources