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 John Tel 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: Ach005ki
  • Content: Threads
  • Order by date
  1. Ach005ki

    SELECT only orders which have corresponding items

    Hi all I'm really struggling with this query: To only select sales orders where the ordered items are in a particular list of items. In the simplified example below, I would want to select only sales orders containing apples or oranges but not those orders containing any other fruit...
  2. Ach005ki

    Datename() in SQL column header? Dynamic SQL?

    Hi all I'm sorry if this question has been posted previously - I couldn't find evidence of such in six pages of searched posts; the nearest I came to was Results from Query as Headers Background I have monthly sales information in a table which is stored as SalesQty1 through to SalesQty12...
  3. Ach005ki

    LOJ and MIN brain-freeze

    Hi guys I'm really struggling today - I've been laid up in bed all weekend with stomach cramps (I'll not elaborate) and I'm still not feeling 100%... ... I can't get my head around how to pull the earliest outstanding Purchase Order from a PO detail table so that I can show the quantity...
  4. Ach005ki

    3 x COUNTs on 2nd table for DATEPART(Month, tabledatefield)

    Hi guys! I've tried hard to produce the code myself but I'm struggling. I'm but a mere student of these dark arts! I don't have access to Query Analyzer, SPs or other SQL Server 2000 functions - my only query tool is MS Query (which makes it a little difficult to write code in the SQL View box...
  5. Ach005ki

    searched CASE in SELECT - using MS Query on MSSQL2000

    Hello all I have a problem that I can't get around. I have limited access to our database. I can only use the query tool MS Query to interrogate our data tables, as the results are usually returned to Excel spreadsheets. I've asked for other query and reporting tools but in the meantime I'm...
  6. Ach005ki

    derived table versus correlated subquery

    Hi all I was interested in SqlSister's response to a question in which she stated that a derived table would allow returning more than one result whereas a correlated subquery precludes this (I presume unless the subquery is the data for an IN / NOT IN clause ?) I have a query of items in an...
  7. Ach005ki

    Query optimisation help - SELECTs within SELECT?

    Hello tech experts, users and fellow novices like myself. I'm in need of some help with my query text - when it runs it apparently spikes our server and hogs resource (but our dba won't see fit to letting us use anything other than MS Query for querying our database, with the queries usually...

Part and Inventory Search

Back
Top