M
Michael
Guest
I'm using an OpenQuery in MS SQL Server 2014 to retrieve data from Progress.
This is my query:
SELECT *
FROM OPENQUERY(PRG, 'SELECT "cde","dsc" FROM tblCodes')
And it retrieves data like this:
cde dsc
=== =====
one test
one another
one value
two goes
two here
two also
three example
However, I need to have results look like this:
cde dsc
=== =====
one test
two goes
three example
How do I do this in an OpenQuery?
Continue reading...
This is my query:
SELECT *
FROM OPENQUERY(PRG, 'SELECT "cde","dsc" FROM tblCodes')
And it retrieves data like this:
cde dsc
=== =====
one test
one another
one value
two goes
two here
two also
three example
However, I need to have results look like this:
cde dsc
=== =====
one test
two goes
three example
How do I do this in an OpenQuery?
Continue reading...