Home Forums SQL Server 2005 T-SQL (SS2K5) Need help conveting this from Mysql to SQL server RE: Need help conveting this from Mysql to SQL server

  • December 19, 2012 at 1:14 am

    #1569920

    Brad Marsh (12/18/2012)

    Perfect - now getting

    Duplicate 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?