Results 1 to 2 of 2

Thread: search?

  1. #1
    man Guest

    Default search?

    Hi,<BR>I am trying to building a menu-based search engine by developing a query string dependent on what the user selects from various menus which are tied into various DB tables. I can use sp_executesql to send in parameters from one table, but I am having difficulty passing in several parameters from different tables. Has anyone done this or know a good resource where i could read about it?? Thanks a lot.

  2. #2
    Join Date
    Dec 1969

    Default RE: search?

    Send in the parameters to a stored proc and build a dynamic SQL string using these parameters and load that into a local @variable. Then Execute that @variable.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts