Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [query]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
10 views

How to delete all exact element tags in inspect element console with this querySelectorAll method? [duplicate]

think of this as giving a manual of how to do querySelectorAll method to dummies because it is now dont use terms i understand that actually confuses me just explain but do it thourally please with ...
Olstice's user avatar
-2 votes
0 answers
18 views

want to optimize table column into less number of rows on the basic of size mentioned in item name

I tried to pick last word from string from trim formula but this one is not helpful because I also have to pickup rate of that size into table 2 I want to optimize columns into row, main thing is to ...
Pranav Arora's user avatar
1 vote
1 answer
68 views

How to find matching yaml files based on content

I have a bunch of files that contain yaml. Some files are yaml-only, some have yaml front-matter. I would like to be able to query the list of files to return a list that match certain criteria. In ...
user2567544's user avatar
0 votes
1 answer
21 views

How can I create a team watchlist in Azure DevOps, similar to how individuals can follow items?

In Azure DevOps, I'm trying to create a "team watchlist" that allows visibility for the entire team to see followed items on the dashboard. For example, queries can be filtered by ID=@...
Kaila A.'s user avatar
0 votes
0 answers
93 views

Microsoft excel: Queries and connections - option to update data manually is greyed out

For my link to other excel workbook table: For some reason, the update: manual option is greyed out for this query link in excel Data --> edit links. I don't want the data to update automatically ...
babipsylon's user avatar
0 votes
1 answer
57 views

how to optimize DB query for table with millions of rows when info is sorted (sorted by date in this case)

Imagine you are chatting with your SO on Whatsapp and the conversation is years long, so there are thousands if not millions of messages. CREATE INDEX date_index ON messages_table (date_column); and ...
Alexander Mills's user avatar
0 votes
1 answer
72 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.
Ilian Vasilev Kulishev's user avatar
0 votes
1 answer
51 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 ...
CCChase's user avatar
0 votes
1 answer
327 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 ...
user2153235's user avatar
  • 1,201
5 votes
2 answers
4k 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:...
Niek Jonkman's 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 ...
J Doe's user avatar
  • 15
0 votes
0 answers
114 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 ...
SilverWarior's user avatar
0 votes
1 answer
524 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 ...
Teodros IV's user avatar
0 votes
1 answer
98 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 ...
Nathan's user avatar
  • 1,306
1 vote
2 answers
2k 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 ...
susik's user avatar
  • 653
0 votes
1 answer
403 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: +------------+--------------+------+-----+---------+----...
mikem's user avatar
  • 476
0 votes
1 answer
78 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", &...
bob.sacamento's user avatar
1 vote
1 answer
386 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 ...
MrSparky's user avatar
1 vote
1 answer
2k 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. ...
person1234568475's user avatar
1 vote
1 answer
93 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 ...
person1234568475's user avatar
0 votes
1 answer
106 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, ...
Preston's user avatar
  • 19
0 votes
1 answer
2k 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 ...
user3152057's user avatar
0 votes
2 answers
423 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....
ColRow's user avatar
  • 3
0 votes
0 answers
145 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 ...
Tom's user avatar
  • 31
0 votes
1 answer
442 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 ...
user3152057's user avatar
-1 votes
1 answer
33 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 ...
Lance Parker's user avatar
0 votes
1 answer
942 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 ...
Marc C's user avatar
  • 3
1 vote
1 answer
766 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 ...
saultube28's user avatar
0 votes
0 answers
1k 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 ...
A.bakker's user avatar
  • 111
1 vote
1 answer
98 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 ...
JakobAttk's user avatar
0 votes
1 answer
274 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.
Abhi John's user avatar
0 votes
1 answer
2k 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 ...
el abed houssem's user avatar
0 votes
1 answer
464 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", ...
VikasSharmalp's user avatar
0 votes
2 answers
58 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 ...
Jon Hurley's user avatar
0 votes
1 answer
104 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; ...
Tiziano Pacifico's user avatar
2 votes
1 answer
74 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 ...
wiTTyMinds Technology's user avatar
1 vote
1 answer
2k 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 ...
Dudefoxlive's user avatar
0 votes
1 answer
621 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 ...
tmsdajpa's user avatar
0 votes
1 answer
599 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 ...
Mitch Hall's user avatar
0 votes
0 answers
432 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: ...
dimerazor's user avatar
4 votes
4 answers
12k 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 ...
Mark Deven's user avatar
  • 1,620
0 votes
1 answer
372 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 ...
charles's 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
M R Jafari's user avatar
0 votes
1 answer
35 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, ...
user1027735's user avatar
0 votes
1 answer
658 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 ...
rofz's user avatar
  • 179
0 votes
0 answers
632 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 ...
DHH's user avatar
  • 141
0 votes
2 answers
720 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 ...
Stumped's user avatar
  • 25
1 vote
0 answers
433 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 ...
marsh-wiggle's user avatar
  • 2,994
-1 votes
1 answer
181 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. ...
tim's user avatar
  • 350
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 ...
J Collins's user avatar
  • 678