I am just trying to do a simple select, with some subselect and join, but I am getting this silly error message:
"Msg 457, Level 16, State 1, Line 1
Implicit conversion of varchar value to char cannot be performed because the collation of the value is unresolved due to a collation conflict."
If someone could help me out with this I would greatly appreciate it.
Let me know if you need anymore info.
Thanks soo much in advance!!
Shipment_Number as fcOrderID
, (SELECT source_order_no FROM Server1.db1.dbo.pick_list_hdr
WHERE pick_list_no = '123456789') as p21OrderNo
, Carrier_Name as Carrier
, Ship_Date as dateShipped
, CASE --Tracking Number
When Tracking_Number IS NOT NULL Then
When Tracking_Number IS NULL Then
FROM db2..delivery_arc d
JOIN db2..deliveryorders_arc do ON d.delivery_nbr = do.delivery_nbr
WHERE do.order_id = '123456789')
END AS PROTrackingNo
WHERE shipment_number = '123456789'