235 posts tagged with sql. (View popular tags)
Displaying 101 through 150 of 235. Subscribe:

Related tags:
+ (76)
+ (42)
+ (41)
+ (33)
+ (26)
+ (16)
+ (16)
+ (15)
+ (12)
+ (11)
+ (9)
+ (9)
+ (8)
+ (8)
+ (7)
+ (6)
+ (5)
+ (5)
+ (5)
+ (5)
+ (5)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)

Users that often use this tag:
DakotaPaul (6)
odinsdream (6)
desjardins (5)
arrowhead (3)
inigo2 (3)
iamkimiam (3)
Just this guy, y'know (2)
Dr Dracator (2)
jfricke (2)
Glendale (2)
omnipotentq (2)
maxwelton (2)
adipocere (2)
bleucube (2)
apark (2)
mark7570 (2)
Wild_Eep (2)
Four Flavors (2)
AllesKlar (2)
Anonymous (2)
derbs (2)
eas98 (2)
benjh (2)
dnash (2)
Nothing (2)
Jimbob (2)

Help solve my SQL mystery

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?

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

Help save me hours of busy work

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

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

Comparing two similar but non-matching tables in Access?

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

How does flickr do it?

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

How do I convert checkbox results to numbers?

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

Replacing multiple spaces in a string using T-SQL

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

Can I do something in SQL that makes no real sense to be able to do?

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?

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

WordPress noob totally frustrated trying to export from

Way old version of WordPress ( 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 and I am so frustrated. [more inside]
posted by librarina on Nov 1, 2008 - 5 answers

Indexing a SQL table for efficient queries

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

Fastest inserts for audit log table

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

Can you help my SQL?

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

How do I create a SQL Server 2000 'View' programmatically, using Visual Basic?

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

MySQL joins

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

Database suggestions

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

This was not in my contract!

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

Reconstituting a wiki database from html?

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

Translating 's/ */ /g' into T-SQL?

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

Complex SQL Query

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

More SQL help, please

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

Need help with a SQL query

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

What's all this SQL the kids are putting on my lawn these days?

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

SQL statement that returns table and field names in MySQL

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

How can I import a 46GB database into MSSQL without ending up with a 46GB transaction log?

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

Mobility Options for a Non Mobile Application

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

Fuzzy text completion algorithm?

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

PerHaPs SeQuentiaLly?

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

SQL sorting when sort field is null

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

How much database normalization is too much?

How much SQL normalization is too much? [more inside]
posted by EduTek on Apr 25, 2008 - 21 answers

interpolating dates in SQL query

In a SQL query that returns totals by date, how to interpolate dates where there are no results? [more inside]
posted by i_am_joe's_spleen on Apr 20, 2008 - 7 answers

Doing JOINs the Rails way

How can I do a Rails find JOIN without SQL, using the two tables' existing has_and_belongs_to_many relationships? [more inside]
posted by Blazecock Pileon on Apr 18, 2008 - 5 answers

SQL CTE Question

I need help with a SQL CTE which works in SQL 2005 but doesn't in Business Objects. [more inside]
posted by onhazier on Apr 18, 2008 - 1 answer

SQL and mail merge help needed in Access 2007

I have an Access 2007 database with client information and I need to make it do two relatively simple tasks. [more inside]
posted by desjardins on Apr 11, 2008 - 6 answers

Synchronize databases....3...2...1... NOW!

What's the best way to keep data one way synchronized between an internal Mircosoft SQL Server database and a web facing mySQL database? [more inside]
posted by advicepig on Apr 3, 2008 - 9 answers

What is the "state of the art" with respect to Python on Windows?

What is the "state of the art" with respect to Python on Windows for Active Directory administration and interfacing with MS-SQL 2000/2005/2008? [more inside]
posted by adipocere on Apr 2, 2008 - 7 answers

Access My A**

Why isn't a query in Access returning the correct data compared to the equivalent query in SQL Server. More inside. [more inside]
posted by zackola on Mar 31, 2008 - 11 answers

It keeps growing and growing and growing...

Help me understand MSSQL logs... At least enough to do what I need to do. [more inside]
posted by eas98 on Mar 28, 2008 - 1 answer

mysql query help please

MySQL question: Given a table with a datetime column and several additional columns which may or may not be null, is there an easy way to select the most recent previous non-null value of each column given a specific date? [more inside]
posted by Nothing on Mar 13, 2008 - 10 answers

Restore humpty_SQLdumpty?

Through a series of dumb (though possibly dumb-lucky) mistakes and mysterious errors followed by disk failure, I am piecing a SQL (2005) server back together from not exactly optimal ingredients. I need help. [more inside]
posted by Lyn Never on Mar 2, 2008 - 1 answer

How to count the number of times a string appears in a database field.

SQL Filter: What query can I use to count the number of times a word appears in a text field? [more inside]
posted by Wild_Eep on Feb 21, 2008 - 6 answers


How does one get their head around OLAP? [more inside]
posted by SirStan on Feb 10, 2008 - 4 answers

How is Facebook doing its queries?

How does Facebook handle or simplify the presumably complicated DB queries involved so that me loading my page doesn't bring it to its knees? [more inside]
posted by bonaldi on Feb 4, 2008 - 27 answers

SQL/DBMS ninjas please help! How can I replicate my current abilities at a new company from scratch?

Some colleagues and I will soon be leaving our current employer and starting a new company. How can I best replicate our current relational database/SQL abilities from scratch? [more inside]
posted by raz5 on Jan 23, 2008 - 11 answers

Best DBA certification?

What DBA certification should I pursue? MS, Oracle, something else? [more inside]
posted by davar on Jan 15, 2008 - 3 answers

Extremely simple SQL, Access, .ASP help.

How can a fool make a table in an Access database reference another table, using SQL and ASP? [more inside]
posted by dirtdirt on Jan 11, 2008 - 10 answers

how to become a genius application developer overnight!

Second-Day-on-the-Job Panic: How can I get my mostly-self-taught, LAMP-loving self to be more confident and capable with developing corporate/enterprise applications? [more inside]
posted by logic vs love on Jan 8, 2008 - 11 answers

Cancel a SQL Server Query

Please help me understand what happens when I click the cancel query button in SQL Server Management Studio. [more inside]
posted by smithygreg on Nov 29, 2007 - 3 answers

Tricky SQL for a simple function

Been banging my head against the wall on this the whole day. I need a way to select & sort data from a single MySQL table, but it's a little bit more complicated that it seems. [more inside]
posted by arrowhead on Nov 23, 2007 - 14 answers

Page: 1 2 3 4 5