Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by bbeeharry

  1. bbeeharry

    parameter with multiple values

    Hi, i have a parameter which can take multiple values. how can i reprent this in my sql? Thks, bbe
  2. bbeeharry

    count number of month

    yes for whole month
  3. bbeeharry

    count number of month

    Sample data : Ebase table : ebid,firstname,lastname, adress,ect.. Employee table:eeideb(foreign key) ,datebeg,dateend,status when an employee is active, dateend is null and status ='active' the query will be run yearly from Jan. - Dec. is it clearer for you now?
  4. bbeeharry

    count number of month

    i have a situation where i must count the number of month an employee is active in a year : Example 1: from Jan to May Active, June to July on leave, August to Sept Active, so 7 months Example 2: from Jan to May Active, from June to Sept Terminated..so 5 Months or the employee can be active...
See more

Part and Inventory Search

Back
Top