252 posts tagged with sql.
Displaying 201 through 250 of 252. Subscribe:

orthogonality isn't a SQL know-it-all after all, let's laugh at him

Help! Stumped by an SQL problem. [more inside]
posted by hangashore on Oct 21, 2006 - 21 answers

A query connundrum.

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

Finding longest sequence in a set of numbers

I have a question about finding the longest sequence in a set of numbers. [more inside]
posted by maxwelton on Sep 2, 2006 - 13 answers

SQL results by minute?

Looking to group SQL by a certain time interval. How? [more inside]
posted by Four Flavors on Aug 25, 2006 - 14 answers

4 night SQL primer?

Can you help me with a primer on SQL? [more inside]
posted by horseblind on Aug 18, 2006 - 25 answers

Filling Sparse Data In An SQL Query

Filling Sparse Data In An SQL Query [more inside]
posted by boo_radley on Aug 7, 2006 - 5 answers

Gurus only

Perhaps advanced MSSQL question.. [more inside]
posted by eas98 on Jul 31, 2006 - 7 answers

No, no—*million* with an M.

MySQLFilter: Help me with my 56 million record table! Lots of cumbersome background inside... [more inside]
posted by disillusioned on Jul 19, 2006 - 12 answers

SQLFilter: Advancing Dates

How can I increment a value directly using SQL? [more inside]
posted by samstarling on Jul 17, 2006 - 3 answers

Converting Postrges-specific query to Mysql

I need help converting a Postgres-specific SQL query to MySQL [more inside]
posted by mcstayinskool on Jul 14, 2006 - 14 answers

These schema's make me want to screama!

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

help on SQL

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

Help with SQL unions needed

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

Working with Excel 95 files

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

on SQL and the pancake in the middle.

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

How to run a SQL Query on an Excel Spreadsheet

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

SQL select problem

help me with this SQL select [more inside]
posted by oh pollo! on Mar 20, 2006 - 24 answers

How do I get totals in a pivot table in SQL?

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

A SQL Join

How do I manage this SQL join? [more inside]
posted by nonmyopicdave on Mar 16, 2006 - 13 answers

How do I import from one database into another?

How can I import selected fields from one database into another database? [more inside]
posted by fvox13 on Mar 16, 2006 - 6 answers

PHP/MySQL question on search / sort

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

Succor From SQL

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

Alternative in IE Scrapbook feature?

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

One way 2 order results in Sql

How do I order the results of sql query numerically and alphabetically? [more inside]
posted by muddylemon on Feb 16, 2006 - 25 answers

How to query XML like SQL?

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

Advice on Web Application Data Correlation.

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

Easy Interface for SQL

What is the best alternative interface for an SQL server? [more inside]
posted by benjh on Jan 12, 2006 - 6 answers

Need SQL lessons

I need to learn SQL, presumably mySQL. [more inside]
posted by captainscared on Jan 4, 2006 - 22 answers

How can social scientists learn database skills?

What resources exist for non-techy social scientists who want to use relational databases to store their data, but don't know how? [more inside]
posted by jacobm on Dec 24, 2005 - 7 answers

How do I write arbitrary SQL queries in Ruby on Rails?

How do I write arbitrary SQL queries in Ruby on Rails? [more inside]
posted by smackfu on Dec 13, 2005 - 9 answers

SQL: Virtual Grouping?

SQL: Virtual Grouping? [more inside]
posted by odinsdream on Dec 13, 2005 - 9 answers

Data Overload, How Do I Manage?

How can I manage my databases that are exploding in size? Can I run SQL Server on my laptop? [more inside]
posted by benjh on Dec 9, 2005 - 9 answers

SELECT answer FROM askmefi

I need help with what I hope is a fairly simple mySQL query question. [more inside]
posted by Asparagirl on Nov 29, 2005 - 18 answers

Work from home IT jobs

I'm a techie who would like to work from home. Help me get started. [more inside]
posted by Dag Maggot on Nov 23, 2005 - 7 answers

Any recommendations for SQL training in Lodi, California?

Any recommendations for SQL training in Lodi, California? [more inside]
posted by DakotaPaul on Oct 10, 2005 - 1 answer

Can FileMaker have hooks into MySQL?

I have a MySQL database that contains two fields - name and e-mail - for a bunch of records. Separately I have a FileMaker 7 database that contains the same fields - name and e-mail - and contains other fields, like "notes". My question: can the FileMaker database, after polling the MySQL database, show name and e-mail as read-only; and then show the other fields as editable? i.e. if I make a change to the MySQL database, can I get it to show up in FM? [more inside]
posted by mark7570 on Sep 30, 2005 - 2 answers

techie SQL dupe problem

Any SQL gurus out there? I'm stuck... [more inside]
posted by derbs on Aug 12, 2005 - 13 answers


I'm playing (oracle) DBA for a day over the next two weeks and need to create public synonyms for all tables in a schema. How would I go about doing so? [more inside]
posted by furtive on Jul 27, 2005 - 7 answers

Best Book/Site for improving MS SQL Skills?

I currently have a very low level of SQL knowledge (I can construct simple queries for multiple tables, but I start to fall apart on the difference between inner and outer joins). I need to learn to create multiple join SQL queries and Dynamic SQL/Stored Procedures on MS SQL Server 2000 in a short period of time. I'd also like to learn to use MS Query Analyzer more efficiently. Is there one book or online resource that is best for this? Additionally, are there alternatives to using MS Query Analyzer, or is that really *the* tool? [more inside]
posted by de void on Jul 12, 2005 - 12 answers

Learning JAVA

I would like to start teaching myself JAVA and SQL but I'm not sure where to start in terms of what I need on my computer. [more inside]
posted by archimago on Mar 17, 2005 - 25 answers

BBEdit equivalency?

On the Mac, if I need to munge text in extremis, I prefer to use BBEdit. Recently, on the PC, I am finding myself in need of a text editor which is similar to BBEdit. I will use it both for coding and for text-cleaning. I prefer freeware and shareware but that's by no means the deciding factor. Which programs should I check out? Which should I avoid? [more inside]
posted by mwhybark on Mar 16, 2005 - 21 answers

Quick SQL Primers

After a year of employment, my boss is suddenly asking me to use my skills in SQL. It has been a year since I used them, and I need to brush up. [more inside]
posted by veronitron on Mar 16, 2005 - 8 answers

SQL 2000 Monitoring

I am trying to implement SQL mail fonctionnality for monitoring purpose under win2k / sql2k, only problem is to be configurer properly it must first obtain its parameter from Microsoft Mail API (MAPI) thru an already configured mail account, these are production servers and i don't feel too good about installing Outlook or Outlook express just to get an account configured so i can use this fonctionnnality. is there a way around this ? I am aware of several monitoring solution offered by third parties and i accept proposition (please no astroturfin') but I want to get that build in feature to work first.. anyone ? Thanks Selfsck
posted by selfsck on Mar 15, 2005 - 4 answers

Why won't SBS 2003 decrypt my sql scripts?

I am having a problem with our account app / server; I need to apply a hot fix to the sql db and the files are encrypted. When trying to decrypt the file, I get varied error messages. Any MCSE / encryption Guru's in the house? [more inside]
posted by AllesKlar on Mar 11, 2005 - 1 answer


myPHPadmin : I'm trying to get it to run an line of MySQL and it's complaining. Anyone got any thoughts? [MI] [more inside]
posted by twine42 on Nov 4, 2004 - 8 answers


mysqlfilter: I'm in the midst of installing phpwiki on OS X panther and, because I am following the steps drone-like and have no idea what I am doing. . . [more inside]
posted by mecran01 on Sep 13, 2004 - 8 answers

Decimal values in DB2

[DB2/SQLFilter] How do I cast a value of type DECIMAL(19,4) to a VARCHAR so that it has no leading zeroes, and only two digits after the decimal point? CHAR(DECIMAL( x(19,2) )) produces leading zeroes.
posted by Space Coyote on Sep 10, 2004 - 2 answers

SQL: Numbering rows in a temporary column?

SQL Filter: is there any way when making a query to create a temporary column that assigns each row in the result set an ordinal number? This is for when you not only want to count the number of items in a result set (ie, there are 50 items), you also want them numbered 1-50 or whatever. [more inside]
posted by wildblueyonder on Jul 19, 2004 - 8 answers

SQL Injection Security Issues

SQL injection security under php/MySQL. What specific issues do I need to deal with? [more inside] [more inside]
posted by y6y6y6 on Apr 28, 2004 - 17 answers

How can I replace every occurrence of a drive letter with a different drive letter in a table in an Acess database?

Say I have a database DATA.MDB
Inside DATA.MDB there is a table called ImageTable.
In this table is a field named fimageOriginalFilePath. There are aprox 4000 entries.
Each entry holds an absolute path to a directory on the C drive. For example C:\pictures\10131009
I want to automatically replace the first character of each entry with the letter F. So that each path points to the F drive.
Can it be done? Can it be done without MS Access? Can it be done by a person with no programing skills, knowledge of databases, or understanding of SQL queries and the like? If so, how? Thank you all. [more inside]
posted by Grod on Apr 17, 2004 - 14 answers

Page: 1 2 3 4 5 6