Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

1
vote
0answers
7 views

I need to write a query by inputting multiple values. Trying to find best way to achieve this

I have big list of aliases (around 90) which I want to input into query to get other data. Below is my query with three values. If I do for all 90 it will be big query and this may not be the right ...
-2
votes
0answers
10 views

SSIS issue changing deployment target to 2016

I have SQL Server 2016 installed running SSDT 15.8.2 with Visual Studio community 2017. I want to create a project to copy a sql table to another DB (for now testing within my current SQL2016 between ...
0
votes
1answer
9 views

How to generate a virtual field in sqlite [on hold]

Many thanks for your support in advance. Let me summarize my little problems with the following example, I have an application using sqlite engine with 3 tables: User table with several fields (id, ...
0
votes
1answer
14 views

Exasol: How to get the session queries executed in Exasol server

I am have connect to Exasol server where queries are written in a reporting application. Now i want the list of queries executed in particular execution of my report. Note: I am looking for tables or ...
0
votes
0answers
6 views

Getting “java.sql.SQLException: Values not bound to statement” exception [migrated]

I recently upgraded from sqlite-jdbc-3.7.2.jar to sqlite-jdbc-3.26.0.jar. I observed that the insert query in my code are failing with “java.sql.SQLException: Values not bound to statement” exception. ...
1
vote
0answers
7 views

InfluxDB Copy data from one series to another

I've setup a home automation system which logs data into influxdb. I've two measuraments taken from two variables concerning the same sensor. I would like to remove the old table and migrate old data ...
0
votes
0answers
13 views

BigQuery report automation [on hold]

How to automate BigQuery reports to specific sheets. It could be daily or weekly. I really need help with this. I have tried supermetrics, blockspring, it didnt wanna generate the result.
0
votes
0answers
9 views

Query on SQL transaction

I got the below question in an online exam. The question is: You are connected to an SQL database and are issuing DML statements. You want to be able to undo the first set of statements you have done ...
0
votes
1answer
49 views

How to create and drop a table outside of SQL

How to create and drop a table outside of SQL, that is, I have a table that I need to change fields, include fields and for this I need to drop the old one, create a new one to load it and save the ...
0
votes
1answer
16 views

Program connecting to SQL over port 445

I have a program called VHI(Visual Health Information - Network Version) that is a server/client model. I have installed the server portion and has a database. SQL Server Name\instance = "EDSERV03\...
0
votes
0answers
12 views

Excel, ODBC - desired database not listed

When I attempt to create an ODBC to a server (named DARKHELMET for all you spaceballs fans out there) it doesn't show in the list of available data sources. ..but it does show up under data source ...
0
votes
0answers
10 views

SQL Server CPU Utilisation won't exceed 10%

We have a virtual machine running in Azure. When i remote onto the server box desktop and run SQL queries, each query connection will only use 10% of the processing capability of the server. When i ...
0
votes
0answers
4 views

SQL Server 2008 R2 - Settings to run deletion statements faster [closed]

I am working on a project to delete entries from a database. I have a script that goes through about 4000 tables and deletes entries that meet a certain condition. Basically, I am batching the tables ...
1
vote
1answer
21 views

load csv file into mysql using batch?

I am looking for help to load a .csv file into MySQL Server using batch and I have few basic questions. Issues: 1) The CSV file data may have , (comma) in between (Ex: description), so how can I ...
-2
votes
0answers
14 views

SQL to chop and reorganise Data [closed]

I have this query which am struggling on develop a query to resolve. We have road sections defined by "SECTION" labels. Each section has been surveyed and a road defect has been allocated to ...
0
votes
0answers
10 views

SQL Query Filter Item without affect next record [closed]

The following queries is using partition by in order to get the previous balance. SELECT SUM(TT.StockQty) over (PARTITION BY TT.ItemCode order by TT.syscreated asc) as 'Balance', TT.syscreated as '...
0
votes
0answers
12 views

MarkLogic SQL Data Modelling [closed]

I am currently integrating a connection from MarkLogic to Qlik Sense but I can’t seem to add a data in MarkLogic. I have followed the steps in this link https://docs.marklogic.com/guide/sql/setup#...
0
votes
0answers
13 views

Will deadlocks occur when deleting rows from a table when being added to by another process? [migrated]

I have to archive data from a table into another table whilst the original table is in use. The archival process is to copy the rows into another table and then delete the rows from the original ...
0
votes
0answers
20 views

Why after deleting mysql-bin.index does my server SQL connect again in MAMP otherwhise it does not?

When I install MAMP, everything works fine the first time. Apache server connects and SQL also, I can access phpMyAdmin page also. But after turning off the server and turning it on again, MySQL doesn’...
0
votes
0answers
3 views

How do I get SQL Server Management Studio to find a .bak file to restore? [migrated]

I am trying to turn a .bak file into a database. I can't find the "Restore Database" button when I left-click "databases" when connected. This is what I should see. However, this is what I see. I ...
0
votes
0answers
3 views

sql ssms on development - clear log.ldf files [migrated]

while working on building of a big DB i notice my C drive run out of space when running heavy SQL queries on SQL Server. by checking this folder size is over 150GB , when log.lpd files reach over ...
0
votes
0answers
21 views

Login analysis service (ssas) using command prompt

I want to login SQL Management Studio (ssms.exe) using command prompt, but want to connect to analysis service server. I tried ssms.exe -S servername -U username -P password in cmd, which connected ...
0
votes
1answer
52 views

Uninstall a single SQL server Instance through the registry

I'm running SQL Server 2014 and have 50 separate instances running. This is the max limit of number of instances for this version and I obviously need to uninstall some instances and clean up. ...
1
vote
1answer
41 views

How to calculate percentage with a SQL statement? [closed]

i have two sql tables i want to compare two tables ..comparing two tables is done now what i want is how many records are matched and not matched in the form of percentage .is it possible to write a ...
0
votes
0answers
44 views

Getting “PartitionKey value must be supplied for import” error when using FME Workbench to import data from SQL into CosmosDb

I have been trying to import data from an SQL table into CosmosDb using FME Workbench (20181107 - Build 18567).  The connection seems to be set up; however, when data import starts, I get the ...
1
vote
0answers
8 views

open SQL Server Management Studio from another machine

I have SQL Management studio installed on my VM and I use VDI to access VM. the only reason i login into VM to access the SSMS. Is there is any way i can open the SSMS from VDI without login in to VM? ...
1
vote
2answers
33 views

Error: Characters found after SQL Statement

I am currently trying to insert a new row of information into a table, and am using the sql view inside of MS Access. When I run this code: SELECT * FROM VersionReleases; INSERT INTO ...
0
votes
0answers
13 views

SQLAlchemy not connecting (first time user)

I am new to SQLAlchemy. I believe that I installed SQLAlchemy correctly since I just needed to do three simple installations. However, once I tried to connect to sqlite, which is said to not need ...
0
votes
0answers
42 views

Can not uninstall SQL Server 2017

I had SQL Server 2014 before installing SQL Server 2017; after I had installed SQL Server 2017, I decided to uninstall SQL Server 2014. I can uninstall SQL Server 2014 completely, but when I tried to ...
0
votes
0answers
12 views

Using sqoop to connect from one server to another

We're using: sqoop.Sqoop: Running Sqoop version: 1.4.6.2.6.5.19-1 on a Linux system in concordance with Hadoop. and Linux VERSION="7.4 I'm trying to connect bwtween two servers automatically (...
0
votes
0answers
38 views

Haw can I execute my VB script in every 5 minutes automatically

I write a VB script and I need to run this script as a trigger in every 5 minutes My code is as follows: Sub Write_data_record_into_a_table() '////////////////////////////////////////////////////////...
3
votes
1answer
288 views

MS Access - Grouped query based on MAX field

I am trying to build a SQL Query that takes the following data: +-------------+--------+---------+---------+--------+ | Primary Key | ID | Version | Class | Fruit? | +-------------+--------+----...
0
votes
1answer
174 views

Connecting DBeaver to a Firebird file, gives error code 335544721

I'm trying to make DBeaver database manager connect to a Firebird *.FDB file. It is a local file database and I want to inspect the tables etc and perform some queries for data reporting. However, ...
0
votes
0answers
50 views

How do I upload an .mdf file to Azure Data Studio for Mac?

How could I access multiple databases at once using Azure Data Studio and import an existing .mdf file as one of those database, with tables and data that had been stored in that .mdf file?
0
votes
0answers
18 views

SQL Compare 13, copy & paste from differences SQL View doesn't copy carriage return/newline?

I'm using SQL Compare 13 to compare a test and production database. Sometimes there are tiny differences and I just copy & paste it from the differences SQL View and run it in the target database. ...
0
votes
1answer
243 views

Jupyter Notebook ModuleNotFoundError --> No module named 'sql' when running Python

I use Jupyter Notebook from Anaconda 3 to run Python but unable to run certain Python code. Below is the first cell of the Python code and the first 2 rows of the error: enter image description here ...
0
votes
0answers
20 views

Access view SQL ad hoc query & output side by side

In MS Access, is there a way to view the sql query window and the related output side by side? I want to be able to write / run sql ad hoc queries and view the output simultaneously so I don't have ...
0
votes
1answer
279 views

How to get rid of Cold Turkey (website-blocker) / get around the block?

I'm using Cold Turkey for blocking distracting websites, but I unfortunately put it to 20 days and it now gets really annoying. Many "solutions" on the internet I have stumbled upon are for Cold ...
0
votes
0answers
70 views

How to install DBATools

I want to install on my Desktop DBAtools utility. I expect that it will help me to explore SQL more .. I found reference to it at this location https://dbatools.io/commands/ I downloaded the package ...
0
votes
0answers
11 views

Export attached(type) files from MS Access to SQL

I want to export database from MS Access database to SQL server. The problem is that when it comes to attached files than sql doesn't recognize it, because there is no such type of data in SQL. I ...
0
votes
0answers
51 views

How to display Oracle SQL code of MATERIALIZED VIEW using DDL command of SqlCl product?

Using Oracle SqlCl tool, when I try to display SQL code of a materialized view using following command DDL mv_address Oracle SqlCl display following message Multiple objects exist with the name ...
0
votes
0answers
100 views

Batch Error SQL Server BULK INSERT

I am attempting to have a script in my batch file that runs a SQL Server Stored Procedure. The Stored Procedure bulk inserts data from a .CSV file into a SQL Server table. When I run the Stored ...
1
vote
0answers
14 views

Intermittent issues connecting to a SQL CE Database

I'm trying to work on a local development copy of a website in Visual Studio 2017. This website uses a SQL CE database in an .MDF file, and I run the site locally through VS using IIS Express. When I ...
0
votes
0answers
51 views

How to do I make NPS properly create its SQL database?

NPS (Windows Server role) natively supports writing authentication logging events to a SQL database. Running through the wizard is supposed to create the database, the table, and the stored procedure(...
0
votes
1answer
18 views

Grouping by status then priority and extracting the earliest start time and latest end time if they exist in different rows

In MySQL, how can I group by status, then priority, and take the start time and latest end time if they exist in different rows? This is how my data looks right now: This is what I'd like the data ...
0
votes
1answer
185 views

WSUS WID Database recovery

My WSUS server, a Hyper-V VM running on a Window Server 2012 R2 Host, after a host power failure and later boot-up, showing error: Application: 3414 Source: MSSQL$MICROSOFT##WID An error occurred ...
0
votes
1answer
58 views

Server Hardware slower than Workstation Hardware (Same Software)

I made my Database Sync. Software multi-threaded. On my own workstation CPU : i5 2500 RAM : 8 GB HDD : 2x WDC WD5003ABYZ (Software Mirror) OS : Windows 10 Ultimate SQL Server : SQL 2008r2 it ...
1
vote
1answer
35 views

selecting non matching records from full outer join

I have two tables tb1 ------- 1,ali 2,ana 3,kim 6,git 8,sen 9,pam tb2 ------- 2,joy 3,fin 4,roy 5,dina 9,tim output ------- 1,ali 2,joy 3,fin 4,roy 5,dina 6,git 8,sen 9,tim I need to join two ...
2
votes
0answers
43 views

SQL Server 2017 cannot connect to remote databases

I tried to uninstall some old versions of SQL Server I had installed just to free up hard drive space, and along the way I corrupted my SQL Server 2017 such that SSMS could no longer connect to any ...
0
votes
0answers
69 views

Run an MS Query query from the command line to do and SQL join between two xlsx sheets in Office 2010?

I dispise excel formuals but I really love SQL. Is there a way to use MS Query from the command line to generate another excel file or csv with the results of an SQL Querybrun between two sheets ...