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 strongm 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. sqltimmy

    How to use simple database?

    Is there a way I can use javascript to query from a simple text-based tab-delimited database using SQL, but without any special support like MySQL, Oracle, SQL Server, etc.? I basically just want to be able to query some info so I can dynamically insert text into my webpages. I just need to...
  2. sqltimmy

    How to take Diffrence of sets?

    I have a query with one column and 937 rows. I have another query with the same one column and 595 rows. I want to query the difference of these queries, but I am having a heck of a time finding the syntax to do it! I'm using SQL Server 2000 and it's not liking the DIFFERENCE function...
  3. sqltimmy

    Group By on a Union

    If you want to union them and THEN order them, I think this would work: SELECT * FROM (Select ponumber,Company from tableA union Select ponumber,Company from tableB) AS TABLE1 ORDER BY ponumber Is that what you mean? I didn't understand what you meant by "group by and order by ponumber...
  4. sqltimmy

    Extract data without Joining Tables

    That method creates too many record for though because I'm not looking for exact common fields. I need to select from APPS the records matching the month of the records in MONTH, but from the year before (2001). That method you suggests gives me essentially the same thing as MONTH because...
  5. sqltimmy

    Extract data without Joining Tables

    This one may be a little hard to explain, but here goes - I have a table APPS and table MONTH. MONTH is a subset of APPS that contains records with a date in the month of, say, January and in 2002 (the month of choice will vary). There's a part in the query I'm trying to build where I want to...
  6. sqltimmy

    Monthly Counts

    I have a table: APPS that lists data for applications for a number of applications including its date. I'm trying to build a query to list number of applications per month by month. I have a query listing the 12 months, and I can make other queries to find count the number of apps per month...
  7. sqltimmy

    SQL Query with CASE WHEN

    I'm getting syntax errors about missing operators when I use a query that is similar to: SELECT CASE WHEN (column1 > 0) THEN '1' WHEN (column1 = 0) THEN '0' WHEN (column1 < 0) THEN '-1' END AS field1 FROM table1 It works fine in MS SQL Server, where I first wrote the query, but...

Part and Inventory Search

Back
Top