The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
0answers
9 views

How to only modify data in table of microsoft access through update queries

I am quite new to Microsoft Access and would appreciate if someone can help me with this. I would like to modify data in table of microsoft access through update queries only but also prevent the ...
0
votes
0answers
15 views

Query to create a matrix of values from one Column [on hold]

I'm new to SQL and I have a very tough task on hand. I have a data set of about 50000 records that looks like this. Header Value 1 Value 2 Value 3 Value 4 Value 5 Value 6 Value 7 Value 8 Value 9 ...
16
votes
3answers
105k 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 ...
0
votes
1answer
73 views

How to share Power Query queries

I was looking for a way to share Power Query queries. I am not sure on how to share query in the intranet. Seems like sharing in Power Query Data Catalog is named "Power BI Data Catalog". This is ...
-1
votes
0answers
17 views

Switching Techniques - Vlan

Assume I have 3 switch connected to each other and port connected to each other are in trunking mode and sw1 have a user in vlan 10 and sw3 has a user in vlan 20. How can both user (which are in vlan ...
1
vote
0answers
12 views

Error when connecting an Access query to an excel sheet -expression in query prevents connection being made

SCREENSHOTI have an excel sheet which is linked to a query in my Access database (both 2010 version). It works really well and I decided that I wanted to have the same excel sheet but to only contain ...
0
votes
0answers
13 views

Access Query Save Path Error

I am trying to save an Access query with a certain path (which i can't modify) but i am getting a save error. The save path looks like this : "C:/FOO/BAR/03. FOO/BAR.accdb" Testing the path i found ...
0
votes
1answer
11 views

How to replace hidden elements in access?

I work with MS-Access database with a lot of tables, qureys and reports. It is easy to hidden some elements (by right mouse click then hidden options), but I do not fin the option to replace those ...
0
votes
0answers
24 views

How to tell if multiple sites contain a keyword

I have a list of 9k web addresses, and a couple of keywords. I would like to know if a webpage contains that word. Ideally, automated google search with some search operators would work great, for ...
-1
votes
2answers
162 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
0answers
39 views

How to Create a Query which Combines Two Crosstab Queries under a Split, Merged Column

Sorry if the title is a little confusing. I am attempting to create a query which takes two cross-tab queries and combines them in a slightly different format than the original cross-tabs. I have used ...
0
votes
0answers
13 views

Query optimization in Data stream

I am confused about the idea of query optimization in stream of data. As a background, I know that optimization for any query is happening inside the DBMS with using of system catalogs which contain ...
0
votes
1answer
18 views

Nested IFF query in MSAccess returning wrong number of arguments

I am trying to write a nested IFF query in MSAccess, but on running the error returned is "Wrong number of arguments" My two fields Paper1 and Paper2 are of datatype True/False The Query I wrote in ...
1
vote
1answer
54 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 ...
4
votes
1answer
47 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 ...
0
votes
0answers
8 views

excel vs access query priority

Hi Superuser this is my question Scenario: -an Access 2003 based application to manage the stock; the application had several mask to peform the update of different .mdb table. -an Excel 2003 ...
0
votes
0answers
40 views

Web Query with login details

I want to create a web query with that will add info like (Account used, username (emails), password) I created a web query already. Please find below the code. My problem is the fact that I have 5 ...
0
votes
0answers
18 views

Dynamic Web query in excel

What i need to have is an excel that can take data from a certain website based on the info i write to a cell in that excel. to be more clear, in the website "Gcmap" when i search "jfk-lax" it gives ...
0
votes
0answers
79 views

how do i filter by a rolling date range from a sql query

I am trying to filter a query by a date range, but a moving date range. I have heard (read on this site) that this can be handled in a formula in excel, but I couldn't really follow the formula that ...
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
1answer
232 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 ...
1
vote
0answers
25 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
30 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: |Manager|User1|User2|...
0
votes
0answers
13 views

Running SPARQL queries via Atom

Using Sublime SPARQL Runner is possible to directly run SPARQL queries. I'm looking to fin a similar solution for Atom. I see that there is some interest in this as the language-sparql provides some ...
2
votes
1answer
114 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 ...
0
votes
0answers
63 views

The query could not be processed: File system error: An error occurred while opening the 'File Path\file_name.cub' local cube file

Please Help Me !! What happen and how to fix it ? It occurred when I open Pivot Table in Access 2010. (My OS is Windows 10) File Path\file_name.cub is always changed every time database is opened. Now ...
2
votes
2answers
711 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 ...
0
votes
1answer
93 views

Can I query a different AD domain with the default Win7 install? [duplicate]

Background I work in an Enterprise where our Active Directory is locked down pretty tight and only Info Security has access to administer changes. I'm using a standard Win7 Enterprise x64 Service ...
0
votes
1answer
32 views

update multiple fields in SQL

I am trying to update my table in SQL 2012 where the CategoryNumber values should be correspondant for the below name values but it seems that my syntax is wrong. Update mytable SET mytable....
0
votes
0answers
18 views

MySQL Query to Find Distinct Instance of Status

My question is regarding a MySQL query that I am trying to write. I have written some psuedo-code to help illustrate what query I am trying to write: SELECT * FROM persons AS p INNER JOIN ...
1
vote
1answer
215 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 ...
0
votes
0answers
36 views

Alternative option for select * from

In the Excel database query we will use the below syntax to define a reference value SELECT * FROM [Sheet1$A1:Z500] where Dept = 'IT' In the above case I am taking the Dept value IT as a reference ...
2
votes
2answers
820 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 ...
1
vote
1answer
332 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 ...
24
votes
15answers
23k 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 ...
0
votes
1answer
189 views

XML query of event log not working

I have been looking for a query to act as a trigger in the Task Scheduler. I want to restart my VPN if it RASClient ends (EventID 20226) for any reason except code 631 (The port was closed by the user)...
0
votes
1answer
64 views

OpenLDAP parametrized replication of a subset

I have a huge LDAP database and I'd like to make a replica that contains only a subset of that database. My objective is to replicate a few groups, and all members within that group. So far, I'm ...
2
votes
0answers
51 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
1answer
14k 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 ...
0
votes
0answers
19 views

Query Concatenation

I need to concatenate 5 fields together. Now the problem is field field2 could have data but not field1 which gives me a headache of extra white space at the beginning and an un-necessary comma if I ...
2
votes
0answers
56 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 ...
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 ...
1
vote
1answer
13k 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
2answers
639 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
271 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 ...
0
votes
0answers
31 views

SQL Server 2012 change query result position [duplicate]

Traditionally in SQL Server while executing a query the result is displayed below the query dividing the screen horizontally. Is there any settings that can be done to displays the result to the side ...
2
votes
1answer
170 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 ...
1
vote
0answers
25 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
42 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 ...
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 ...