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

44 posts tagged with sql and resolved. (View popular tags)
Displaying 1 through 44 of 44. Subscribe:

Best resources for learning SQL for database newbies

I am making a transition from an Excel-based reporting analyst to a database-oriented role in which SQL will be the primary necessary skill. I have next to zero database experience. I'm looking for resources that would be effective at teaching me what I need to learn. More within… [more inside]
posted by JimBJ9 on Aug 20, 2014 - 15 answers

How can I summarize quantities by ranges in Access 2010?

I am trying to summarize a table of thousands of values into simple year ranges. It should be simple. So basically, there is a table that looks something like this: PIPE_PLR_Y MILES 1912 0.06 1914 0.48 1930 1.43 1942 1.32 1929 0.85 1925 2.00 1914 0.95 1929 0.42 ... The table has many, many values between about 1900 and today. I would like to make a table like this: Year_Range MILES 1900 - 1909 23.6 1910 - 1919 64.3 1920 - 1929 73.1 ... Again, I'm using Access 2010. Any help would be massively appreciated.
posted by rybreadmed on Aug 1, 2014 - 4 answers

Merging Duplicate rows in Excel or Access

I have a table with duplicate values in one column. Some of the other columns have a value, some don't. I want to have one row for each record, with all of the colums values in one row (NOT CONCATENATED). I can use Excel or Access for this. [more inside]
posted by desjardins on Jun 19, 2014 - 18 answers

How can I do... anything? with this JSON file?

So, I've found the source of all the data I need in my database, but it is in a JSON file. MSSQL cannot read JSON and the entire internet seems devoted to telling me how brilliant and easy JSON is and then giving me 20 pages of code to deal with it. I don't have time to implement a JSON parse in C or anything like that. I just need to put this perfectly simple bit of data into a database. Can you help? [more inside]
posted by Just this guy, y'know on Jun 27, 2013 - 11 answers

MS Access Combo Box Fields behaving strangely.

I'm putting together an Access database (woe is me), which includes some "multiple choice" fields, that contain a defined list of options. I've got some code that puts together a query, and generates a report. The way these fields are displayed in this report is inconsistent, and I'm trying to figure out why. [more inside]
posted by Jimbob on Jun 9, 2013 - 1 answer

How can I merge only the relevant results in SQL

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

model.where(:name => "string) INTERNAL ERROR!!! No attribute exists!

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

Help this Mac user learn PC software for job hunt

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

SQL Query to find unique combinations

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

Better Living Through Queries

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

SQL: How do I increment an alphanumeric field by + 1?

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

How do I move this database online?

What's the easiest, most secure way to move this SQL database and its browser-based front end online? [more inside]
posted by infinitywaltz on Jan 18, 2012 - 17 answers

Mac file manipulation for power users?

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

Learning Oracle and SQL

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

What should I charge to build a mobile app?

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

SELECT TOP 10 blogs FROM blagosphere WHERE type = 'SQL Server'

Best blogs for SQL Server? [more inside]
posted by bfranklin on Jul 1, 2011 - 5 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 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 / 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

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

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

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

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

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

Oracle Views: Are calculated columns always evaluated even when they are not considered in a query?

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

MS Access / SQL help please?

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

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

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

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

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

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

Page: 1