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.

0
votes
0answers
6 views

Which SQL editor can automatically export multiple tables to csv files at once? [on hold]

I have a database hosted on an Amazon RDS server. I am connecting to it via an SQL Editor such as HeidiSQL or MySQL Workbench. I need to export all tables to csv files once a week. However, neither of ...
0
votes
0answers
9 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
31 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
18 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
9 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
10 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
14 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
0answers
47 views

Referencing a cell in an SQL query?

I have a workbook that takes a date the user types in cell A1 and generates a simple SQL query in cell B1 using string concatenation. For example, if a user enters the date 3/1/2018 into cell A1, ...
0
votes
1answer
52 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
56 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
29 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
29 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
53 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 ...
-2
votes
1answer
43 views

How can I make a table_query.sql?

https://github.com/blobmon/simplechan I am going to the street on the above site. Now I am making databases and users. Come out of psql by pressing ctrl + D and also come out of postgres user by ...
0
votes
1answer
24 views

Joining queries in access not working

I have 3 tables Employees(EmpID, FN, LN) Required Trainings(TrainingID, TrainingName) Completed Trainings(CompletedID, EmployeeName (lookup field from Employee), TrainingName (lookup field from ...
0
votes
0answers
103 views

How to see all not answered emails from my colleagues in Outlook 2016?

I look for a solution to set a filter in Outlook's Folder Sent Items to see all not answered emails from my colleagues. Example: I send out 100 emails. Some of the mails have one To person, some ...
0
votes
0answers
103 views

I get “rsProcessingAborted” and “rsErrorExecutingCommand” randomly in my SQL Server Report builder report

I have a report in which I get randomly the following error after pressing the "View Report" button (because in this report I need to select a parameter value from the dropdown field first): An error ...
0
votes
0answers
26 views

Azure and SQL database connections

i looked around for the answer to this question and nothing really seemed to give me a clear answer. Since i need this information for professional use, i'd also rather be safe than sorry. :) Here ...
0
votes
0answers
23 views

How can I insert multiple split string in single insert query

create the following table Declare @APS nvarchar(1000)='1,1,1.5,1.791' ,@cluster nvarchar(1000)='0150,0150,001,0382' ,@style nvarchar(1000)='696707-018,696707-018,696707-018,696707-018' CREATE TABLE ...
1
vote
0answers
223 views

Can't connect to database in SSMS 2017

I used to be able to connect, and now I can't. I have tried uninstalling and reinstalling SSMS. I have not changed my antivirus/firewall settings at all. OS: Windows 10 Home TITLE: Connect to Server ...
3
votes
1answer
374 views

Can not find port in netstat for a specific PID in tasklist

I have trouble finding the port for a running SQL Server (SQLEXPRESS): The command tasklist in CMD shows PID = 3376 for sqlservr.exe. It's the same PID as in the Properties of this SQL Server (...
0
votes
1answer
319 views

Install sqlplus in ubuntu 16.04

I've tried installing sqlplus in ubuntu 16.04 using this link http://webikon.com/cases/installing-oracle-sql-plus-client-on-ubuntu but upon final step it required user-name and password. How do I ...
0
votes
1answer
24 views

Can a Microsoft Access Database save incorrectly if multiple computers are updating the same field?

If I make a program in java that constantly requests and saves data every time you click on a button, and I install this program on 30+- computers, every program will save to one Microsoft access ...
1
vote
1answer
75 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
0answers
56 views

Login failed for user 'sa'

I'm in the process of converting an old sql server (sql 2005) at work. We need to keep the data for 7+ years by law. I'm doing this by using vmware esxi and it worked perfectly other than for the ...
0
votes
0answers
193 views

How to fix in T-SQL for Warning: Null value is eliminated by an aggregate or other SET operation?

I have created the following T-SQL code in SQL Server Management Studio. In this, I am trying to acheive items details from each Customer Management station database which is in remote server 770Main. ...
0
votes
0answers
30 views

SQL Backup Software (VDP) and Log Shipping

My understanding of a SQL restore operation is that a full backup is required as well as all incremental backups performed since. Likewise my understanding of Log Shipping is that it is using a SQL ...
0
votes
0answers
23 views

Getting this error while trying to create a SQL Server

I'm trying to create a local SQL server using the Microsoft SQL configuration manager that I can log into. I'm getting an error:
1
vote
0answers
161 views

Linked Server between Progress database and MS SQL Server management studio

I wish to set up a linked server within MS SQL Server Management 2014 to access my PROGRESS DB. The Linked Server will allow us to update the tables etc and then run our queries off of SQL Server. I ...
2
votes
2answers
373 views

DQL/SQL to Excel - obtain results of multiple SELECT statements in spreadsheet

I wrote T-SQL query that contains few separate SELECT statements. Each SELECT statement returns different number of columns and represents different properties/features, so that I don't want to join ...
1
vote
1answer
173 views

Need to join two excel tables using Id and a time difference

I need to join two databases (Excel tables). Each one has identification card numbers (unique) and time of admission. The main key is the id of the patient. I only want to get the ones with the same ...
1
vote
1answer
843 views

mssql error: The evaluation period has expired

I am trying to install MSSQL on Centos. I followed the article here. I typed the following command to configure mssql to set a password etc. sudo /opt/mssql/bin/mssql-conf setup I got the following ...
0
votes
0answers
21 views

Connecting to Cloud SQL from java application(on-premises)

I am using cloud SQL as my database. I created user in it. I am trying to connect to database from the java application (petclinic). I am running this application on my local machine. I have added the ...
0
votes
1answer
171 views

MS Access unable to set primary key on make table query

I am using MS Access 2016, I've got a table in my database that is linked to an external source through an ODBC connection. Data is come from MS excel. I created Query and linked up to macro. It runs ...
0
votes
0answers
21 views

Remove SQL Instance from list of available servers

I had an instance of SQL installed on a secondary drive. That drive failed and was not recoverable. I recovered the database backups. I then reinstalled SQL. I had to remove the SQL instances from the ...
-2
votes
1answer
25 views

Dump Microsoft Server Configuration server to a text file

I'm looking for a way to dump every configuration from my server to a dump file like a .txt. I see i can do it with the server propierties from the GUI, but i want it to extract it all the info ...
0
votes
0answers
47 views

Inserting large amounts of binary data into SQL Server

I am scripting a few hundred binary files into a table in a MS SQL Server database, where the binary data as such will be entered into one column, and some meta data into others. The files total at ...
1
vote
0answers
29 views

SQL Server Management Studio 2017 Issue Logging in with new laptop

I just bought a new laptop. I installed SSMS 2017 but when I try to login like I used to with my old laptop (putting my computer name as the server) I get this error: Can anyone help me solve this?
0
votes
1answer
33 views

Script for taking SQL DUMP

I am writing the script for taking the sql dump & zipping it. #!/bin/sh DBUSERID="root" DBPASSWORD="XXXXXXXX" BACKUP_DIR="$HOME/daily_sql_backups" DATE=`date +%Y_%m_%d_%H_%M_%S` cd $BACKUP_DIR ...
0
votes
0answers
25 views

How to add default parameters in Report Builder 3.0

I used to know how to do this - but either I've forgotten or else Report Builder has changed for version 3.0 Can someone please explain how to add or change default parameters for a report? ...
0
votes
0answers
139 views

How to link data from DB3 to excel?

The .db3 database download daily data from the web and I need to analyze those data using an excel file. the file I use to set the analysis must be an excel file because I use data coming from ...
1
vote
1answer
24 views

Sql based on dynamic where condition

I have a query, in this there are multiple conditions based on parameter select a,b,c,d from xyz where case p='Closed' then (q-r)=0 case p='Pending' then (q - isnull(r,0) )>0 case P='All' then ...
0
votes
1answer
175 views

How to change edition of SQL 2012 from express to standard

I have a Windows Server 2012 R2 Standard that is running SQL 2012 Express. How do I go about changing it to be SQL 2012 Standard? I have the media (and ISO image) and it is currently mounted. I ...
2
votes
1answer
489 views

Excel - Using SQL command on Power Query data

Using Power Query, I pull in two reports from Salesforce using Power Query > Get external Data > From Online Services. I load them into tables in two different sheets, and then create a third ...
1
vote
0answers
26 views

Rename database dialog box within Excel-2016

See image here>>> ODBC Rename My goal is to change "User Selection for ODBC" to "Sage Login Information" or whatever. I have a few worksheets that I've setup and they all have odd names when the ...
1
vote
1answer
194 views

Azure SQL connection check

I want to build a database connection test for my CircleCI pipeline, this database is located on Azure and I've found out that pinging this server won't work. How can I build a test in my CircleCI ...
0
votes
0answers
52 views

How to use Excel Online to update on-premises database

I am trying to create a scheduling excel spreadsheet to help my team share resources both on a schedule but also to be flexible and be able to adjust that schedule on the fly. So my current plan is to ...
0
votes
0answers
73 views

SQL Query Returning Image

We are trying to get a sql query to return an image. This is a web based application that generates a letter (in word) where we have this element configured in a store template. We have tried the ...
0
votes
1answer
85 views

How comparate 2 sql bash script

I've got 2 SQL files, 1 of them, is a SQLite tranformed data base and the other, is a SQL file to make a secure copy, the problem, I dont know how take this 2 files and comparate them and make the ...
0
votes
1answer
113 views

How do I upload datasets to a Google Cloud PostgreSQL Instance that other users can see?

I have uploaded several datasets to my Google Cloud PostgreSQL instance on the default user account. But when I try to view those same datasets on my second user account, they're no longer there. It ...