results between two databases are same because it doesnt distinguish between caps and lower case example: ID '123a' is same as '123A'
So we need to look at the results while in binary.
select
invqty.prdnum as Prd,
from
dbo.invqty invqty
inner join @TempProd Tmp on cast(Tmp.PKey as varbinary(10)) = cast(invqty.prdtky as varbinary(10))