What interesting statistical information can I dig out of this medical billing data? [more inside]
posted by neilkod on Nov 19, 2009 - 8 answers

SQLfilter: Trying to sum and count two fields contained within the table by specifying criteria (more inside). [more inside]
posted by kasperj74 on Nov 10, 2009 - 4 answers

In the Seattle/Snohomish area. Which schools provide good training in beginning SQL, or database design, or IT project management? [more inside]
posted by valannc on Oct 31, 2009 - 2 answers

MS SQL Pros, I need your help! What's causing MS SQL 2005 to import records so slowly? It's a persistent problem across all databases that just developed yesterday. Details inside... [more inside]
posted by antonymous on Oct 20, 2009 - 9 answers

I can't seem to build a query in SQL Server 2005 that returns rows that are not in a table. [more inside]
posted by DakotaPaul on Oct 7, 2009 - 17 answers

Can someone help me understand how the WITH common table expression works in Microsoft SQL Server? [more inside]
posted by DakotaPaul on Sep 11, 2009 - 9 answers

SQL question: Getting all records based on a row-specific criteria [more inside]
posted by 0xFCAF on Jul 26, 2009 - 6 answers

I have a basic sql query which returns all jobs run between specified dates as follows: SELECT job_id, starttime, size FROM job_history WHERE (starttime > FromDate) AND (startTime < ToDate) But I also want the query to return the previous size for that job_id [more inside]
posted by xla76 on Jul 23, 2009 - 4 answers

I need to write a query that will return the largest value of one column for each unique value in another column. Example included. [more inside]
posted by davcoo on Jul 17, 2009 - 2 answers

How to make Active Directory and SQL server synchronize User accounts/passwords. [more inside]
posted by bleucube on Jul 16, 2009 - 6 answers

Tearing my hair out over what feels like a simple PHP/SQL question: mysql_fetch_array returns, dur, an array of all the rows that matched your query. How can I tell it to skip a row of that array? More inside. [more inside]
posted by GilloD on Jun 27, 2009 - 14 answers

In SQL, how do I use the results of a SELECT to perform row-specific UPDATEs? [more inside]
posted by adipocere on Jun 1, 2009 - 6 answers

I need an inventory management system to keep track of computer hardware and its users. [more inside]
posted by the matching mole on May 7, 2009 - 3 answers

Oracle Views: Are calculated columns always evaluated even when they are not considered in a query? [more inside]
posted by NailsTheCat on Apr 21, 2009 - 7 answers

I have a (hopefully easy) SQL question. I'm working in MS Access. Simplifying things a bit, I have a table with a TaskID, and a TaskStatusID. I want to get a list of each TaskID, and the newest TaskStatusID for each. (Details follow.) [more inside]
posted by inigo2 on Apr 21, 2009 - 7 answers

SQL query help. Given the (fictional but equivalent) table disk_status = computer_id:int, disk_id:int, datetime:datetime, temperature:float, rpm:int, I need to provide a table of disk status for a given computer_id, without knowing in advance how many disks there are. So if there were two disks for a particular computer, the result would have the header: datetime, disk_1_temperature, disk_1_rpm, disk_2_temperature, disk_2_rpm, disk_2_rpm [more inside]
posted by Nothing on Apr 16, 2009 - 25 answers

Is there a GUI SQL editor that emulates a spreadsheet-style "copy down"? If not, is there a technique I should learn? [more inside]
posted by rokusan on Apr 14, 2009 - 10 answers

Please help me simplify a complicated mysql update [more inside]
posted by special-k on Mar 27, 2009 - 19 answers

I have been asked to make a proposal to upsize an Access database to allow for a few more concurrent users (currently 10) and ideally improve the overall performance of the system. Am I getting in over my head? [more inside]
posted by cbrody on Mar 10, 2009 - 11 answers

I've got an interview for a marketing analytics position that involves SQL - how can i learn about SQL/practice? [more inside]
posted by jourman2 on Mar 9, 2009 - 18 answers

Nerdlinger/Microsoft Server Filter: Can SQL 2000 exist in a Windows 2008 Domain when installed on a Windows 2000 member server ? Before anyone says it, yes, yes I know it's old, outdated, unsupported, we should be using SQL 2005 or looking at SQL 2008 and that it can't be installed on a Windows 2008 server. BUT... does anyone know if SQL 2000 will work when installed on a Windows 2000 server that is a member of a Windows 2008 domain? I know that Windows 2000 servers can be members of a 2008 domain but Exchange 2000 won't work. Will SQL 2000?
posted by Man_in_staysis on Feb 25, 2009 - 13 answers

Is there a nice way for me to run a report on an Excel spreadsheet and have that report e-mailed to me? I have a spreadsheet with dates of contracts expiring, I would like for it to shoot me an e-mail notifying me that I'm within 30 days of that contract expiring, that a new contract has been added and so on. [more inside]
posted by geoff. on Feb 20, 2009 - 7 answers

How can I get the IN function to work in my SQL? [more inside]
posted by urbanwhaleshark on Feb 19, 2009 - 12 answers

Can I specify the order in an ORDER BY clause in a SQL Statement? If not then what is the best way of doing the following query? [more inside]
posted by xetere on Feb 19, 2009 - 9 answers

