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 TouchToneTommy 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: *

  • Users: Darrel77
  • Content: Threads
  • Order by date
  1. Darrel77

    Help with Group By....

    Here's what I need... My simple query looks like this.... SELECT acctnum, checknum, postdate, amt FROM trans WHERE checknum is not null AND postdate between '30-JAN-06' AND '02-FEB-06' GROUP BY acctnum, checknum, postdate, amt ORDER BY acctnum, checknum ...I need to create a report that...
  2. Darrel77

    Need to identify break in

    Here's what I need... My simple query looks like this.... SELECT acctnum, checknum, postdate, amt FROM trans WHERE checknum is not null AND postdate between '30-JAN-06' AND '02-FEB-06' GROUP BY acctnum, checknum, postdate, amt ORDER BY acctnum, checknum ...I need to create a report that...
  3. Darrel77

    HELP - Passing second value into separate column

    Hello all... I'm have a slight dilemma in SQL. I'm running the below query... select DISTINCT a.acct, p.first||' '||p.last OWNER, p2.first||' '||p2.last OWNER2 from person p, person p2, act a, actperson arp where a.NBR = p.nbr and arp.nbr = p2.nbr and a.acct = arp.acct ACCT OWNER...
  4. Darrel77

    Using value from one field to obtain additional returned rows in query

    Please pardon the long subject, but I have no idea how to explain this issue. Has anyone out there ever tried this one... I have a simple query that I need to complicate. This hopefully can be done. Take a look at the below sample data... select * from TABLE_A where nbr = '1234'; NBR REC TYPE...
  5. Darrel77

    Resetting Line Number field - HELP!!!

    I'm having a severe brain-freeze here, guys. Here's my dilemma: I have over 350 rows in my ADDRESS table in which a dataload has gone wrong. Over 350 rows were inserted into the ADDLINE table with no respect for the LINENBR value. And as we all know, if the line numbers aren't set to 1 and 2...

Part and Inventory Search

Back
Top