Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-21 : 14:15:19
|
Jeff writes "Similar to Parameterized Order By question.....
Premise:
Using SQL7, Win2000Server
Users select the branches of a tree structure based on their preference. There are 6 options of which 4 may be selected. The code uses these options to write a menu....for example
Publisher
--Topic
----Author
------Title
These values are stored in a table, then retrieved when necessary.
Work Around:
I am using asp code to generate the sql statement in the page then executing it.
What I would like to do:
I would like to pass the fields (tbl.Field) as parameters into a stored procedure. Each attempt I have made has resulted in the text of the parameters being returned in each row...
"tbl.Field1" "tbl.Field2" "tbl.Field3" "tbl.Field4"
"tbl.Field1" "tbl.Field2" "tbl.Field3" "tbl.Field4"
"tbl.Field1" "tbl.Field2" "tbl.Field3" "tbl.Field4"
Rather than data...
"Random House" "WWII" "Smith" "Smith's WWII Book"
"Random House" "WWII" "Jones" "Jones's WWII Book"
"Random House" "WWI" "Jones" "Jones's WWI Book"
Basic sp code attempted:
Create Proc Blah
(
@Param1, @Param2..... varchar(50)
)
As
Select @Param1, @Param2.........
From ....
" |
|
|
|
|
|
Parameterized Select in Stored Procedure