From two MySQL tables, I need to fetch a list of customers who DOES NOT have an invoice issued to them within the past 2 months. More details about the table structures inside.
[more inside]
posted by arrowhead
on Sep 3, 2007 -
10 answers
Any SQL / math ninja's on the green fancy a quick challenge..? So I've got this table containing number pairs, right, and I need to compute all the possible combinations.
[more inside]
posted by whoojemaflip
on Aug 15, 2007 -
25 answers
I'm trying to merge simple contact data from a bunch of single tables into one big text (csv) dump. The problem is that not all fields are present for each user. e.g. one user may be missing an email. Because of the missing field, my current (big and ugly) sql query will not return all the rows.
[more inside]
posted by kamelhoecker
on Aug 2, 2007 -
13 answers
Looking for some guidance in building an "advanced search" query using XML and optional multi-value parameters.
[more inside]
posted by mkultra
on Jun 26, 2007 -
6 answers
Can FileMaker read from a SQL database? I've talked to (SQL) developers and they can't find a way to do it.
[more inside]
posted by mark7570
on Jun 21, 2007 -
8 answers
What's the best way (using the internet, and/or books) to learn how to query SQL databases with Ruby?
posted by anonymous
on Jun 10, 2007 -
3 answers
Help me properly set up a very small relational db. This is a teensy bit over my head, so mainly I want to establish that I'm not going terribly wrong before I get too far into this.
[more inside]
posted by desjardins
on Jun 6, 2007 -
5 answers
Access SQL Query - I have multiple individuals each with an address. I need to make mailing labels, but if two or more people share an address, I would only like one label.
[more inside]
posted by odinsdream
on Apr 18, 2007 -
9 answers
What free tool from Microsoft or otherwise will let me peruse and edit a SQL Server 2005 database?
[more inside]
posted by iconjack
on Apr 10, 2007 -
10 answers
Wheres the best place to learn things like how to migrate a messy pile of microsoft access databases to sql? Normally when learning new I use books, online sources and forums, and good old fashioned trial and error, but its a slow process for some of us. As its easier learning from someone with experience in the field. are there any sites that go some way to addressing this teacher / student system online, aside from the usual forum formats, i was thinking of some sort of bartering system, but for knowledge not pigs?
posted by ugrndhg
on Feb 17, 2007 -
3 answers
Databasefilter: I'm a self-taught 'DBA' (I use quotes so as to not offend those who have this knowledge through a paid education). I'm having an efficiency problem with a few of my tables, and I thought maybe one or two of you could help.
[more inside]
posted by thanotopsis
on Jan 31, 2007 -
20 answers
How do I update rows in a table in a SQL*Server 2005 database with data from another row in the same table?
[more inside]
posted by apark
on Jan 24, 2007 -
5 answers
I'm doing some consulting as a release manager on a webapp. I recently got the programmers to start using subversion (by turning off their access to their old development areas...) and their own sandboxes, and releases go more smoothly than ever. But I'm getting configuration files that have to be individualized for environments leaking into the trunk, and I want to get my release process down to "type command. hit enter." What to do?
[more inside]
posted by SpecialK
on Jan 20, 2007 -
6 answers
Microsoft Access. An SQL "GROUP BY" query. How do I generate the
mode of the values that it's grouping, when I want averages in other multiple fields?
[more inside]
posted by Jimbob
on Dec 13, 2006 -
3 answers
mySQLfilter: How can I ignore "A, An, & The" at the beginning of book titles when sorting results alphabetically by title?
[more inside]
posted by Wild_Eep
on Dec 5, 2006 -
10 answers
SQL question: How do I get the record with the most current date for each person's ID? Better explanation inside.
[more inside]
posted by DakotaPaul
on Nov 21, 2006 -
14 answers
Access SQL:
How to use a short list of numbers stored as text in a table cell as the criteria for a query?
[more inside]
posted by Zetetics
on Nov 6, 2006 -
9 answers
Attention SQL gurus. This has me completely stumped. How can I find the index (position) of a row in a table without querying the entire set?
[more inside]
posted by Civil_Disobedient
on Sep 3, 2006 -
12 answers
Calling all SQL / DBA / code monkey brainiac's! Please help me understand what is happening in this mess ....
[more inside]
posted by AllesKlar
on Jul 3, 2006 -
8 answers
Need some help with combining SQL queries. New to SQL - some programming back ground.
[more inside]
posted by lutzla23
on Jun 30, 2006 -
9 answers
Question for the SQL ninjas in the house. Say you're grabbing data from a bunch of similar tables in a big union. Now say you want the last ten items added anywhere to the database, from any one of those tables. What's the most efficient way to do that?
[more inside]
posted by mathowie
on May 10, 2006 -
22 answers
How can I convert Excel 95 to at least '97 when uploaded to a server (iis) or...
[more inside]
posted by Mick
on May 2, 2006 -
7 answers
SQL WTH: various examples given on websites and in a small stack of books don't work.
[more inside]
posted by Tuwa
on Apr 15, 2006 -
9 answers
I have an Excel Spreadsheet (using Excel 2003). Rather than creating formulas to answer ad hoc questions that I have, I would like to be able to quickly type in a SQL querty against the data in the spreadsheet. So, I could scroll down to the bottom of the sheet to see how many rows I have, OR I could type" select count(*) from data_table" instead. I prefer the latter. Any suggestions?
[more inside]
posted by apark
on Apr 7, 2006 -
6 answers
I have an SQL query that totals the number of students per grade. How do I get a grand total of the number of students?
[more inside]
posted by DakotaPaul
on Mar 17, 2006 -
6 answers
How can I import selected fields from one database into another database?
[more inside]
posted by fvox13
on Mar 16, 2006 -
6 answers
I'm writing a small app to store my contacts. There's a little tool to search for names. When I search for "Jo", the results should display all names starting with "jo", followed by those with "jo" in the middle:
1. Joanna
2. John
3. Jonathan
4. Marjorie
5. Mojo
How do I do this using a single SQL statement?
posted by arrowhead
on Mar 9, 2006 -
14 answers
I have a Windows-served website programmed in C# and connected to a SQL database. I'd like to move the whole thing to the Mac.
[more inside]
posted by thejoshu
on Feb 24, 2006 -
8 answers
Please help me find an alternative to IE Scrapbook Scraps, which allow field text to be saved for future searches
[more inside]
posted by ParisParamus
on Feb 20, 2006 -
20 answers
I'm looking for a software tool that will ingest a large XML file, and allow me to write sql-like queries against it for both summary reporting, as well as detailed reports.
[more inside]
posted by nomisxid
on Feb 15, 2006 -
31 answers
What is the optimum way in an ASP.NET Web Application with SQL Server 2000 to perform the following data correlation?
[more inside]
posted by kenaman
on Jan 19, 2006 -
2 answers
