SQL SERVER Reports and multiple selects

[misogsk]

Hi All,

i have stored procedure wich has two select statements, that returns fields.
My problem is, that dataset in visual studio 2005 (when creating new report) has fields that were generated only by first select.
Does exist any solution that shows me all fields I need?
Thank you very much.

[ck9663]

Use JOIN or UNION

-- CK

[misogsk]

I can't use JOIN or UNION a need two independant tables, or better say I have two independant tables, but i don't want to create a several stored procedures

[ck9663]

Create a table-valued function or views.

--CK