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.

Not too sure what you mean but you can edit the parameter and select multi-select.

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.