union stored procedure 1

[joshuaguilty]

I have a stored procedure accepting "Customer" as the input key and retrieves that Customer's data. Is it possible to produce several customer's info (depends on user's choice) in a loop ? Or how to UNION result of stored procedure other than putting the results in an extra table? Thnks.

 

[jbenson001]

Check out these FAQs:
faq183-3979
faq183-5207
faq183-6684

 

[joshuaguilty]

Yes, very detailed. Thank you.

 

[jbenson001]

you're welcome

 

[joshuaguilty]

I have another question IF you don't mind. If the passing parameters are table name like (eg abc, fff, a345 ..) corresponding to tables(eg tableabc, tablefff, tablea345 ...), then would the offered still work !? Thanks again.

 

[jbenson001]

I don't see why not. You can pass what you want, and how you use it is up to you.

 

[joshuaguilty]

Thank you again.

 

[jbenson001]

Sure

 

[gmmastros]

joshuaguilty

Please read this: faq183-874

Particularly #16.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom