The tag has no usage guidance.

learn more… | top users | synonyms

26
votes
1answer
13k views

Does an anchor tag come before the query string or after?

I am unclear if an anchor tag should come before a query string or after. http://www.domain.com/search?query=hello#name or http://www.domain.com/search#name?query=hello Or does it matter?
24
votes
15answers
22k views

Querying a CSV file

Does anyone know of a simple tool that will open up a CSV file and let you do basic, SQLesque queries on it? Like a graphical tool of sorts, one that is easy to use. I know I could write a small ...
16
votes
2answers
100k views

Run an SQL Query With a Parameter from Excel 2007

I have a query in an Excel table. I followed this to do it. But how can I add a parameter from a cell into my query? I am looking for a way to do this: select * from dbo.Customers where CustomerID ...
4
votes
2answers
5k views

Pass parameter from Excel to Access query

I have a Access (2010 but I've also tried Office 2003) database with a lot of tables, forms and nested queries which rely on data entered in a form, e.g. WHERE query1.year=[Forms]![Form1]![Text0];. I ...
4
votes
1answer
43 views

How to combine the output of two querys in MYSQL when they have non-compatible conditions

I'm looking for some assistance in adding together the output of the two following queries. They have two incompatible conditions so I'm struggling to combine them in the one query. Total Revenue ...
3
votes
2answers
2k views

Foobar2000: any way to query whether a song is in a specific playlist?

In Foobar2000, I would like to make an autoplaylist that only shows songs that are not currently in another specific (manual) playlist. Is there any way to query for this? I imagine the query to ...
3
votes
3answers
48k views

Merge multiple columns into one via a query in an access database

i need to write a query that combines multiple columns of text. my database is a database of wallpapers on my computer (i use john's background switcher), so i can easily find them and have them ...
2
votes
1answer
12k views

Query parameters in an external connection to sql server

I want to do exactly this: http://dailydoseofexcel.com/archives/2004/12/13/parameters-in-excel-external-data-queries/ but I want to do it in Excel 2010 and also I am querying SQL Server instead of MS ...
2
votes
1answer
6k views

How do you create a SQL query in Excel 2007 with a dynamic date range?

I am trying to create a reporting spreadsheet that can print reports for a given time period. The query below works, but when I try to use a ? parameter in place of the date, I get an error after ...
2
votes
3answers
3k views

Querying against Active Directory

I'm the "script guy" at my work, which is a blessing and a curse... I've been tasked with generating a script of: Can you create a script to pull all users that have a proxy address that is not ...
2
votes
1answer
74 views

Convert DateTime with Decimal Time Longer Than 3 digits?

I'm trying to import some data from CSV into MS SQL 2008 Server. I'm using PowerShell's Invoke-SQL, and an SQL script that utilizes BULK INSERT. CSV fields get imported as VarChars and I'm trying to ...
2
votes
2answers
14k views

Pass a cell contents as a parameter to an excel query in Excel 2007

I have tried really hard to solve this issue but I think I am going to need a little help. I can program in different languages but I don't have any experience with Excel, VBA or the queries you can ...
2
votes
1answer
1k views

How do I get Excel to run a query for each row in a spreadsheet?

Is there a way to run an MS Query for each row in a spreadsheet? For example, I have a sheet that looks like this: CustomerID 111 222 333 I have the customer's address in a database, and I'd like ...
2
votes
1answer
2k views

Embed microsoft query in excel with multiple parameters from spreadsheet

I am trying to embed a microsoft query within an excel spreadsheet, that passes several parameters from the spreadsheet to the query. I would like the microsoft excel query function to find a few ...
2
votes
2answers
505 views

Issues sending Latin accented characters (ã,õ,á,é,í,…) to a database table in PHP/MySQL

I am having problems making mydatabase table show Latin caracters. (ã,õ,á,é,í,…). I am using WAMP server with Apache 2.4.9 and MySQL 5.6.17. I have a simple form that I created in HTML and I have a ...
2
votes
0answers
43 views

foobar2000: query if specific files exist in track's directory

In my library there are files like .lrc files (Lyrics) or album art files (various .jpg files) next to the music files: I am trying to create a autoplaylist where I want to list tracks which have a ...
2
votes
0answers
52 views

How to paste multiple entries to a query?

How to do you paste multiple entries to a query in design view? I can only paste one value at a time, and I need to add multiple values. Is there a way of doing an Advanced Filter in Microsoft ...
2
votes
1answer
163 views

How to pick rows in MS SQL based on column values?

I want to pick SourceId & Currency based on Count value. Problem is within a set I've to ignore all data where Count = 0 if there is any value greater than 0 but if all the counts are 0 within a ...
2
votes
1answer
218 views

CSV filename bug concerning dots in Microsoft Query (via Office Excel 2013)?

After hours of struggling it looks like I've found a bug regarding csv file processing by Microsoft Query via Office Excel 2013. I'm trying to generate a Chart from csv data. Every hour a new record ...
2
votes
2answers
695 views

Matching similar records in a database with Group By

I have a database in which there are company names each matched with the company post code. However there are duplicates since the company names are written multiple ways, like this: Company Name ...
1
vote
1answer
416 views

Query dpkg for All Packages Installed/Removed from Default Image

Is there any way to query dpkg to tell what packages have been added/removed since the base install of a system? I am running Debian 5.
1
vote
1answer
11k views

Access Query for Positive Checkboxes

I have a table which contains personal information of our staff, at the end of the table there are checkboxes for general training (medical, military, health and safety) etc. Say for example i wanted ...
1
vote
1answer
3k views

Automating Access 2007 Queries (changing one criteria)

So, I have 6 queries and I want to run them all once at the end of each month. (I know a bit about SQL but they're simply built using Access's design view). So, in the next few days, perhaps I'll ...
1
vote
2answers
6k views

Access 2007 create report from query

Where is my Query??? I'm using Access 2007, until this version I would create a query then create a report based in that query, using create-blank report. If I use the report wizard it does give me ...
1
vote
1answer
127 views

How to simplify Excel/Google Sheets formula with redundant method calls?

I have an Excel (Well, technically Google Sheets) workbook containing product inventory warehouse storage information. I figured out how to construct queries so it grabs the needed information from ...
1
vote
2answers
520 views

Query for false values in Access not working

I'm trying to create a simple database to keep track of paperwork as it's turned in. In the form and table I've used yes/no check boxes, checking them when a paper is turned in. What I want to do is ...
1
vote
1answer
222 views

How to create a MS Access query to show a data in columns by criteria?

I have a little problem with MS Access 2013. I cannot figure out how to create a query to show needed data in one table. The data structure can be illustrated with the following: USERS ID Name 001 ...
1
vote
1answer
116 views

Configure DNS Rules for Hosts and Proxy?

I'm not sure if I'm approaching this problem correctly, so please correct me here. Suppose an organization runs its own DNS service. The organization wants the following: DNS queries by all hosts ...
1
vote
1answer
156 views

Filtering field on view - Lotus 8.5

I have one view with field that I called "Date". I can´t filter the results for one date... please help me.
1
vote
1answer
96 views

excel / open office - append an incrementing value to all non-unique fields

I have a large table of about 7500 store names. I need to search through those names and, if they are not unique, append an incrementing value, for example: store_1 store_2 etc. Anyone know how to ...
1
vote
1answer
807 views

Query data in Powerpoint

I would like to build an MS PowerPoint 2010 presentation where some of the displayed data would be queried from an external source (I am flexible - the simpler the better, I need to update that ...
1
vote
1answer
1k views

Where is a Web Query stored in an excel file?

I have a Web Query looking at a site for data, and it gets the table selection wrong. Viewing source of the linked to web page I am able to identify the correct table. In an Excel Web Query you are ...
1
vote
0answers
18 views

Excel 2013 Power Query

Does anyone know how to extract all Active Directory Users and show which ones are Users and which ones are just Contacts. I've extracted both Users and Contacts but they seem to show the same in ...
1
vote
1answer
29 views

MS SQL query which split to other table columns

I have two table: table1: |Manager | USER | +--------+------+ |John | Tom | |John | David| |John | Marry| |James | Henry| table2: Now is empty, but must be like: ...
1
vote
1answer
245 views

Microsoft Access 2013 - Search for one word in multiple columns at the same time

Is it possible to search in multiple columns for the same word and get every row (no matter in which column the word stands) as a result? For example: I have a database consisting of 5 columns and ...
1
vote
0answers
24 views

excel 2007 MS Query

I have created a spread sheet using MS query. I have added several columns to the rows of data so there can be some manually entered notes at the end of each row. The problem is when I refresh the ...
1
vote
0answers
40 views

Microsoft Access database worked before and now old records won't update

This code was working fine on Windows 2003 Server. Updated to Windows 2008 Server and now new records can be listed for update or delete but old records can only list record content, but can't be ...
1
vote
1answer
305 views

Is there a way to change the query a report uses in Libreoffice Base or better yet to select the query at the time a report is run?

I have a standard set of data that I always want out of a report, however it could be based on a query of any of the values. Is it possible to set it up so I double click on a report and it would let ...
1
vote
1answer
584 views

VB script or command line instruction to query a modem connected to my PC

Is there any vb script to query a modem that is connected to one of the ports of my machine?How can I query my modem from command prompt?
1
vote
1answer
192 views

Exporting an SC query result to Excel

I wrote an SC query to show all the services and their state and I can easily display it in a text file. What I want to do is list all this data directly to an Excel worksheet. How / is this ...
1
vote
0answers
388 views

Change date in a SQL query to reference a cell in Excel

I have the following code that returns the needed data into excel and manually changing the date will change the returned data; however, I'd like to reference a cell with a formula that will make the ...
1
vote
2answers
958 views

SQL Server Management Studio Express - include date/time in Results or Messages

In SQL Server Management Studio Express 2005 is it possible to output the date and time that a query completed in the Results or Messages windows? (without having to manually add a SELECT Getdate() ...
0
votes
3answers
779 views

Free Database Utilities / Tools for Mac OS X

If I were using Windows and wanted to use a database I would set up a WAMP server. What can I use for Mac OS X? I'm currently using SQLite via Mike's T Sqlite / Firefox addon for SQLite. I would ...
0
votes
1answer
13 views

Error when trying to SET field in MySQL

I am trying to set the field block, in the table h8cyw_users, to 1 where the email field in both tables are the same. I am using the following script: UPDATE UPDATE table1 SET block='1' WHERE email ...
0
votes
1answer
312 views

Query Execution Plan for MySQL

In Microsoft SQL Server you can see Execution Plans for queries to see how a query is executed, what joins take the most time and see any missing indexs now i want to do the same for MySQL scripts ...
0
votes
1answer
153 views

Does MS Access update the data on the clipboard from a query when the data in the database changes?

I was just debugging a macro in MS Access, and when it hit the breakpoint ran a query and I copied the data from it to the clipboard. Some of the values were null before stepping to the next step, ...
0
votes
3answers
940 views

TFS 2010 - Cannot query certain users

We seem to have an issue with out Team Foundation Server 2010 installation that gives an error when certain users are queried. If we include them in the 'AssignedTo' filter the query instantly errors ...
0
votes
2answers
791 views

Is there a way to query file names in a directory within Access 2010?

Is there a native function for this within Access? Or would I have to do this with a batch script somehow? Moreover, could I rename the files in a directory based on fields in an Access table?
0
votes
2answers
148 views

SQL/DB browser for DB2

I'm looking for a simple SQL browser which supports DB2. I just want to be able to connect to a DB and try some queries.
0
votes
1answer
28 views

Outer join with union in Excel 2010 using Power Query

I've got two tables (two worksheets of the same workbook in Excel 2010): The result should look like this: My SQL code works well: SELECT table_2.ID, table_1.value_1, table_2.value_2 FROM ...