It was kinda the reason I came here to get answers. I need help understanding it but that's ok. Thank you for your help.

Im trying to insert data into the QABSNew E table where E.logtime isNull

Im not even getting returned data in my rows either. I made a mistake just don't know where. Probaby referencing the BCP to my filepath locations

I don't think I referenced the temp table correctly. I am trying to import the data using the BCP and parse the data into columns then import into the QABSNew...

I am getting the error dbo.QABSNew is ambiguous line 29 level 16

Why is Line 29 Ambiguous???

Create Table QABSNew(

logTime datetime,

fromServer varchar(20),

toServer varchar(20),

Service varchar(20),

messageId varchar(MAX),

filePath Varchar(MaX)

)