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 - 8 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

Which version of PHP should I start to learn, and how? I know HTML and CSS, and intend to build with Drupal (or similar) and its many extensions. [more inside]
posted by prophetsearcher on May 4, 2008 - 12 answers

MySQL sorting issue. When I have "first name" and "last name" columns, and I'm sorting primarily by "last name." Some entries have only a "first name," and rather than have those end up at either the start or end of the sort, I'd like it to pretend the "first name" IS the "last name" and sort accordingly. Is there a way to do this with the SQL SELECT statement or should I just edit the data? [more inside]
posted by dnash on May 2, 2008 - 8 answers