Questions tagged as 'sql-server'

Tagged questions
1
answer

Using JOINS in SQL Server

for today I have a challenge is to make queries in SQL Server with the use of JOINS, if someone can help me it would be great the truth I do not know about the subject and I'm just depending on creating a database with some tables ..     
asked by 23.06.2017 / 17:51
1
answer

Limit sql server field

I have the following table with the password field that has to be limited to 6 neither more nor less, I tried with the modifier check but only assign it numbers or letters, there is some way to limit it to 6 but they can be any of the 2 things?...
asked by 05.09.2018 / 22:33
1
answer

Delete a record having related tables

I need to delete the idcliente , nombre and apellido of the table cliente , but it will not let me delete it because it is related to the ubicacion table. For that, I also want to eliminate all records of that cl...
asked by 01.12.2017 / 15:36
1
answer

problem with DISTINCT SQL [closed]

I have this query that shows me several records with the same name, I just want the Variable Name to appear only once for the repeated records, I know that it is with DISTINCT but it does not do anything SELECT DISTINCT IDVariable...
asked by 08.05.2018 / 23:36
2
answers

Error installing SQL Server: the required package SqlSupport.msi does not exist

I am installing SQL Server 2017, but when it reaches the ready to install step ( Ready to Install ), I receive the next problem :    Error: The required MSI package 'C: \ Developer \ Dev \ 2058_ESM_LP \ x64 \ setup \ SqlSupport.msi' does not...
asked by 18.05.2018 / 21:35
1
answer

Consult IN Clusters [closed]

Good look here I have a question, because I have an Employee Table and a Sales Table, and for sale I have types of documents (Invoice Bill, etc), then the query I want to make in Sql Server 2014 is that I list the employees and show me the numbe...
asked by 05.10.2018 / 05:16
1
answer

In a query add data only to the first data obtained - SQL

I have a table with X number of records, but I'm interested that only the first record can be given an extra data, this can be by identifier field , that is, the smallest identifier, this only in order to identify which was the first record to...
asked by 21.05.2018 / 18:05
2
answers

Avoid repeated data entry? [closed]

I am creating a reservation system for medical appointments, but I do not know how to program that the user can not enter an appointment at a time that is already saved. I would greatly appreciate your help     
asked by 10.12.2018 / 03:05
1
answer

SQL sum of sum totals

I would like to help me. This time with a summation of sum totals of other sums. The error tells me that:    The sum function requires 1 argument. Something about the code: select colum1 as Total, colum2 as Co,...
asked by 10.12.2018 / 15:04
1
answer

Create a query that does not duplicate data in SQL SERVER [closed]

Good afternoon I would like to know how to make a query that would come out something like this SELECT Paciente= HC.IdPaciente , Fecha_Adm = CONVERT(char(10), E.FechaAdmision, 101), Activo = CASE WHEN E.Estado = 'Activo' THEN...
asked by 30.10.2018 / 20:28