InfoPath Dev

Why doesn't InfoPath load data from a stored procedure that uses a UNION query?

 Ex: if the stored procedure is:

select myColumn from table1

the data source populates just fine.  But if the stored procedure is:

select myColumn from table1
union
select myColumn from table1

the data source is not populated.  And yes, that Union query is returning the same exact data.  I actually stumbled upon it because I was trying to do this:

select myColumn from table1
union
select 'someValue' as myColumn

I'm primarily a SQL and .Net developer, so I'm perplexed as to what InfoPath is doing.

Any enlightenment is greatly appreciated!

Hi,

I have verified the following query and it is working fine.

select myColumn from table1
union
select myColumn from table1

Coming to

select myColumn from table1
union
select 'someValue' as myColumn

instead of above one use the following query .

select CONVERT(NVARCHAR, myColumn)as myColumn from table1

union select 'someValue' as myColumn

ex: select CONVERT(NVARCHAR,ID )as ID from dbo.EmpDetails

union select 'id' as ID