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 wOOdy-Soft 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 piconel

  1. piconel

    Grouping

    Sorry Ido, your select statement seems easy enough, but let me show you what I have and then maybe you can give me a hint as to how I can convert it to what you suggested... SELECT SESION."SESSION_ID", SESION."DESCRIPTION", SESION."MODIFY_DATETIME&quot...
  2. piconel

    Grouping

    Hi Guys. Thanks for responding. When I link the 2 tables together, I actually lose information. First of all, not all information is represented in both tables. Most of the information is in the Problems table. The Transfer table has 'supporting' information. I need to sort the information...
  3. piconel

    Grouping

    I have created a report using 2 tables. Within these tables there are 2 field names that have the same TYPE of value, (names) but different Table names {PROBLEMS.GROUP_ID} AND {TRANSFER.GROUP_ID}. I would like to get these two groups to sort together, under 1 grouping. Is there anyway that I...
  4. piconel

    Oracle Scripting

    I am using an Oracle (8) database, with Tivoli Service Desk as the application. If the application crashes when a user has a 'problem ticket' open, the application sees that ticket as locked. The fix is fairly easy... sign into Oracle, type the following command UPDATE PROBLEMS SET ACTIVE_WITH...

Part and Inventory Search

Back
Top