Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Error converting nvarchar to datatype int returning 15 digit salesforce instead of 18 digit id

I'm having a problem where I am trying to run a query and its failing saying that it cannot convert a nvarchar to data type int and in the error it gives returns a 15 digit salesforce id.

I've located the problem join and when I comment it out the query works perfectly. I've checked the table to make sure it's listing an 18 digit id and it is. I don't understand why this is failing and giving me a 15 digit id error when the id listed in the table is 18 digits.
1 person has
this problem