Brad Marsh (12/18/2012)
Perfect - now gettingDuplicate column names are not allowed in result sets obtained through OPENQUERY and OPENROWSET. The column name "name" is a duplicate.
Owh the joys of mySQL and MSSQL....
** No need for a reply to this just passing comment... ranting really.
Thanks for the help!
Presume you got this sorted via use of column aliases on the 'name' columns?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.