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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 store procedure

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-03-18 : 08:22:02
sunil writes "hi all,

i am passing a string value to a store procedure which will
be used inside a select query in the store procedure..
For example

Select code,name from tablename where code in (@inputparameter)

inputparameter will have 'A0001','B0001','C0001' AS VALUES

but i am not getting the output for this type of query

Please help me out"

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2004-03-18 : 08:28:31
There are many methods to accomplish this task:

Have a look at the following articles on SQLTeam.

http://www.sqlteam.com/searchresults.asp?SearchTerms=csv
Go to Top of Page
   

- Advertisement -