September 5, 2013 at 2:34 pm
Hi All,
Please I need someone to help me with this problem. I have a table variable which I need to insert data into. The data I want to insert comes from a query for example SELECT r.decode, b.decode FROM Sales. employee. The insert is not working because there's duplicate column name in the select list.
The error is this : "Duplicate column names are not allowed in result sets obtained through OPENQUERY and OPENROWSET. The column name "decode" is a duplicate.
Please I need help
EO
September 5, 2013 at 2:36 pm
Could you alias the column in your query to differentiate both decode columns?
September 5, 2013 at 2:50 pm
Thanks for your response. I just read about this before you posted it. I will try it in office tomorrow
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy