252 posts tagged with sql.
Displaying 151 through 200 of 252. Subscribe:

SQL CTE Question

I need help with a SQL CTE which works in SQL 2005 but doesn't in Business Objects. [more inside]
posted by onhazier on Apr 18, 2008 - 1 answer

SQL and mail merge help needed in Access 2007

I have an Access 2007 database with client information and I need to make it do two relatively simple tasks. [more inside]
posted by desjardins on Apr 11, 2008 - 6 answers

Synchronize databases....3...2...1... NOW!

What's the best way to keep data one way synchronized between an internal Mircosoft SQL Server database and a web facing mySQL database? [more inside]
posted by advicepig on Apr 3, 2008 - 9 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

Access My A**

Why isn't a query in Access returning the correct data compared to the equivalent query in SQL Server. More inside. [more inside]
posted by zackola on Mar 31, 2008 - 11 answers

It keeps growing and growing and growing...

Help me understand MSSQL logs... At least enough to do what I need to do. [more inside]
posted by eas98 on Mar 28, 2008 - 1 answer

mysql query help please

MySQL question: Given a table with a datetime column and several additional columns which may or may not be null, is there an easy way to select the most recent previous non-null value of each column given a specific date? [more inside]
posted by Nothing on Mar 13, 2008 - 10 answers

Restore humpty_SQLdumpty?

Through a series of dumb (though possibly dumb-lucky) mistakes and mysterious errors followed by disk failure, I am piecing a SQL (2005) server back together from not exactly optimal ingredients. I need help. [more inside]
posted by Lyn Never on Mar 2, 2008 - 1 answer

How to count the number of times a string appears in a database field.

SQL Filter: What query can I use to count the number of times a word appears in a text field? [more inside]
posted by Wild_Eep on Feb 21, 2008 - 6 answers


How does one get their head around OLAP? [more inside]
posted by SirStan on Feb 10, 2008 - 4 answers

How is Facebook doing its queries?

How does Facebook handle or simplify the presumably complicated DB queries involved so that me loading my page doesn't bring it to its knees? [more inside]
posted by bonaldi on Feb 4, 2008 - 27 answers

SQL/DBMS ninjas please help! How can I replicate my current abilities at a new company from scratch?

Some colleagues and I will soon be leaving our current employer and starting a new company. How can I best replicate our current relational database/SQL abilities from scratch? [more inside]
posted by raz5 on Jan 23, 2008 - 11 answers

Best DBA certification?

What DBA certification should I pursue? MS, Oracle, something else? [more inside]
posted by davar on Jan 15, 2008 - 3 answers

Extremely simple SQL, Access, .ASP help.

How can a fool make a table in an Access database reference another table, using SQL and ASP? [more inside]
posted by dirtdirt on Jan 11, 2008 - 10 answers

how to become a genius application developer overnight!

Second-Day-on-the-Job Panic: How can I get my mostly-self-taught, LAMP-loving self to be more confident and capable with developing corporate/enterprise applications? [more inside]
posted by logic vs love on Jan 8, 2008 - 11 answers

Cancel a SQL Server Query

Please help me understand what happens when I click the cancel query button in SQL Server Management Studio. [more inside]
posted by smithygreg on Nov 29, 2007 - 3 answers

Tricky SQL for a simple function

Been banging my head against the wall on this the whole day. I need a way to select & sort data from a single MySQL table, but it's a little bit more complicated that it seems. [more inside]
posted by arrowhead on Nov 23, 2007 - 14 answers

SQL help

Please help me with a giant SQL-ish mess. I need a better solution than MS Access for dealing with millions of records and building queries. [more inside]
posted by loquax on Nov 19, 2007 - 12 answers

It's not you - my CPU says yes, but my database say no

How many database reads/writes are okay per web page view? Also, what is better, big tables or lots of join tables? [more inside]
posted by markovich on Nov 16, 2007 - 13 answers

All months, now.

Sum of data for all months, including months with no rows, in MySQL? [more inside]
posted by tmcw on Nov 15, 2007 - 7 answers

Right Place, Wrong Time

