Okay, then I would try this and let me know how it goes:
SELECT CONVERT(int, scheduled_qty) AS scheduled_qty
FROM OPENQUERY(PROD_AXS, '
  SELECT CONVERT(varchar(18), scheduled_qty) AS scheduled_qty
  FROM AXS.PUB.sols...

Or, someone could recognize that data that has to have pieces of it broken out and examined has failed to enforce good database design by allowing data elements in the...

Show them the nature of the problem.  They'll very quickly learn that with a LIKE capability in such a lookup table, they will inherently start using % and/or _ at...

What is the data type of the source data ?   When you use an OLE DB provider, there may be certain data types that have trouble.   SQL Server can only...

Hate to burst your bubble, but implementing this kind of table lookup is fraught with potential problems.   You are hoping to put some kind of criteria into one of the...

Duplicate post.

If the problem node is part of a cluster, what expected role would it play in the clustering, and/or failover process?   Seems to me a 10 GB memory node wouldn't...

Why does this data need to be in separate databases?   It's much more easily accomplished in just one.   However, given the multiple databases, you should probably at least look at...

Not all that many folks are willing to open an Excel spreadsheet from the internet, so not many will open it and look at your problem.   The best way to...