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.
Free Windows Admin Tool Kit Click here and download it now
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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics