URGENT - UNION query only returns second dataset to gridview
This is urgent.
I have a UNION query and my gridview is only returning the second query from the SQL statement. I know the queries both return data because when I reverse the SQL Statements the other result set is shown.
The query is run via stored procedure so I'm not even sure how .NET knows, but it does.