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

Best practices for MSSQL off-site backup?

What's the smartest way to keep regular backups of Microsoft SQL Server databases stored remotely? [more inside]
posted by odinsdream on Aug 6, 2011 - 2 answers

How do I get data from multiple other entries in a database?

SQL help: I'm very new to SQL, and need to update one field with the maximum value of all entries in another field selected based on a shared value in a third field. [more inside]
posted by agentofselection on Jul 17, 2011 - 12 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

Help me write this SQL job

What's the best way to write this SQL job? I have a table with browser session information collected. I want to clear this table and store the information in another table. [more inside]
posted by zephyr_words on May 31, 2011 - 7 answers

Looking for a good book to help me brush up on my database skills

I've been working with SQL and RDBMSes for a number of years, but my most recent job involved no DB work at all. Understandably, I'm a bit rusty. So I'd like to get a good book to help me brush up, and also to learn a bit more about RDBMS technology. What would you recommend? [more inside]
posted by Sloop John B on May 3, 2011 - 3 answers

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

Page: 1 2 3 4 5 6