I have a set of dates/times in a MS SQL table that lack a timezone offset. I want to convert them to UTC, but I have to be mindful of Daylight Time for each of these dates (they're in the future). How can I convert them to UTC correctly? [more inside]
posted by dw on Nov 13, 2007 - 3 answers

ColdFusion SQL Injection Attack Terror

ColdFusion MX 7 and Microsoft SQL Server 2005. There's a lot of unvalidated parameters in our CFQUERYs. But, I'm told that putting the parameters in single-quotes will prevent injection attacks, because of the way ColdFusion escapes single-quotes. Is this foolproof, or do I have to go in and validate everything with CFQUERYPARAM tags?
posted by East Manitoba Regional Junior Kabaddi Champion '94 on Oct 22, 2007 - 3 answers

Could I design databases for a living?

Can I, should I, make a career change into database design? [more inside]
posted by argybarg on Sep 25, 2007 - 16 answers

an asp stung my database

Where can I get some noob information on how to read/write simple database tables with ASP? [more inside]
posted by yonation on Sep 25, 2007 - 4 answers

SQL Server Find and Replace Script

SQL SERVER - I'm not a SQL script guy, but I've got a SQL script problem. [more inside]
posted by jpoulos on Sep 17, 2007 - 6 answers

What is the prefered way to represent status changes over time in a relational database?

What is the prefered way to represent status changes over time in a relational database? [more inside]
posted by kimota on Sep 4, 2007 - 17 answers

Need SQL help to fetch data, with some tricky conditions

From two MySQL tables, I need to fetch a list of customers who DOES NOT have an invoice issued to them within the past 2 months. More details about the table structures inside. [more inside]
posted by arrowhead on Sep 3, 2007 - 10 answers

SQL Combinations

Any SQL / math ninja's on the green fancy a quick challenge..? So I've got this table containing number pairs, right, and I need to compute all the possible combinations. [more inside]
posted by whoojemaflip on Aug 15, 2007 - 25 answers

This sql query should be simple...

I'm trying to merge simple contact data from a bunch of single tables into one big text (csv) dump. The problem is that not all fields are present for each user. e.g. one user may be missing an email. Because of the missing field, my current (big and ugly) sql query will not return all the rows. [more inside]
posted by kamelhoecker on Aug 2, 2007 - 13 answers

Help with creating a SQL query with optional multi-value parameters

Looking for some guidance in building an "advanced search" query using XML and optional multi-value parameters. [more inside]
posted by mkultra on Jun 26, 2007 - 6 answers

Can FileMaker read from SQL?

Can FileMaker read from a SQL database? I've talked to (SQL) developers and they can't find a way to do it. [more inside]
posted by mark7570 on Jun 21, 2007 - 8 answers

SQL to update multi-values?

Need some help with MS SQL text replacement. [more inside]
posted by Four Flavors on Jun 18, 2007 - 15 answers

How to query SQL with Ruby?

What's the best way (using the internet, and/or books) to learn how to query SQL databases with Ruby?
posted by anonymous on Jun 10, 2007 - 3 answers

Need help developing a small relational db

Help me properly set up a very small relational db. This is a teensy bit over my head, so mainly I want to establish that I'm not going terribly wrong before I get too far into this. [more inside]
posted by desjardins on Jun 6, 2007 - 5 answers

SQL query to get unique addresses from a list.

Access SQL Query - I have multiple individuals each with an address. I need to make mailing labels, but if two or more people share an address, I would only like one label. [more inside]
posted by odinsdream on Apr 18, 2007 - 9 answers

SQLFilter: Simple Data Import Question

How do I merge an external text file into a SQL table (MS SQL Server)? [more inside]
posted by joshjs on Apr 17, 2007 - 6 answers

Seeking SQL Tool

What free tool from Microsoft or otherwise will let me peruse and edit a SQL Server 2005 database? [more inside]
posted by iconjack on Apr 10, 2007 - 10 answers

bartering for knowledge not pigs

Wheres the best place to learn things like how to migrate a messy pile of microsoft access databases to sql? Normally when learning new I use books, online sources and forums, and good old fashioned trial and error, but its a slow process for some of us. As its easier learning from someone with experience in the field. are there any sites that go some way to addressing this teacher / student system online, aside from the usual forum formats, i was thinking of some sort of bartering system, but for knowledge not pigs?
posted by ugrndhg on Feb 17, 2007 - 3 answers

My Kingdom for a DBA

Databasefilter: I'm a self-taught 'DBA' (I use quotes so as to not offend those who have this knowledge through a paid education). I'm having an efficiency problem with a few of my tables, and I thought maybe one or two of you could help. [more inside]
posted by thanotopsis on Jan 31, 2007 - 20 answers

How do to update rows without a cursor?

How do I update rows in a table in a SQL*Server 2005 database with data from another row in the same table? [more inside]
posted by apark on Jan 24, 2007 - 5 answers

Questions On Repository Pollution, Website Software Releases, SQL Patching, and Derivitives Thereof.

I'm doing some consulting as a release manager on a webapp. I recently got the programmers to start using subversion (by turning off their access to their old development areas...) and their own sandboxes, and releases go more smoothly than ever. But I'm getting configuration files that have to be individualized for environments leaking into the trunk, and I want to get my release process down to "type command. hit enter." What to do? [more inside]
posted by SpecialK on Jan 20, 2007 - 6 answers

Selecting the MODE of a group of data in Microsoft Access

Microsoft Access. An SQL "GROUP BY" query. How do I generate the mode of the values that it's grouping, when I want averages in other multiple fields? [more inside]
posted by Jimbob on Dec 13, 2006 - 3 answers

MySQL query query

Help with troublesome MySQL query? [more inside]
posted by cdavis on Dec 6, 2006 - 8 answers

How to get mySQL to ignore "A, An, & The" when presenting alphabetized book titles

mySQLfilter: How can I ignore "A, An, & The" at the beginning of book titles when sorting results alphabetically by title? [more inside]
posted by Wild_Eep on Dec 5, 2006 - 10 answers

How do I get the record with the most current date by a key field?

SQL question: How do I get the record with the most current date for each person's ID? Better explanation inside. [more inside]
posted by DakotaPaul on Nov 21, 2006 - 14 answers

Know any dead trees that can teach me about php and MySQL?

Recommendations for a book to teach myself php and MySQL? [more inside]
posted by dripdripdrop on Nov 20, 2006 - 8 answers

query criteria from a table?

Access SQL: How to use a short list of numbers stored as text in a table cell as the criteria for a query? [more inside]
posted by Zetetics on Nov 6, 2006 - 9 answers

MySQL import question

What is the easiest way to get this data into a MySQL database? [more inside]
posted by rlef98 on Nov 2, 2006 - 19 answers

SQLServer Express remote connection problems

SQLServer Express remote connection problems. Please hope me! [more inside]
posted by derbs on Nov 2, 2006 - 9 answers

Why no worky?

SQLServerFilter: Quick question about views and using "NOT IN". [more inside]
posted by SoulOnIce on Oct 21, 2006 - 4 answers

Page: 1 2 3 4 5 6