I have a table in my database.
It has a bunch of 4 digit codes representing a location (as well as other data).
The problem is that some of these locations need to be replaced with an updated code. I have a second table with the substitutions that need to be made, but it is only a small minority of codes that need updating.
How do I format my SQL statement to produce me a list of all records, with the new location code if it has a new code and the old code if there is no update needed.
[more inside]
posted by Just this guy, y'know
on Feb 21, 2013 -
12 answers
In Rails, I'm using a model to represent a database view. I'm getting an error when I try to search on an attribute. (
gist).
[more inside]
posted by czytm
on Dec 17, 2012 -
8 answers
How can I improve my computer skills for job hunt when I use a Mac and the software is for PC?
[more inside]
posted by hrj
on Aug 9, 2012 -
24 answers
SQLNoobFilter: I am trying to find all unique combinations on a table. Does my simple query do the trick or is there more to it?
[more inside]
posted by amazingstill
on Mar 14, 2012 -
5 answers
Help me help myself- Please recommend books or websites that will help me to better understand SQL.
[more inside]
posted by bluejayway
on Mar 1, 2012 -
11 answers
I'm a bit of a SQL novice but learning at a decent clip. I'm using SQL (Aqua Data Studio, if that matters to you) to update a couple of fields in an Oracle database table. I'd like to do this across a range of one of the fields. One field is a numeric field (trans_id - a transaction id) that I need to increase by 1 -- I think have that part licked. The next field is alphanumeric (calendar_name - represents the name of a week) and also needs to be incremented by one. The doozy (for me) is the alphanumeric field. Who's the guru?
[more inside]
posted by brokeaspoke
on Feb 4, 2012 -
11 answers
Is there a SQL-like way to interact with the Mac filesystem? Failing that, what's better than the Finder for batch copies/moves/deletions?
[more inside]
posted by ripley_
on Dec 22, 2011 -
12 answers
Hey all. I need to learn the basic principles of SQL and Oracle databases. I'm looking for web resources and books. Got any favorites? What's out there?
Thanks in advance.
posted by Stagger Lee
on Dec 5, 2011 -
12 answers
How much should I charge for developing a mobile/web app? And, should I charge hourly, weekly, or ask for a fulltime position?
[more inside]
posted by Earl the Polliwog
on Sep 20, 2011 -
8 answers
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
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
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
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
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 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 do I import a SQL dump of an old MovableType install into Wordpress?
[more inside]
posted by deezil
on Feb 1, 2010 -
3 answers
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
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
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
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
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
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
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
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
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
