Questions tagged [query]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
9 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", &...
1
vote
1answer
135 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 ...
1
vote
1answer
221 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
1answer
49 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
1answer
16 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, ...
0
votes
1answer
44 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
2answers
28 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....
0
votes
0answers
38 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 ...
0
votes
1answer
71 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
1answer
29 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
0answers
43 views

Excel 2011 - pull stock price from web (data query)

I'm setting up a stock portfolio in Excel. I want to pull a stock price from the web and insert into an individual cell. I want it to refresh every 1 minute. I've tried the instructions here: Tie ...
0
votes
1answer
180 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 ...
1
vote
1answer
254 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 ...
0
votes
0answers
287 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 ...
1
vote
1answer
16 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 ...
0
votes
1answer
26 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
1answer
658 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 ...
0
votes
1answer
173 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", ...
0
votes
2answers
38 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
1answer
90 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
1answer
61 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
1answer
313 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 ...
0
votes
1answer
43 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 ...
0
votes
0answers
48 views

Does phpMyAdmin 4.7.6 have ability to save SQL queries

I've recently upgraded to latest version of phpMyAdmin and it appears the ability to save queries has disappeared. Maybe there is a setting I need to change to get the dropdown and ability to save the ...
0
votes
1answer
46 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 ...
0
votes
0answers
199 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: ...
0
votes
2answers
2k 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 ...
0
votes
1answer
263 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 ...
0
votes
0answers
18 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
0
votes
1answer
21 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
1answer
247 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 ...
0
votes
0answers
198 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 ...
0
votes
2answers
304 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 ...
0
votes
0answers
38 views

Vlookup query with IF, AND and possibly any other commands

I've prepared a table in which I need to have a vlookup function to manage multiple criteria based on data in corresponding cells & sheets. I need help to implement the following rules: SHEET ...
1
vote
0answers
257 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 ...
-1
votes
1answer
149 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. ...
0
votes
0answers
22 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 ...
0
votes
1answer
688 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
2answers
1k 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 ...
1
vote
1answer
146 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 ...
0
votes
1answer
38 views

Perform a Windows 7 search & display files with identical names but different integer value at end of each?

Lets say I have the files: doc01, doc02, doc03, doc04...doc64 Is there a query I can enter in a normal windows 7 search box, to pull up all these ten files? Also note they they usually have the same ...
1
vote
2answers
197 views

Excel: show list of values based on query in range

I have a table like this: a | tomato b | pear c | tomato d | pear I would like to create a formula that lets me select which rows contain tomato and which ones contain pear. ...
0
votes
0answers
36 views

Pivot source with SQL vs. Table source with SQL and then Pivot based on the table

If I want to pull SQL data into a Pivot table, what will be quicker and more efficient? To have the data pulled into a regular table (which I want to present anyway) and then create the Pivot based ...
0
votes
1answer
124 views

Change the perspective of data in excel

I have the following scenario: I have records of students in a table. Each student has: Name, Email, Gender, Id, Country Additionally, each student has Choice1, Choice1Feature1, Choice1Feature2 ...
0
votes
1answer
426 views

Subtracting two times in libre office base

How can I subtract two times in a query in libre office base? For instance, 10:30 - 9:00 should give 1:30. Thanks. EDIT: As it says in the question, I am having this problem in "base", not with the ...
0
votes
1answer
21 views

Query that needs input from two different records

I have a "timecard" table. A few typical entries might look like ID task date start time 1 proj_XDFR 4/5/18 8:30 2 proj_PEIRN 4/5/18 9:45 3 proj_ERU54 ...
1
vote
1answer
80 views

Is Distinct adding any value or doing anything in this Query?

Assuming the Users.Id field is unique auto incremented MY MAIN QUESTION: Is "Distinct", in this query, doing anything, is it completely pointless having it in this specific query? SELECT DISTINCT ...
0
votes
1answer
636 views

MS Access 2016 Record count with subquery count with percent result

I have a query that counts the number of records in a table that contains a number of repair tickets, and the result is the number of repair tickets by company that have been completed. Example; ...
1
vote
0answers
65 views

Can I save 'Outlining in my MS SQL Query

When writing a query, I will often use Cross Apply, or multiple sub queries. To make the query easy to read I realized you can outline parts of the query, and then hide them. Using: Edit -> ...
1
vote
0answers
39 views

Adding external query from website into existing table?

Been trying to figure this out for a while, I'm not good enough at excel to see where the existing information is accessing the query. I have no idea how it works but the post made it seem like all ...