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 bkrike 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: huddles
  • Content: Threads
  • Order by date
  1. huddles

    update first record found

    Hello, I have the following query that finds all records which have count(col_A) > 1 and stat = '5'. SELECT DISTINCT TOP 100 i1.egc_id,i1.stat FROM dbo.table i1 INNER JOIN dbo.table i2 ON i1.egc_ID = i2.egc_ID GROUP BY i1.egc_ID, i2.egc_ID,i1.stat HAVING...
  2. huddles

    SQL Query

    I need to enter a sql query for a field. I have the following query, which will populate the field. How do I enter this or the equivalent? SELECT distinct i1.scan_id FROM item_xref i1 join item_xref i2 on i1.itm_id = i2.itm_id WHERE i1.scan_id <> i2.itm_id It essentially queries the...

Part and Inventory Search

Back
Top