By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,379 Members | 1,404 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,379 IT Pros & Developers. It's quick & easy.

SQL SERVER Reports and multiple selects

P: 39
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.
May 7 '08 #1
Share this Question
Share on Google+
3 Replies


ck9663
Expert 2.5K+
P: 2,878
Use JOIN or UNION

-- CK
May 7 '08 #2

P: 39
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
May 7 '08 #3

ck9663
Expert 2.5K+
P: 2,878
Create a table-valued function or views.

--CK
May 7 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.