Skip to main content

Questions tagged [sql]

Structured Query Language (SQL) is a declarative query language for relational databases. Consider also using the tag for the specific database software if your question involves vendor extensions or language quirks.

Filter by
Sorted by
Tagged with
1 vote
0 answers
45 views

sqlcmd how to find current port number on server

I'm trying to find TCP port which sql server uses to test one Jira connector, did my homework but that tcp: option doesn't work trying everything. In my example 1432 is actual port I got from DBAs ...
user avatar
0 votes
0 answers
37 views

Azure SQL Server - Is ApplicationIntent=ReadOnly always honored?

I am using Azure SQL database instance (Business Critical, Read Scale-out enabled) and I would like to offload some of the traffic to Read-Only replicas. Does adding ApplicationIntent=ReadOnly to ...
Bojan Nedeljkovic's user avatar
0 votes
0 answers
72 views

I can't start the MSSQLSERVER on new esxi host

I am a student currently studying virtualization and SQL. After obtaining approval from my instructor, I attempted to transfer a virtual machine (VM) to my personal laptop. However, upon doing so, I ...
Roberto's user avatar
  • 69
0 votes
0 answers
18 views

Retrieving specific text data from all files present in a folder

I've some SQL queries (DBT) in a folder. I've to run the dbt sql files and validate them. Before running, I've to clone the sources used in the queries. I'm going through each file and making note of ...
Goutham18's user avatar
1 vote
1 answer
69 views

MySQL: Converting Row to Columns Based on Field Values

I am using MySQL Workbench 8.0. I will break my question into two parts as I believe the first part will be straightforward (but is slightly beyond my current SQL knowledge level) but the second part ...
Dave's user avatar
  • 1,049
11 votes
2 answers
2k views

How to find which senders use the most space in my Gmail account?

How could I sort email senders (distinct "from" addresses) by the total amount of space each sender's cumulative messages (including bodies and attachments) are occupying in my Gmail account?...
MiguelitoCogito's user avatar
2 votes
1 answer
184 views

Could interrupting a SQL query that was taking too long lead to a decrease in disk space?

For a personal data analysis project, I was trying to find the most frequent 3 products that were being sold together by doing a self join (twice). As the query was taking over 15 mins and the laptop ...
M V's user avatar
  • 23
0 votes
0 answers
83 views

Power Query SQL bring in cell contents for the where statement

I am trying to build a flexible sql where statement so that my power query can pull the exact data the user specifies. I have an excel worksheet with about 18 cells that the user populates. I use ...
Nicholas Adams's user avatar
3 votes
1 answer
8k views

How to solve The following signatures couldn't be verified because the public key is not available: NO_PUBKEY EB3E94ADBE1229CF

I am trying to install SQL server on Linux using Ubuntu from this link: https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-ver16&tabs=ubuntu2204 And, in ...
Priyanka Buria's user avatar
0 votes
1 answer
10 views

How to replay recent Influx queries

I want to load test Influx, how do I replay the recent queries that were executed? I have not found anything meaningful on Google.
Bob's user avatar
  • 130
-1 votes
1 answer
426 views

Attuinity connectors SSIS package migrate to SSIS 2022

I have 2015 SSIS solution with attuinity oracle connectors, I am unable to open the package in VS 2022 since it does not support attuinity any more, I get Object reference not set to instance of the ...
Manju Raj's user avatar
1 vote
0 answers
44 views

Is SQL a good way to optimise data access to just one huge table?

TLDR; Is SQL the way to go when trying to access one huge data table? As title. In astronomy we often must deal with huge data files. Usually, we can manage to do it using different optimisation ...
condosz's user avatar
  • 111
0 votes
0 answers
38 views

SQL Server Connection to Excel Workbook

Upon re-opening my excel workbook, the SQL Server connection and associated queries are not saved and unable to be refreshed. How do I resolve this issue? I am accessing the DB via a remote connection ...
Frank N.'s user avatar
-1 votes
1 answer
3k views

