create a function for multi selection option in drop down list
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.
November 16th, 2011 1:49pm
Not too sure what you mean but you can edit the parameter and select multi-select.
November 17th, 2011 10:58am
Hi Charatla654321, Just as nas_55 said above, please clarify what your intention to create a function, and call it in procedure. As we know, the procedure can accept muti-value parameter, what your need to do is just modify your procedure like below: CREATE PROCEDURE ProcedureTest @p1 int, @p2 varchar AS BEGIN SET NOCOUNT ON; SELECT column1,column2,column3 from tb1 where column1 in (@p1) and column2 in (@p2) END GOPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
November 18th, 2011 6:55am