Questions tagged [query]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
38 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 ...
user avatar
0 votes
0 answers
20 views

Excel Queries suddenly giving "File In Use" on Refresh all

I've been trying to troubleshoot an issue that came up with one of our clients. They have a number of Excel sheets that query data out of an Access Database file, used to quickly view data on some ...
user avatar
0 votes
0 answers
30 views

How to make an Excel Query to update the imported data from a web page by expanding and saving the old data instead of overwriting the old data?

I have an Excel query which read data about price of a commodity form a website table with 30 rows which is updated every day (i.e. every day shows the price of immediate last 30th days). I want to ...
user avatar
4 votes
2 answers
809 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:...
user avatar
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 ...
user avatar
  • 15
0 votes
0 answers
21 views

Why does Access recalculate a stored query when I copy it? Can I tell it not to?

When I copy and paste a stored query in Access, it's usually because (a) I want to back up the code before making changes, or (b) I want to make a new query by making changes to that one. All I want ...
user avatar
  • 487
0 votes
0 answers
46 views

Transform and concatenate multiple data files into one worksheet in excel

I have multiple data files in csv format. I want to do a few simple operations on each and collect the summary of all in one excel worksheet - so I can easily see the results for all the csv files in ...
user avatar
0 votes
0 answers
19 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 ...
user avatar
0 votes
1 answer
128 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 ...
user avatar
0 votes
0 answers
19 views

How is the solution to solve the syntax of this select with update query and inner join tables?

I could not understand the problem that is occurring in this update syntax: UPDATE OPN SET OPN.points = (case when OPN.nivel_id=70 then ...
user avatar
0 votes
1 answer
27 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 ...
user avatar
  • 1,218
1 vote
2 answers
71 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 ...
user avatar
  • 571
0 votes
1 answer
28 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: +------------+--------------+------+-----+---------+----...
user avatar
  • 361
0 votes
1 answer
14 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", &...
user avatar
1 vote
1 answer
252 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 ...
user avatar
1 vote
1 answer
850 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. ...
user avatar
1 vote
1 answer
55 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 ...
user avatar
0 votes
1 answer
21 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, ...
user avatar
  • 19
0 votes
1 answer
149 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 ...
user avatar
0 votes
2 answers
62 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....
user avatar
  • 3
0 votes
0 answers
70 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 ...
user avatar
  • 31
0 votes
1 answer
79 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 ...
user avatar
-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 ...
user avatar
0 votes
1 answer
464 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 ...
user avatar
  • 3
1 vote
1 answer
422 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 ...
user avatar
0 votes
0 answers
608 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 ...
user avatar
  • 111
1 vote
1 answer
26 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 ...
user avatar
0 votes
1 answer
64 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.
user avatar
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 ...
user avatar
0 votes
1 answer
268 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", ...
user avatar
0 votes
2 answers
41 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 ...
user avatar
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; ...
user avatar
2 votes
1 answer
69 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 ...
user avatar
1 vote
1 answer
665 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 ...
user avatar
0 votes
1 answer
168 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 ...
user avatar
0 votes
1 answer
95 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 ...
user avatar
0 votes
0 answers
313 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: ...
user avatar
2 votes
4 answers
6k 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 ...
user avatar
  • 1,268
0 votes
1 answer
281 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 ...
user avatar
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
user avatar
0 votes
1 answer
24 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, ...
user avatar
0 votes
1 answer
407 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 ...
user avatar
  • 149
0 votes
0 answers
294 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 ...
user avatar
  • 121
0 votes
2 answers
493 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 ...
user avatar
  • 25
1 vote
0 answers
316 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 ...
user avatar
  • 2,732
-1 votes
1 answer
164 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. ...
user avatar
  • 324
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 ...
user avatar
  • 508
0 votes
1 answer
857 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....
user avatar
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 ...
user avatar
  • 5
1 vote
1 answer
167 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 ...
user avatar