Questions tagged [query]
The query tag has no usage guidance.
157
questions
0
votes
0
answers
20
views
Query for Employees with Laptops Only
I'm using a MySQL database and trying to figure a query upon 2 tables:
Employee table where the status needs to be active
Asset table where the status needs to also be active
The asset table ...
- 191
-1
votes
0
answers
9
views
How can I make sure the field changes or match up with its related field in access
I have made a query with licence plate number, service date and invoice number.
grouped licence plate number to one each and service date to MAX so it is showing the most recent date but how can I ...
- 1
0
votes
0
answers
9
views
How you you create a report in access using only one field from one table?
I have a table [tblCheckIn] with only two fields: PASSHOLDER & CHECKINTIME
I want to create a report using CHECKINTIME that shows total number of check-ins we had for each given year.
Like so:
...
- 174
0
votes
1
answer
39
views
Outlook specify mailbox in search query
Is it possible to specify the mailbox in the search query itself instead of using the dropdown on the left ? Thanks.
0
votes
1
answer
22
views
Column/Row management in Power Query
I have a .txt file with loads of data in it. I have it loaded into Power Query thusly:
[let a letter (A) equal a row of data, one column wide]
A
B
C
D
E
A
B
E
A
E
A
B
C
D
E
and so on...
I would like ...
- 3
0
votes
1
answer
124
views
Outlook query for 1 thing in subject line and 2 things not
I use a browser to access my Office 365 email. In my experience so far, the search syntax is the same as for the Outlook desktop application.
I tried the following search query:
subject:"meeting ...
- 937
5
votes
2
answers
3k
views
Only return state of a service when using sc.exe query
When using the following command to return information about a service to a file :
sc.exe query MyService >> MyFileLocation\MyFile.txt
I get the following information in the file :
SERVICE_NAME:...
- 195
0
votes
0
answers
20
views
Access database advice
I'm new to access so this might sound stupid.
I have few thousands csv files, each one containing few hundred rows of transactions data for an item. Each csv file is a different item.
I want to use MS ...
- 15
0
votes
0
answers
28
views
How to diagnose why Query in Microsoft Access is returning wrong results
I have a database in which I store information about what work our contractor is doing for us.
Basically I store WorkNumber, date when work was done, contract number, subcotnract number (we have ...
- 146
0
votes
1
answer
377
views
SQL QUERY not picking up EXCEL date parameter not functional
I have an overnight data set that needs refreshing everyday. I used today's date with format =NOW() and tomorrow's date as =NOW()+1. The query is not pulling up the date from cell reference despite ...
- 19
0
votes
1
answer
54
views
Query Security Events in Windows 10
I enabled Object Access auditing on my Windows 10 laptop using the instructions on this page. I then enabled auditing on a file (i.e. Sleep Times.csv). I accessed the file and manually looked ...
- 1,256
1
vote
2
answers
613
views
Select statement using 'EXISTS' and 'IN' operator
I hit an issue to get data using 'IN' operator from another database. I need help fixing this please.
My query looks like this:
SELECT i.EXTERNAL_CODE, tc.SITE_NAME, tr.TRANSACTION_DT
FROM ...
- 591
0
votes
1
answer
270
views
mysql report multiple values on same line
I have a bunch of temperature sensors in my house. I poll the sensors every minute and store the data in a mysql database that looks like this:
+------------+--------------+------+-----+---------+----...
- 441
0
votes
1
answer
22
views
Need to use logical operation in an MS Acess query field
Let's say I have a table in MS Access. It has a text field, "size". There are only a few values size can take: "tiny", "small", "medium", "large", &...
- 681
1
vote
1
answer
325
views
How to add a parameter to a website (Twitter) using Chrome Extension?
I want add a parameter to a Twitter URL (removing the one that's there if there is one already)
Using this URL as an example,
https://twitter.com/RequestlyIO/status/1272478326838292488
it would need ...
- 11
1
vote
1
answer
1k
views
Microsoft Access: Query to delete duplicate data but keep most recent
To my surprise, I've been having trouble finding an answer to this question for my specific case.
I have a table with ID and date and I would like to keep only one ID, and that is the most recent one.
...
1
vote
1
answer
72
views
Excel Query to Append Repeated Columns into New Table As Records
I have a Microsoft Forms that customers fill out. The same three questions are asked multiple times as they have to answer the same three questions for multiple parts. What ends up happening when I ...
0
votes
1
answer
69
views
Find Average Value based on Date and SKU
I come with another question.
I am trying to find the last purchase price per SKU.
I have the list of SKUs I want to find the pricing for in Column A of Sheet 1. In Sheet 2 I have the SKU in Column E, ...
- 19
0
votes
1
answer
531
views
How do I populate excel with address details from Google?
I have a list of companies in Column A in excel. I have been manually googling each company and copying and pasting the address into Column B, but there must be a better way?
Here's what I've tried so ...
0
votes
2
answers
178
views
Excel automatically changes format from numeric to either date or other number format
I wrote a query in postgresql to get the data I need and want to further analyze it in excel. But everytime I past my numeric variables it either turns into a short date format or a number like 27....
- 3
0
votes
0
answers
98
views
SQL Server XML field
I have an XML field in a database that stores the XML response from a service.
Every now and then, the service times out and what actually gets stored in the XML field is a non-XML value "Time ...
- 31
0
votes
1
answer
196
views
How do I add only new data to an Excel Data model?
I have a sheet with 1000s of rows of historical sales data, and I want to be able to export "sales month to date.csv" from my CRM package, and for those new values which have not been seen before to ...
-1
votes
1
answer
32
views
If and then query
I want to populate the cell J4 based on the table value (see attached image)
If cell IA = WDDS the populate with table WDDS value 6:00
If cell IA = WDAS the populate with table WDAS value 12:00
If ...
0
votes
1
answer
703
views
Is it possible to change the font size in SSMS log file viewer?
I'm using SSMS 18.2 and find that the font size inside the log file viewer window (reachable via "Object Explorer" -> "Management" -> "SQL Server Logs" -> Current") is very small, probably below 8 ...
- 3
1
vote
1
answer
599
views
Is "fsutil behavior query mftzone" for all partitions in Windows 8.1 64-bit?
I have 2 HDDs and 5 partitions in them, and I can't find this question answered on DuckDuckGo, Google nor Microsoft; the command doesn't allow to specify a drive letter, so I suppose is for all ...
- 21
0
votes
0
answers
912
views
Excel File, import data from a MDF file using a query
I got a MDF file with data on it, and i got an excel file that needs to display certain data from that MDF file based on data it already has.
How can i connect the MDF file to the Excel sheet so ...
- 111
1
vote
1
answer
64
views
Monitoring blocked requests in varnish
I set up a blacklist in varnish where a bunch of IPs that I suspect for malicious intentions are blocked.
I'm trying now to see if there's a way to monitor if any of these IPs made any request and if ...
- 11
0
votes
1
answer
188
views
Is it possible to mask dns queries?
Would it be possible to mask dns queries?
Example scenario : In a corporate network, can an end user machine mask it's dns queries as coming from another machine id.
Thank you.
0
votes
1
answer
1k
views
relation tableName does not exist - PostgreSQL
I have a database named mimic on my postgres DB .
I'm trying to execute this command :
select hadm_id from admission_ids where hadm_id in (select distinct on (subject_id) hadm_id from (select * from ...
- 123
0
votes
1
answer
350
views
Add Watermark to the bottom right
I want to add a watermark at the bottom right with query given below, also shown in this image:
My command is:
String[] command121 = {
"-y",
"-i",inputPath_audio.mp3,
"-loop", "1",
"-i", ...
- 113
0
votes
2
answers
45
views
Multiply several columns by Paramater
I have a set of budgeted columns - Jan, Feb, Mar, etc will sales values in a Foreign currency. I want to multiply all monthly columns by a FX rate enter via a Parameter. It this possible?
I know I ...
0
votes
1
answer
94
views
javascript in mongoshell
I want to make a join query in mongodb. Mongo doesn't have any join operator so i have to split the query in two parts.
first:
var a = db.articoli.find({_id: 4010}, {ordini:1});
var b = a[0].ordini;
...
2
votes
1
answer
70
views
How to execute remote mysql query after granting permission?
I am trying to execute mysql query from another ubuntu system.
I have granted permission to user using GRANT from 192.168.64.9
GRANT ALL ON . to 'user'@'192.168.64.11' WITH GRANT OPTION;
and then ...
1
vote
1
answer
1k
views
WMI query to detect if Windows Home or Pro
I am using MDT to deploy my computers and want to have it run a second task sequence when it hits the custom tasks stage. One thing is that i want to have Both Windows Home and Pro editions in the ...
- 11
0
votes
1
answer
303
views
How would I create a LEFT JOIN SQL query in Access using the Query Wizard?
Is this even possible? I always end up with INNER JOIN after viewing the SQL that the wizard provides. I know how to write the query myself. I'm just trying to figure out if I should be selecting ...
- 48
0
votes
1
answer
344
views
ACCESS Query does not find all records
I am testing a simple database of patient recorded vitals. I am trying to do a query of those patients with a BGL >250 within the last week. I have put in test data to trigger return but not all ...
- 11
0
votes
0
answers
363
views
Dialect class not found: org.hibernate.dialect.ExtendedSQLServerDialect
I'm using a BI suite called Knowage (I hope there are some users here). When i try to build a Meta-Model i get the following error:
Error while initializing Qbe interface
java.lang.RuntimeException: ...
3
votes
4
answers
9k
views
How to get query command on Windows 10
I have a Windows 10 computer on which I need to see what users are logged in via an SSH connection (which is the command prompt). I figured I could run query user on the machine, but the query command ...
- 1,458
0
votes
1
answer
311
views
Queries run slow after updating database from SQL 2008 r2 to 2014
I've changed my database edition from 2008 r2 SQL server express to 2014 enterprise edition. The point is, queries run like 3 times slower than the old server. I'm testing on the same data and I've ...
- 1
0
votes
0
answers
21
views
I have a query of 5 tables and about 120,000 rows of outputs. How can I display them in the grid for high performance? sqlserver optimize
I have a query of 5 tables and about 120,000 rows of outputs. How can I display them in the grid for high performance?
microsoft sqlserver
microsoft visual studio
- 61
0
votes
1
answer
29
views
SQL Server 2012
I am new to SQL with no training what so ever and what little I do know I taught myself so please be gentle with me.
I have a table that has 4 columns. I will call them customers, customer code, ...
0
votes
1
answer
519
views
SQL Server's Maximum Workspace Memory decreases over time - only instance restart to increase it
This is an SQL Server 2016 CU2 instance with 15 GB configured as maximum RAM usage. MDOP is at 4. The databases in this instance are very sporadically queried by users and this is a read-only ...
- 179
0
votes
0
answers
406
views
Querying Offline Files available disk usage
Looking for a way to query the Offline Files "available" disk usage (Windows 10). The value I want to query is displayed in the Offline Files GUI on the Disk Usage tab. The value is not based on ...
- 131
0
votes
2
answers
596
views
Access SQL Subquery to find a value from the previous year record (Max/Top minus 1)
All the advice I was able to locate doesn't seem to get at this (I am also trying to avoid a DLookup in the Table itself):
The table: Table has client records including a Year field, an ...
- 25
1
vote
0
answers
385
views
DNS queries "DomainServer.dom.local.dev.null" by QNAP NAS
We encounter strange DNS queries intiated by a QNAP NAS:
DomainServer.dom.local.dev.null
DomainServer.dom.local (name is obfuscated here) is the valid name of the domain controller. But the NAS adds ...
- 2,874
-1
votes
1
answer
171
views
Excel: New Powerquery from Web (csv) doesnt work
I want to build a worksheet where the user can input a Stock symbol and the balance sheet is automatically downloaded from morningstar to a table, and then some custom formulas are run on the data.
...
- 340
0
votes
0
answers
27
views
How to create readonly table from raw data
If I have a large table of data, essentially like a database, can I create another sheet or range that is a filtered subset of the full dataset? If so, will it stay up to date when the main table ...
- 558
0
votes
1
answer
1k
views
Run a mySQL Query With a Parameter from Excel - Multiple Rows
I was able to adapt this link for my project, but I am looking for a way to duplicate for multiple rows. Here is my query:
SELECT data_0.InvoiceNumber,
data_0.CustomerNumber,
data_0....
0
votes
2
answers
2k
views
DNS and understanding root servers
Firstly, is this explanation on how DNS works right?
When we visit a site, say (www.example.com),we are doing a lookup to convert the domain name to an i.p address. So, our computer first looks at ...
- 5
1
vote
1
answer
239
views
How come this query shows the same address for non-authoritative answers and authoritative answers?
So, if i query slash16.org:
nslookup -type=ns slash16.org
Non-authoritative answer:
slash16.org nameserver = ns-686.awsdns-21.net.
slash16.org nameserver = ns-1989.awsdns-56.co.uk.
slash16.org ...
- 25