I am trying obtain some data from a Cache database into a Mysql database using Cache's SQL Gateway.<BR><BR>Getting the data out of Cache is easy, but I am not sure about the easiest way to get it into ...
[LINKEDSERVER].TBRWeb.dbo.TeamMaster TM ON TS.TeamID = TM.TeamID WHERE Project = 1 ORDER BY StatsDate DESC, OverallRank ASC </pre><BR><BR>So, to answer your question, SQL Server seems to be smart ...