Join 3,363 readers in helping fund MetaFilter (Hide)

240 posts tagged with sql. (View popular tags)
Displaying 201 through 240 of 240. Subscribe:

Related tags:
+ (76)
+ (42)
+ (42)
+ (34)
+ (27)
+ (16)
+ (16)
+ (16)
+ (12)
+ (12)
+ (9)
+ (9)
+ (8)
+ (8)
+ (7)
+ (6)
+ (6)
+ (5)
+ (5)
+ (5)
+ (5)
+ (5)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)
+ (4)


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

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

SELECT * FROM USERS WHERE CLUE > 0

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

PhProblems

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

MySQL

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

I need to learn SQR

Anyone know anything about SQR? [More Inside] [more inside]
posted by bondcliff on Mar 22, 2004 - 3 answers

How can I use ColdFusion 5 to insert a date and time into a SQL Server 2000 datetime field?

How can I use ColdFusion 5 to insert a date and time into a SQL Server 2000 datetime field? [more inside] [more inside]
posted by kirkaracha on Jan 5, 2004 - 2 answers

Page: 1 2 3 4 5