How to resolve SQL error 772

Using the preloaded ODBC driver version 10.00.22621.1992 on Windows 11 and added the data source in System DSN. When it tries to test the connection I get this error (picture below). SqlState:01000 ...
Brute's user avatar
  • 23
0 votes
0 answers
109 views

How do I navigate with the dBeaver suggestion blocks?

I always use the shortcut for selects (ctrl+shift+space) but then I need to click to edit thing like the where clause. Is there a keyboard shortcut for me to go from the table block to the column ...
Eduardo Azzolin's user avatar
0 votes
1 answer
134 views

Deleted SQL folder in Program files, now program needing SQL wont launch, or reinstall

I got a little click happy and deleted the SQL folder out of Program files not think if it's connection to a design application I am using. I have tried uninstalling SQL Server 2019 by using the ...
Matt's user avatar
  • 1
0 votes
0 answers
212 views

OneDrive variable in Oracle SQL Developer

We are storing SQL scripts in a shared Onedrive. Since colleagues have personal and a shared OneDrive I want to use the %OneDriveCommercial% variable. This one works fine (I run this in Oracle SQL ...
Jayrune's user avatar
2 votes
1 answer
495 views

Microsoft SQL Server 2014 Standard Edition - Minimum Setup

We have a corporate license for Microsoft SQL Server 2014 Standard Edition and for time to time I have to install (or re-install it) on different Servers and computers. The setup folder size is about ...
knoami's user avatar
  • 123
0 votes
2 answers
259 views

How to properly and efficiently query Lots of data from SQL Server putting it into specific cells?

Recently I was asked to make a real-time project in Excel which evolves huge amount of data. I have this data stored in SQL Tables and managed to successfully bring it into Excel. SQL Table on Excel: ...
Fróis's user avatar
  • 13
0 votes
2 answers
346 views

Create a double entry accounting table by separating transactions

I have an Excel table with accounting transactions that are stored on a single line: Date To Account From Account Amount Type 2023-06-01 2192 2281 $100.00 Transfer I'm attempting to convert that ...
dav's user avatar
  • 10.4k
0 votes
0 answers
2k views

"Error encountered during SQL installation"

During my internship at a company that utilizes Sage software, I faced challenges while attempting to install Microsoft SQL Server, which is required for Sage. I encountered multiple errors during the ...
Skeptic's user avatar
3 votes
0 answers
4k views

Can't install ODBC Driver 17 for SQL server On Windows 11

i want install SSMS 19.1 this is stuck like picture the problem for "microsoft ODBC Driver 17 for SQL Server" cant install i download it manually and try install it but this error appear
abbas-h's user avatar
  • 143
0 votes
0 answers
217 views

Snowflake Execute button not appearing in VS Studio

Apologize if this is a silly question. I use VS studio to connect to snowflake. And all of a sudden when I'm coding, no execute button appears to click. Sometimes I can get it to appear but then it's ...
Timothy Batten's user avatar
1 vote
0 answers
130 views

influxDB v1.8 : InfluxQL : Continous Query in a bash script

I wrote a bash script for inserting the summary of the daily energy database "xxx_d" into the monthly database "xxx_m" - triggered on every 1st day of the month at 02 o'clock by a ...
6a5h4's user avatar
  • 11
0 votes
1 answer
285 views

Installed SQL Express on IaaS VM in Azure, SQL Virtual Machine resource appeared in resource group?

I installed SQL Express on a Windows Server VM in Azure, a few days later a new resource appeared in the RG with the same resource name of the VM but as a SQL Virtual Machine. I take it this won't ...
tezx's user avatar
  • 11
0 votes
0 answers
314 views

MariaDB (mysql like) How to get the index value of a selected row in a sql table? This the unique index, not a row count

Say you have a table... Index is primary key... Index Sensor 1 BME280 2 BMP280 And want to return the Index value only of a matching select query? SELECT * FROM Sensor WHERE Sensor = 'BME280'...
Jibun no Kage's user avatar
0 votes
1 answer
32 views

Is there a way to run a SQL on excel to create another table on the same spreadsheet?

I have a spreadsheet on Microsoft Excel with a formmated table similar to the attached picture. It is a long table (1000 lines or more) with ~30 columns and I would like to know if there is an easy ...
Felipe Oriani's user avatar
1 vote
0 answers
303 views

Is it possible to connect a SQL file in VS Code to a .mdb database in MS Access?

Is it possible to connect the .mdb database file open in Microsoft Access with a .sql file that you edit in Visual Studio Code? I want to be able to create seperate queries in a .sql file that I edit ...
Romans's user avatar
  • 111
3 votes
2 answers
2k views

How to flush Firefox storage SQLite database files to eliminate large SQLITE-WAL files?

I've noticed that the WAL (Write Ahead Log) files (*.sqlite-wal) associated with the SQLite databases (*.sqlite) used by the Firefox web browser often get quite large. They literally can get over 150 ...
End Antisemitic Hate's user avatar
1 vote
1 answer
829 views

How to test in VSCode a postgreSQL SQL expression in Python's interactive notebook (= Jupyter Notebook, iPython) in a venv with package manager conda?

How to test in VSCode a postgreSQL SQL expression in Python's interactive notebook (= Jupyter Notebook, iPython) in a venv with package manager conda?
questionto42's user avatar
  • 2,423
-1 votes
3 answers
6k views

running into permission issues when using the COPY command with postgresql 14.6-1 on linux 6.0.12-arch1-1

Hello everyone :) noob here, trying to learn sql with postgresql 14.6-1 on arch linux kernel: 6.0.12-arch1-1 , the current topic of the book i'm reading, has me doing this command COPY char_data_types ...
greg pinakapoging nilalang sa 's user avatar
2 votes
1 answer
2k views

