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

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

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

Help me get a Microsoft DB certification

I want to get a Microsoft Database certification so I can become a database developer (I know some basic SQL using Postgres but I'd like to know more and get a certification). What's the best way to do this using a book instead of taking a class? [more inside]
posted by Mrs. Pterodactyl on Jul 15, 2014 - 3 answers

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

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

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

Best DBA certification?

What DBA certification should I pursue? MS, Oracle, something else? [more inside]
posted by davar on Jan 15, 2008 - 3 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

A query connundrum.

Attention SQL gurus. This has me completely stumped. How can I find the index (position) of a row in a table without querying the entire set? [more inside]
posted by Civil_Disobedient on Sep 3, 2006 - 12 answers

Data Overload, How Do I Manage?

How can I manage my databases that are exploding in size? Can I run SQL Server on my laptop? [more inside]
posted by benjh on Dec 9, 2005 - 9 answers

How can I replace every occurrence of a drive letter with a different drive letter in a table in an Acess database?

Say I have a database DATA.MDB
Inside DATA.MDB there is a table called ImageTable.
In this table is a field named fimageOriginalFilePath. There are aprox 4000 entries.
Each entry holds an absolute path to a directory on the C drive. For example C:\pictures\10131009
I want to automatically replace the first character of each entry with the letter F. So that each path points to the F drive.
Can it be done? Can it be done without MS Access? Can it be done by a person with no programing skills, knowledge of databases, or understanding of SQL queries and the like? If so, how? Thank you all. [more inside]
posted by Grod on Apr 17, 2004 - 14 answers

Page: 1