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
Viva Glint Partner Office Hours: EMEA
We invite you to our weekly Office Hours, a safe space to ask any questions related to Glint – Platform, Programs and Best Practices. Come prepared with questions or feel free to just pop in to learn from others’ questions. Presence is optional but would love to see you there! NOTE: Other companies may be on the line so please use your discretion before sharing sensitive information about your company. Use this link to join the Viva Glint Partners Office Hours event.Viva Glint Partner Office Hours: EMEA
We invite you to our weekly Office Hours, a safe space to ask any questions related to Glint – Platform, Programs and Best Practices. Come prepared with questions or feel free to just pop in to learn from others’ questions. Presence is optional but would love to see you there! NOTE: Other companies may be on the line so please use your discretion before sharing sensitive information about your company. Use this link to join the Viva Glint Partners Office Hours event.Viva Glint Partner Office Hours: EMEA
We invite you to our weekly Office Hours, a safe space to ask any questions related to Glint – Platform, Programs and Best Practices. Come prepared with questions or feel free to just pop in to learn from others’ questions. Presence is optional but would love to see you there! NOTE: Other companies may be on the line so please use your discretion before sharing sensitive information about your company. Use this link to join the Viva Glint Partners Office Hours event.Viva Glint Partner Office Hours: EMEA
We invite you to our weekly Office Hours, a safe space to ask any questions related to Glint – Platform, Programs and Best Practices. Come prepared with questions or feel free to just pop in to learn from others’ questions. Presence is optional but would love to see you there! NOTE: Other companies may be on the line so please use your discretion before sharing sensitive information about your company. Use this link to join the Viva Glint Partners Office Hours event.Viva Glint Partner Office Hours: EMEA
We invite you to our weekly Office Hours, a safe space to ask any questions related to Glint – Platform, Programs and Best Practices. Come prepared with questions or feel free to just pop in to learn from others’ questions. Presence is optional but would love to see you there! NOTE: Other companies may be on the line so please use your discretion before sharing sensitive information about your company. Use this link to join the Viva Glint Partners Office Hours event.Viva Glint Partner Office Hours: EMEA
We invite you to our weekly Office Hours, a safe space to ask any questions related to Glint – Platform, Programs and Best Practices. Come prepared with questions or feel free to just pop in to learn from others’ questions. Presence is optional but would love to see you there! NOTE: Other companies may be on the line so please use your discretion before sharing sensitive information about your company. Use this link to join the Viva Glint Partners Office Hours event.Viva Glint Partner Office Hours: EMEA
We invite you to our weekly Office Hours, a safe space to ask any questions related to Glint – Platform, Programs and Best Practices. Come prepared with questions or feel free to just pop in to learn from others’ questions. Presence is optional but would love to see you there! NOTE: Other companies may be on the line so please use your discretion before sharing sensitive information about your company. Use this link to join the Viva Glint Partners Office Hours event.Viva Glint Partner Office Hours: EMEA - Ask us Anything!
We invite you to our weekly Office Hours, a safe space to ask any questions related to Glint – Platform, Programs and Best Practices. Come prepared with questions or feel free to just pop in to learn from others’ questions. Presence is optional but would love to see you there! NOTE: Other companies may be on the line so please use your discretion before sharing sensitive information about your company. Use this link to join the Viva Glint Partners Office Hours event.Viva Glint Partner Office Hours: EMEA - Coaching Customer to Adopt Best Practices
We invite you to our weekly Office Hours, a safe space to ask any questions related to Glint – Platform, Programs and Best Practices. Come prepared with questions or feel free to just pop in to learn from others’ questions. Presence is optional but would love to see you there! NOTE: Other companies may be on the line so please use your discretion before sharing sensitive information about your company.
