create a function for multi selection option in drop down list

• atlancharlo

  Mr or Mrs. 500

  Points: 554

  More actions

  November 16, 2011 at 11:39 am

  #246975

  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.

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  November 16, 2011 at 12:13 pm

  #1408797

  Please don't cross post. Direct replies to the original thread. http://www.sqlservercentral.com/Forums/Topic1207019-1063-1.aspx

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/