MariaDB: Should I configure the db-server using "/etc/my.cnf" or a file in "/etc/my.cnf.d"?

I am trying to configure MariaDB on a machine with Fedora 37: Workstation as its operating system. I expected to use /etc/my.cnf to configure the ports and such, however, the file contained an include ...
JΛYDΞV's user avatar
  • 976
0 votes
0 answers
152 views

How to uninstall PostgreSql user on Mac Monterey

I already deleted pgadmin 4 and the PostgreSQL apps and I don't know why the PostgreSQL user profile is listed on my task bar. I checked the official "System Preferences", and I don't see ...
computergurl95's user avatar
1 vote
1 answer
1k views

SQL Can connect by server name but not by instance name

I just install SQL 2017 in two servers with default options. I also have configured the cluster role in both servers and activated the Allways On option. Testing the enviroment before beging creating ...
RAN55's user avatar
  • 53
0 votes
1 answer
186 views

Joining MySQL table

in my database there are 2 tables : posts, room Posts tables include ID and Title columns and includes many rooms and hotels titles and IDs. In the room table there are 3 columns : room_id, hotel_id ...
pooya's user avatar
  • 1
1 vote
1 answer
2k views

How to find a character in a string using Powershell?

Using Contains to find a value using PowerShell is not working. Full Story: I have to get the PartNo, Ver, and Rev values from an SQL DB, and check if these values occur in the first line of the text ...
Brute's user avatar
  • 23
1 vote
1 answer
243 views

Search the contents of a SQL file without extracting it from an archive

I have a 128GB .sql file that's located in a .7z archive. For reasons of storage space, I can't extract the file. Is there any way to search for a specific line within that .sql file, without ...
t1f's user avatar
  • 113
0 votes
2 answers
60 views

ORA-00979 Group by clause error

I am trying to execute a SQL command select distinct T1.dbid,T1.id,T6.user_name,T6.action_name,T6.action_timestamp,T2.filename from promotion T1,history T6,attachments T2 where T1.dbid = T6....
Shimon Nir's user avatar
0 votes
0 answers
437 views

