246 posts tagged with sql.
Displaying 51 through 100 of 246. Subscribe:

SQL Alter statement

SQL SERVER: Need help creating new column in a table with unformatted SSN. [more inside]
posted by fozzie33 on Apr 6, 2011 - 6 answers

[hɛlp mi si junikod ɪn maɪ deɪtəbeɪs, ɔr maɪ dætəbeɪs ivɛn]

I'm using Navicat Lite to connect to my Oracle research database (Mac OSX). Much of my data is in IPA (International Phonetic Alphabet). These are unicode symbols. Is there a way to display the IPA/Unicode in Navicat? Or some other GUI? Or is there some addon/code/plugin/whatever that will show me the symbols? [more inside]
posted by iamkimiam on Mar 8, 2011 - 2 answers

Crystal Reports

Help with using Crystal Reports to report on an Oracle database [more inside]
posted by toenail on Feb 15, 2011 - 3 answers

SQL Query help in Access 2000

I have a MS Access 2000 table with approx 300,000 records. I need help with constructing a query. [more inside]
posted by selton on Feb 13, 2011 - 3 answers

How do I collect dictionary definitions for ~350 words to put into a database?

I have a list of about 350 words that I'm putting into a database that I'm building from scratch. For each word in the list, I'd like to include its American English dictionary definition (preferably American Heritage Dictionary), UrbanDictionary entry, and Wikipedia page link (I realize that entries may not exist for some columns for many of these words). Is there some way to streamline or data-mine this process, so I don't have to look up each word individually in 3 separate sources x350+, not to mention all the copying and pasting? [more inside]
posted by iamkimiam on Feb 11, 2011 - 10 answers

Database diagram -> sql

Help me find a program (Windows / preferably free) that draws database diagrams and then creates the relevant SQL... [more inside]
posted by sodium lights the horizon on Jan 26, 2011 - 5 answers

Need help with SQL statement

I need to create a query in Access that shows the percentage of a total. I can't grasp the SQL statement I need. [more inside]
posted by desjardins on Jan 26, 2011 - 7 answers

How do I append rows to a table in Access from two related tables?

How do I append rows to a table in Access from two related tables? [more inside]
posted by desjardins on Dec 27, 2010 - 3 answers

Help me choose barebones Windows hosting

What is a good bare-bones hosting for ASP.NET / IIS 7 / SQL Server? This is for someone who's just messing around. [more inside]
posted by xiaolongbao on Dec 23, 2010 - 4 answers

Yet another SQL question

How can I change this SQL query? [more inside]
posted by jfricke on Dec 20, 2010 - 6 answers

Need help formatting an Access report from a query and SQL help

I'm having trouble formatting a report in Access that ONLY shows checkboxes that are not checked. I probably need some help on the SQL front. [more inside]
posted by desjardins on Dec 20, 2010 - 4 answers

I haven't needed SQL this ugly before

What SQL magic do I need to turn one column into several? [more inside]
posted by flabdablet on Dec 19, 2010 - 14 answers

How can I select this in SQL?

SQLfilter: Help me solve a problem that's driving me crazy. I'm working with someone else's data, and I've got a seemingly insurmountable select problem that no amount of googling has helped me with so far. [more inside]
posted by Mr. Bad Example on Dec 17, 2010 - 11 answers

SQL learning exercises

Suggestions for real-life(ish) SQL exercises? [more inside]
posted by Tehhund on Nov 9, 2010 - 11 answers

SQL / Reporting Help Please

I'm looking for help with either SQL or with MS Reporting Services; not sure which, to be honest. I have a table of people (userID, username), a table of vegetable(s) each person bought (userID, vegatableID), and a table of fruit(s) each person bought (userID, fruitID). I'm trying to develop a report that has column A = name, column B = vegetables bought, and column C = fruits bought; I'm running into problems. [more inside]
posted by inigo2 on Oct 27, 2010 - 14 answers

CALL ask_metafilter();

I think MySQL procedures and temporary tables are the bee's knees - am I Doing It Wrong? [more inside]
posted by Dr Dracator on Oct 17, 2010 - 12 answers

Best front ends for SQL databases?

What are the current best options for providing a front end for users to search and enter data to a SQL database? [more inside]
posted by tabulem on Oct 15, 2010 - 8 answers

How to export data from a SQL database into a CSV file and add some new data?

How can I export data from a SQL database into a CSV file and add a new column at the same time? [more inside]
posted by jfricke on Sep 8, 2010 - 8 answers

SQL JOINs are driving me crazy

Help me dig myself out of an SQL hole involving crazy multiple joins. [more inside]
posted by le morte de bea arthur on Sep 1, 2010 - 14 answers

How to manually increment an integer value in a SQL Server 2005 database table?

How would you handle "manually" incrementing the value of this integer field in SQL Server 2005? [more inside]
posted by trunk muffins on Aug 3, 2010 - 7 answers

Recommend user-to-user web site with advice on Lyris ListManager?

Please recommend a user-to-user web site with technical advice on Lyris ListManager. One of our employees accidentally deleted ~6,000 e-mail accounts from their Lyris list. We're a non-profit, and our support contract has ended. [more inside]
posted by jtherkel on Jul 20, 2010 - 3 answers

