|
|
Thursday, February 23rd, 2006
|
12:39p - Stored Procedures
Hi again,
I posted before about how I was coming from Oracle to SQL Server so apologies in advance if this is a stupid question.
I've been using Stored Procedures to return select statements.
What I'm wondering is if they can return data from multiple select statements or variables?
For example
A customer table, and a customer phones table which can have 4 records for the customer.
I want to return customer, phone1, phone2, phone3, phone4
If I just joined the tables I'd get
customer, phone1
customer, phone2 etc.
In Oracle I'd write a function which would get the customer, have a second query to go through the phones table and assign each one to a variable and then return the customer no and the variables.
Can this be done in SQL Server?
(3 comments |comment on this)
|
|
|
|