Text to Column has now changed my Excel's pasting preferences permanently

I recently used the text to columns functionality in excel. It was used to split out one singular column that was delimited by commas. After I successfully made the adjustment, my excel now will not ...
Owen Colada's user avatar
1 vote
1 answer
757 views

"Advanced Copy" greyed out in DBeaver menu when trying to copy SQL table output as TXT

I often copy some sample rows and the frame in DBeaver as text for a quick markdown chat note. Now the "advanced copy" is greyed out. How can I get it back?
questionto42's user avatar
  • 2,423
0 votes
1 answer
63 views

Excel 365 - Dynamically importing data into excel from a Database

I have a spreadsheet with 40k rows or so which is added onto every week. Each row has an Employee ID, Employee’s Shift Number and Hours worked column (see attached image for sample data). Sample data ...
user1553584's user avatar
2 votes
1 answer
5k views

DBeaver "Format" --> "Format SQL" --> "To Upper Case" applies to all words. How to format only the SQL command words reserved by the system?

When I right-click on a selected SQL query and choose "Format SQL" it changes the SQL to lower case. The other command "To upper case" is not SQL-intelligent, meaning it changes ...
questionto42's user avatar
  • 2,423
0 votes
1 answer
348 views

Microsoft SQL server management studio 18 commandline replacement

I have created an SQL file for my SQL server. When I double-click on that, Microsoft SQL server Management Studio 18 is opened, username and password are asked, the query is opened and I can launch it....
Dominique's user avatar
  • 2,283
0 votes
1 answer
126 views

Why is the excel date cell-format, date and time is so low

Does anyone have a workaround for formatting datetimes copied from sql into excel? When I copy a date field into excel from sql, it looks like the following 43299.7088541667, I then want to format it ...
SCCJS's user avatar
  • 1
0 votes
1 answer
389 views

Is it possible to exclude a line of code from a Visual Studio 2019 code analysis warning (sr0014)?

I am using Visual Studio 2019 and Azure SQL Database Instance. I have a lot of stored procedures that follow the same pattern. A warning is raised on the build for each stored procedure where data ...
GettingItDone's user avatar
0 votes
0 answers
829 views

SQLCMD Error 0xc000007b

The Environment: Windows Server 2019 Standard SQL Server 2019 Standard SQL CMDLINE Utitlies V15 for x64 ODBC Driver 17 for x64 The Problem: I am trying to run the sqlcmd command in Powershell and ...
JukEboX's user avatar
  • 395
0 votes
3 answers
115 views

How to pull up data written between seperators?

I am a digital marketer with zero experience at coding. I'd like to pull up only the first data which is written between separators (|||) [VP/NNP] ||| talk here ||| walk here ||| PPDB2.0Score=6.03040 ...
Mounir's user avatar
  • 1
0 votes
0 answers
27 views

Getting the result of this SQL query in Excel

I have a table containing the columns for employee name, date, and how late they are that date I want to fill a cell with the content of the column 'Late By' using the criteria 'Employee Name' and '...
Fabian Omarri's user avatar
0 votes
1 answer
59 views

How to report on least values in each category in MS Access?

IN MS Access, I have a table with a few different parameters, like this: Element Weight (g) Smallest Dimension (cm) Orange 100 5 Apple 90 4 Banana 130 2 Grape 40 1 These are grouped into sets, ...
PProteus's user avatar
  • 425
1 vote
1 answer
192 views

Combine one set of time series data with another when some dates are missing in one data set

I have a LibreOffice Calc spreadsheet which contains two sets of time series data e.g. |Date-A |A | | | |Date-B |B | |2020-01-01|101| | | |2020-01-01|201| |2020-01-02|102| | | |2020-01-02|202| ...
spraff's user avatar
  • 2,208

1
2 3 4 5
12