Skip to Content
0
Former Member
Sep 01, 2014 at 01:44 PM

Error when joining data using temp tables

27 Views

Hi all

I am making amendments to a query.

I need to add on some BP info, and as the query has all the different info in temp tables (info from Sales orders, Deliveries and Purchase Orders), i created a temp table for the customer info as well.

when I'm trying to run the query (in SQL2012), I get the following error:

Conversion failed when converting the nvarchar value 'Ship To' to data type int. Warning: Null value is eliminated by an aggregate or other SET operation.

When I take the shiptocode out,, then the error happens on the contact person.

I tried to convert the fields to int and even tried to text...same error.

any way of getting around it?