Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2002
    Location
    India
    Posts
    37

    Red face Unanswered: Developing a Search Case

    hi all,
    I am developing a search case...and i got to develop a stored procedure.

    the procedure will be called in the following way...

    exec search_text('t1@c1%c2%c3%t2@c1%c2%c3%t3@c1%c2%,'he llo')

    i.e. i want to search for 'hello' in the t1,t2,t3 tables and c1,c2,c3..are the corresponding columns in respective tables..

    writing select statement is easy.,..but need a best solution to divide the tables and columns and then writing the procedure...

    help me out...

    thanks and regards
    sai sreenivas

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Hi,

    it all depends on what database server you want to run the Stored Procedure...
    So, what's the database and we try again...
    rws

  3. #3
    Join Date
    Aug 2002
    Location
    India
    Posts
    37

    Re: Developing a search case...

    hii ,
    My Database server is SQLSERVER on windows 2000 platform......


    looking forward for your reply...

    thanks and regards
    SAI SREENIVAS JEEDIGUNTA

  4. #4
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    I'm sorry man, I'm not that familiar with Microsoft software.
    If it were DB2 or Informix I could give you the solution...
    rws

  5. #5
    Join Date
    Feb 2002
    Posts
    2,232
    Will you always have the pattern 1 table and 3 columns ? Can you post the sql statement you have already designed that you want emulated in the sp ? Will you be running this sp in sql server or through a front-end like visual basic ... ? Will you always be searching for "hello" or some unknown string ?

  6. #6
    Join Date
    Feb 2002
    Posts
    2,232
    What results are you expecting back from your stored procedure ?

Posting Permissions

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