I have a field I am trying to bring into a SQL statement
,ISNULL(Convert(nvarchar(50),OPP1.OriginatingLeadId),'') AS 'OriginatingLeadId'
I get this error message
Conversion failed when converting from a character string to uniqueidentifier.
the field specs' originatingleadid is attached
I am new to SQL, been using MS Access for years, but just got a new job this year and doing a lot more SQL. I really thought I had this correct. Any help is appreciated.
,ISNULL(Convert(nvarchar(50),OPP1.OriginatingLeadId),'') AS 'OriginatingLeadId'
I get this error message
Conversion failed when converting from a character string to uniqueidentifier.
the field specs' originatingleadid is attached
I am new to SQL, been using MS Access for years, but just got a new job this year and doing a lot more SQL. I really thought I had this correct. Any help is appreciated.
