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 - 2001-03-06 : 21:11:01
|
manish writes "I am supplying a Stored procedure with comma seperated values namely integers exmp. 1,2,3....from my ASP script
I have a select statement in the stored procedure which uses the "where in (my comma seperated values)" clause.
The Stored Procedure is...
CREATE PROCEDURE SpDispSpCategory2 @ParentId INT AS
Select * from PhoneCategory
Where SpANCategoryId in (@Parentid )
Order by SpVName Asc
Now since the the parameter(@parentid)has been declared as integer it doesn't take in the comma seperated values. If i declare @parentid as a varchar there is a conflict with the column SpanCategoryID as it is of type Int....
I don't want to use a for loop to repeatedly call the Stored Procedure instead......
SQL SErver 7.0
IIS 5.0
Please Help !!!!!!" |
|
|
|
|
|
Comma seperated values to a stored procedure