How do I NoSQL?

My bread and butter is and always has been data stored in relational databases. I keep seeing a lot of material on key-value storage (also known as the NoSQL movement) but haven't had as much success finding resources on how to move from relational to non-relational. Any suggestions? [more inside]
posted by Deathalicious on Jul 10, 2010 - 10 answers

Effing Access combo boxes, how do they work?

I'm trying to make a combo box populate properly in an MS Access form (oh, the pain), and I need some help. [more inside]
posted by middleclasstool on Jul 8, 2010 - 2 answers

How do I create a custom shipping workflow?

Ecommerce, Shipping, Programming: I am setting up a warehouse for my burgeoning ecommerce business and am designing custom coded shipping workflow. I am also shipping orders from this warehouse for two or three other online stores in different shopping cart platforms, and need to streamline the orders together into an efficient packing and shipping operation. Here's an example shipping setup that I'm moving towards. Please refer me to resources or people to hire (more detail below). [more inside]
posted by Merlin144 on Jun 26, 2010 - 2 answers

SQL on demand?

Is there somewhere you can go to upload some tables (or import CSV files) and run SQL commands on it? [more inside]
posted by metametababe on Jun 7, 2010 - 8 answers

Help me build a solid web design/development foundation from scratch

I want to create a simple but dynamic Bible-reading web app from the ground up. I have very little web design and development experience. Where do I begin? [more inside]
posted by joshrholloway on Apr 22, 2010 - 4 answers

Is it OK if I pretend SQL is just a funny dialect of Haskell?

I want to use nested SELECT statements to make my SQL procedure more readable. Is this a bad idea from a performance point of view? [more inside]
posted by Dr Dracator on Apr 22, 2010 - 7 answers

Teaching MySQL to Total Beginners?

I've just been put in charge of teaching two executives in my company how to use MySQL. Oh dear God, please help me! [more inside]
posted by fogster on Apr 16, 2010 - 14 answers

SQL help, LIKE %(set of possible values)%

SQL problem. I need to search one table based on the results of a search on another table. The trick? The field I'm comparing on the two tables will not be exactly equal, one table will have a field with single 'word', the other table will have a field with have a string of multiple 'words'. Look inside for an example. [more inside]
posted by thisisnotbruce on Apr 14, 2010 - 13 answers

How to compile WordPress author stats from a database

Where to find WordPress post view stats. [more inside]
posted by thelastenglishmajor on Mar 25, 2010 - 6 answers

SELECT training FROM internet WHERE user = 'stymied';

I find myself employed (yay!) in a position that requires SQL knowledge that I don't have, and can't quite wrap my head around (boo!). I need practical training/guides to remedy this. [more inside]
posted by sysinfo on Mar 20, 2010 - 12 answers

I want to be a very spatial snowflake

I'm trying to learn the fundamentals of GIS query concepts. Most books and tutorials are all about pretty maps. I would rather understand the SQL. Resources, advice, forums all appreciated. [more inside]
posted by scruss on Mar 9, 2010 - 2 answers

Beginner resources for ASP.NET and SQL?

So the company I've started working for has asked me to step into a website development role, and while I've got some limited tech knowledge, I need to find some resources to start really digging into ASP.NET and SQL. [more inside]
posted by Mali on Mar 2, 2010 - 5 answers

Simple SQL Script Won't Run

Looking for help with this SQL script running in Access 2007. [more inside]
posted by thebreaks on Feb 21, 2010 - 4 answers

SQL - Accurately show how many rows an UPDATE statement is going to affect before execution.

SQL - How to get an accurate count of the rows potentially affected by an UPDATE statement, or best practices for performing updates? [more inside]
posted by odinsdream on Feb 9, 2010 - 18 answers

Duplex Duplicity

How can I pull or modify a series of records into a PDF report from SQL Server Reporting Services to make them print with proper duplexing? [more inside]
posted by Mr. Anthropomorphism on Feb 4, 2010 - 1 answer

SQL QUERY ow to achieve it? (short paths)

I am trying to create a SQL Query for Access2003 that will basically show me by employee ALL potential classes they can take and sorted together with the most recent date of a class they may have taken. Basically this is used as a worksheet to plan training for the people who may have some of the required training but not others. (see inside [more inside]
posted by wildpetals on Feb 2, 2010 - 3 answers

It may have not been my best writing, but I want it back all the same...

How do I import a SQL dump of an old MovableType install into Wordpress? [more inside]
posted by deezil on Feb 1, 2010 - 3 answers

ASP .NET based CMS versus Drupal

Trying to make the case against Drupal and find a ASP .NET CMS solution. [more inside]
posted by wcfields on Jan 29, 2010 - 20 answers

What interesting statistical information can I dig out of this medical billing data?

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

2 Fields, 1 Query

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

Need recs for IT training in Seattle.

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 - 3 answers

MS SQL please speed up so i dont cry

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

Finding rows that don't exist in an SQL Server 2005 table

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

How does WITH work in MS SQL Server?

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 Challenge

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

(MS)SQL Query within a Query

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

SQL query problem

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

Help ADDS Synchronize users to SQL

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

How can I get the result of mysql_fetch_array to skip a row?

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

Page: 1 2 3 4 5