by Drew Burlingam » Sat, 17 Feb 2001 14:51:27
Any suggestions?
Thanks,
Drew
by Mujahid Wazi » Sat, 17 Feb 2001 15:10:30
You can do this using dynamic SQL.
USE pubs
-- Order by the first name
SET NOCOUNT ON
-- Order by the last name
-Mujahid
by Drew Burlingam » Sat, 17 Feb 2001 15:20:16
I'm new to this and thought that there should be a way to do this and sure enough, there is.
Thanks so much.
*** Sent via Developersdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
1. Passing Parameters down to a buried view or stored procedure using parameters
I am a bit of a newbie and am trying to understand how to simplify a
complex SQL Select statement by using a series of views, but needing to
specifying parameters at one of the deeper levels, so I thought that
given parameters, stored procedures were the way to go, but how can I
treat a stored procedure like a view or vice versa?
Say I have a stored procedure, proc1, which is defined as
as
Select * from table1 where col1 is between the two date parameters
I wish to execute another procedure which has additional parameters and
additional tables which are to join to proc1, passing the parameters
proc1 requires down the line.
Is there some way to achieve this, or do I need to expose the parameters
at the surface level?
Alternatively, is there some way to pass parameters to a view?
2. question on SQLSetStmtAttr on SQL_ATTR_MAX_ROWS attribute
3. Passing multiple parameters for a parameter using temporary stored procedures
5. Sorting Stored procedure using a parameter
7. Stored Procedure: Specifying ASC or DESC sort order through a parameter
9. Specifying sort order as a stored procedure parameter
10. Q:Sorting A Grid Bound To A Ado DataControl Using A Parameter'd Stored Procedure
11. Passing a parameter to a stored procedure
12. Passing a Table Name as a Stored Procedure Parameter
13. How to pass parameter for an order by clause in stored procedure