Building a Search SP?

• hitek2000

  SSC Veteran

  Points: 244

  More actions

  February 25, 2004 at 8:50 am

  #109060

  Any info available on how to build a stored procedure that can have variables passed to it from a search form in order to query a table?  I am trying to pass either one or multiple values that will be used in dynamically building the select statement based on what is passed...  Thanx for the help....

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  February 25, 2004 at 9:15 am

  #495602

  This might be a start

  http://www.sommarskog.se/dyn-search.html

   

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]