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.
563
questions
0
votes
0
answers
20
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 ...
- 1
0
votes
0
answers
24
views
MSSQL Server working on RH9 or Centos9
Has anybody running mssql-server on RH9 or Centos9?
I got this Error when trying to setup:
Red Hat Enterprise Linux 9.2 (Plow)
Capturing core dump and information to /var/opt/mssql/log...
Hint: You ...
2
votes
0
answers
59
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
- 133
0
votes
0
answers
22
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
0
votes
0
answers
14
views
Is it possible to step through an SSRS Expression?
I have a very complicated IIF statement. Is there a way to step through that expression to see where it goes into either the true or false paths through report builder or another tool?
- 13
0
votes
0
answers
43
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 ...
0
votes
0
answers
38
views
Paste formatted SQL queries from text file into Excel (one Excel row for each query)
I have a .TXT text file that has formatted SQL queries in it.
--The corresponding Excel row ID is: 2
select
main.active_transportation.objectid,
main.active_transportation.type,
main....
- 137
1
vote
0
answers
31
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 ...
- 11
0
votes
1
answer
42
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 ...
- 11
0
votes
0
answers
70
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'...
0
votes
1
answer
24
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 ...
- 187
1
vote
0
answers
80
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 ...
- 111
3
votes
2
answers
392
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 ...
1
vote
1
answer
319
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?
- 1,715
0
votes
2
answers
1k
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 ...
0
votes
0
answers
29
views
Group By Client IDs by Type of Order/Combo requested
I have the following table multiplied by thousands of rows in SQL containing the types of service requested by each client. I would like to group the services each client requested and count them as ...
1
vote
1
answer
311
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 ...
- 568
0
votes
0
answers
23
views
How to view XML data retrieved from a SQL database?
I've got a MS SQL Server database full of XML test logs, and I've set up an Excel workbook with a Power Query table (screenshot here) to view the top-level information about the individual log ...
- 1
0
votes
0
answers
192
views
sql : The System cannot find the path specified
Does anyone have a solution to this problem?
Neha Bhansali
0
votes
0
answers
256
views
Connecting to postgresql database from mysql workbench
I am trying to connect to a postgresql database and was surprised to read you can use mysqlworkbench. But when I try to follow any guides online, on my version of workbench at least, there is no ...
- 101
0
votes
0
answers
351
views
In Access/SQL, how to do an update with an inner join?
I have a report that is populated by the following query:
SELECT tblPassHolders.[PASS HOLDER NAME], tblPassHolders.PHOTO.FileData, tblPassHolders.BARCODE, tblPassHolders.[FAMILY PASS], tblFamilyPass....
- 174
0
votes
0
answers
99
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 ...
0
votes
1
answer
289
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 ...
- 3
0
votes
1
answer
105
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 ...
- 1
1
vote
1
answer
1k
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 ...
- 25
1
vote
1
answer
137
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 ...
- 113
0
votes
2
answers
44
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....
0
votes
0
answers
168
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 ...
1
vote
1
answer
365
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?
- 1,715
0
votes
1
answer
43
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
...
- 11
2
votes
1
answer
3k
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 ...
- 1,715
0
votes
1
answer
150
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....
- 1,921
0
votes
1
answer
95
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 ...
- 1
0
votes
1
answer
173
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 ...
- 121
0
votes
0
answers
485
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 ...
- 395
0
votes
3
answers
104
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 ...
- 1
0
votes
0
answers
19
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 '...
0
votes
1
answer
48
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, ...
- 355
1
vote
1
answer
128
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|
...
- 2,066
0
votes
0
answers
1k
views
Unable to install MS SQL Server or SSMS due to missing DLL, how do I find and install this DLL?
I have the exact issue as the OP of this question but their fix did not work for me:
Related Stack Overflow Question
I need to install MS SQL Server and SQL Server Management Studio on my computer. No ...
- 103
0
votes
1
answer
14k
views
selecting from SQL with LEFT JOIN and multiple conditions
I am trying to fetch posts with multiple filters, my database is as below,
"Meta" Table
id
meta_key
meta_value
object_name
object_id
2
location
new city
post
2
1
post_type
section
post
2
...
2
votes
1
answer
423
views
How to put a comment in a SQL query of JSON items from Azure Cosmos DB?
For an existing Azure Cosmos DB, I am testing SQL queries following this guidance. I would like to insert comments in my query, but the following fails,
SELECT * FROM c /* Example comment */
While ...
- 1,829
0
votes
1
answer
1k
views
bash - passing an sql query as an argument to psql
I have the following SQL query that executes correctly in the psql shell:
SELECT c.component_name AS "Component",
c.component_version_name AS "Component Version",
c....
- 1
1
vote
2
answers
631
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
160
views
How can I create a custom view in outlook that searches shows emails in all folders that have been unresponded to in the past 3 hours?
I currently have the following SQL line in the view filter to search for unresponded emails but need the remaining two pieces, can someone help?
Unresponded emails:
http://schemas.microsoft.com/mapi/...
0
votes
1
answer
60
views
MS Access 2019 - questions about editing and running SQL queries
In the past I've worked with SQL Server and PostgreSQL, using SQL to run queries. At the moment I'm trying to get more familiar with MS Access, and I run into some problems. I prefer to write queries ...
- 7,284
1
vote
2
answers
161
views
Notepad++ split line at variable characters preceding symbol
I am looking to split one line of data into a line for each state regarding a senate nomination vote. I have truncated all fifty states' data into two states' worth for the purposes of this question. ...
- 11
2
votes
1
answer
6k
views
Solve Error without installing PostgreSQL on Mac? dyld: Library not loaded: libpq.5.dylib
I am using a Mac OS X software called TablePlus which throws an error when trying to perform a backup of a PostgreSQL 13 database that is running inside a Docker container.
dyld: Library not loaded: ...
- 365
0
votes
1
answer
271
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
2
votes
1
answer
831
views
Turn .sql file into a table
I have an sql file (from the following link).
I need to get the table which is supposedly encoded in that file.
I have no SQL experience and tried several things that have been suggested elsewhere:
I ...
- 29