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!

  • Congratulations IamaSherpa 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. jbodine

    TSQL LEFT OUTER JOIN to PL/SQL Join Help

    Thanks all. The WHERE AND ToPS was a typo on my part, I have a huge stored procs, so i was cutting out just the parts that I needed help with so you did not have to strain to understand it all. In any cause the (+)= on the other conditions did the trick. I am new to Oracle, and have been...
  2. jbodine

    TSQL LEFT OUTER JOIN to PL/SQL Join Help

    Ok. I am in the painstaking process of converting a bunch of reports with stored procs written in TSQL (MSSqlserver) to PL/SQL. I am having issues with one of my joins and getting it to work right in PL/SQL IN TSQL its looks something like this: SELECT * FROM ParticipantSegment PS LEFT...
  3. jbodine

    Time Increment Group Formula

    I work for a call center and need to create a report, that groups records by a time increment parameter entered at run-time. If run the report for the time frame of 8:00 AM to 10:00 AM with a time increment of 30 minutes, I need to tie my result set (which is coming from a stored procedure) to...

Part and Inventory Search

Back
Top