How can I update whole columns in a sql database using new information from an excel spreadsheet while using a Mac? [more inside]
posted by visual mechanic on Feb 16, 2009 - 5 answers

SQL puzzle, MySQL in particular. [more inside]
posted by xmutex on Feb 10, 2009 - 15 answers

Microsoft Access query problem - Comparing two similar tables that don't match up well. It's lists of classes in a collection of locations from two consecutive years, and what I need is to show the class fees side by side for any class that happened in the same location both years. [more inside]
posted by dnash on Feb 5, 2009 - 13 answers

My developer and I want to create a database schema that allows us to search through hundreds of tags applied to thousands of records. So far our benchmarks suck. Are we expecting too much? [more inside]
posted by hayvac on Feb 4, 2009 - 17 answers

Can anyone give me advice on dealing with checkboxes in PHP, to hand off to SQL. [more inside]
posted by opsin on Jan 30, 2009 - 8 answers

Please help me find the T-SQL that removes duplicate spaces within a string (or suggest your own method). [more inside]
posted by DakotaPaul on Dec 17, 2008 - 2 answers

SQL Question: can I have a column in a table of results that has it's own restrictive clause. [more inside]
posted by Hartster on Dec 9, 2008 - 10 answers

Can I connect to a SQL Server 2000 database using SQL Server 2005 Express? [more inside]
posted by Glendale on Nov 5, 2008 - 2 answers

Way old version of WordPress (1.5.1.3). I need to upgrade, obviously. I am considering switching hosts at the same time and so I am trying to figure out how to export the current blog so I can import it once upgraded at either current or new host. But I can't figure out how to export on 1.5.1.3 and I am so frustrated. [more inside]
posted by librarina on Nov 1, 2008 - 5 answers

I have a MySQL table with about 100,000 items in it. Question about setting up indexes for efficient querying. [more inside]
posted by maxwelton on Oct 15, 2008 - 8 answers

How should I optimize a SQL Server 2000 table which will only ever be used for INSERTs? [more inside]
posted by ParsonWreck on Sep 15, 2008 - 9 answers

SQL/MS Visual Studio help please! I have two tables. I need to present Table1 data grouped by SiteID, within time FROM and TO, on the report. Then I need to make one calculation on the report using Table 1 data totalled across all sites (and within FROM and TO) plus Table 2 data totalled between times FROM and TO. [more inside]
posted by inigo2 on Sep 10, 2008 - 10 answers

I'm working in Visual Basic (Access 2003, technically) with a SQL Server 2000 backend, and I believe I need to create a View dynamically... I am very familiar with creating QueryDef's and Stored Procedures on the fly, but have never attempted to create a View in this manner... My google-fu seems to be failing me at the moment.. [more inside]
posted by Glendale on Sep 2, 2008 - 2 answers

I have a problem joining three tables in MYSQL. [more inside]
posted by dydecker on Aug 21, 2008 - 19 answers

Database Olympics: File Maker Pro vs. MySQL! Help us pick a database system (Anko or Firebrand). Which do you think is superior to run a print publication database? [more inside]
posted by spakto on Aug 19, 2008 - 6 answers

FrontPage Filter: How do I find the SQL database the dropdown list is pulling from? Difficulty: Fixing a site I didn't design. [more inside]
posted by ApathyGirl on Aug 12, 2008 - 13 answers

I'd like to reconstitute a years-defunct wiki I used to collaborate on. I've contacted the principals, & our searches for the database backup have come up empty so far. Without having the original database, the simplest path appears to be taking the html & transforming it into, say, an sql dump. So - how do I do that? Are there any MediaWiki, database, or Perl trails to follow?
posted by Pronoiac on Aug 6, 2008 - 10 answers

Fixing whitespace: Can someone translate 's/ */ /g' into T-SQL? [more inside]
posted by pompomtom on Jul 30, 2008 - 2 answers

SQLFilter: I'm struggling with a specific SQL query. I have 2 tables, 'questions' and 'answers', which are linked by a field in answers. I would like to select the questions which have the most answers in the last 24 hours. [more inside]
posted by charmston on Jul 19, 2008 - 2 answers

Another SQL question (*sigh*), but this time a bit more complicated. [more inside]
posted by omnipotentq on Jul 15, 2008 - 7 answers

I've got what should be an uber-simple SQL question.... [more inside]
posted by omnipotentq on Jul 7, 2008 - 8 answers

Computer-ese for the illiterate: What's all this SQL that's gotten all over everything? Whadizzit? [more inside]
posted by penciltopper on Jul 7, 2008 - 10 answers

Are there SQL statements that return table names and field names for given table names in MySQL Server (5.0.22)? [more inside]
posted by joemako on Jul 7, 2008 - 8 answers

I need to import a database into MS SQL but I do not want to end up with a transaction log as large as the database. What's the best way to do the import? [more inside]
posted by odinsdream on May 29, 2008 - 4 answers

We use clinical software that uses a MS SQL database. It has a five million records weighing in at 40 GB. The software doesn't have a mobility option but we need one. The company has it on their feature request list but its at least 3-5 years away. HELP. [more inside]
posted by bleucube on May 29, 2008 - 20 answers

I'm looking for a fuzzy text-matching algorithm for an autocomplete widget. [more inside]
posted by sonofslim on May 10, 2008 - 9 answers