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 2008 Forums
 Transact-SQL (2008)
 create a function for multi selection option in dr

Author  Topic 

atlachar123456
Starting Member

33 Posts

Posted - 2011-11-16 : 13:50:35
Hi,
I want a code for how to create a seperate function outside,i have a parameter in my procedure called @principal and @firm,for tehse two
i have to create a function outside with multi selection option in drop down list.just creating a seperate function and calling that in procedure.
can anyone help me how to write a code for these two parameters and how to call in SP.



atlaaaaaaaa

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-11-17 : 00:28:09
see one such function below


http://visakhm.blogspot.com/2010/02/parsing-delimited-string.html

and it can be called as


SELECT Val
FROM dbo.ParseValues(@principal,',')
...


------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -