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 - 2003-02-27 : 12:38:44
|
| sur writes "HI all,I want to write a storeprocedure to getthe details of sites for the selected districts..this is wrote...CREATE PROCEDURE dbo.Dr_spDRSites(@District Varchar(1000)) ASBEGIN begin select sun_site as Site,site_name as Sitename from oper_type_new, oper_sundata where oper_type_new.sun_site = oper_sundata.site_id and district_type in( @District) group by sun_site,site_name end endGOi will pass input paramter like this ...'88010','88020'..so on if i give one exec Dr_spDRSites '88010' this is workingbut i give this exec Dr_spDRSites '88010','88020'this is giving the following error Server: Msg 8144, Level 16, State 2, Procedure Dr_spDRSites, Line 0Procedure or function Dr_spDRSites has too many arguments specified.so let me know how to sort the proband the district_type in the table is varchar(15)thanksS" |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2003-02-27 : 12:38:44
|
| If you read the FAQ you'll find links to some articles on handling CSV values. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Storedprocedureprob - CSV