DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Procedure help

Threaded View

  1. #1
    Join Date
    Feb 2002
    Posts
    267

    Procedure help

    Hi,

    I have two tables

    Emp_main
    Emp_id----Dept---Region


    Emp_info
    Emp_id---T1_Date-----Account---Customer


    We have a front end search Screen, which has to display the count of employees, based on certain conditons, say where Account=xyz or
    Customer='abc' or T1_Date between

    I am planning to have a Procedure with all the possible search parameters as IN parameters and have a single query as follows.


    select count(emp_id)
    from emp_main a, emp_info b
    where t1_Date between and
    and Account=
    and customer=
    and a.emp_id=b.emp_id

    Now my problem is, if the front end user wants to search only based on T1_date, rest of the IN parameters will be null.

    Say account,customer will be null.

    Some other user may search with with all the values for all the conditions.

    How can i handle this situation, when he searches based on only one value.



    can some body guide me.

    Regards
    Sonia
    Last edited by Sonia; 01-28-2004 at 05:25 AM.

Posting Permissions

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


Click Here to Expand Forum to Full Width