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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. anju77

    Select statement

    Thanks Lewisp! date in the table doesn't have time. and i just want to return one row based on my condition. if the parameter passing matches with the table date then return that date else if it doesn't match then return the latest date in the table Thanks,
  2. anju77

    Select statement

    Hi friends, i have a cursor in which I am passing two parameters (eff_dt and empl_id). In a table there can be more than one record for a employee with the diff effective date. I want to do a select on a table when eff_dt is not null and table column effective date = parameter eff_dt then select...

Part and Inventory Search

Back
Top