Stored Procedure/Function or View
From: Ashok Rathi <arathi_at_impresse.com>
Date: Fri, 25 Sep 1998 12:34:26 -0700
Message-ID: <6ugr8n$i4v$1_at_news.bayarea.net>
For efficiency sake, I want to write a stored proc/function or view (I do not know which one) that will allow the client application to get a bunch of records from one table but the results are generated using joins. The client wants to pass arbitrary values for the search paramters. For example
Date: Fri, 25 Sep 1998 12:34:26 -0700
Message-ID: <6ugr8n$i4v$1_at_news.bayarea.net>
For efficiency sake, I want to write a stored proc/function or view (I do not know which one) that will allow the client application to get a bunch of records from one table but the results are generated using joins. The client wants to pass arbitrary values for the search paramters. For example
SELECT Customer.* FROM Customer, Orders
WHERE (Customer.id = Orders.CustomerId and Orders.Value > {{{Client can pass this value}}} )
What is the best way to accomplish this? If somebody could give an example with details, that will be greatly appreciated.
Thanks a lot!
- Ashok Rathi