Questions tagged as 'sql'

Tagged questions
1
answer

Problem when creating a job in SQL Server

Consulta I hope you can help me. I told you to create a JOB in SQL SERVER 2012 but within that JOB I created 3 steps as the image: what happens when I want to save I get that error:     
asked by 08.03.2017 / 18:50
1
answer

INNER JOIN in Update

I am migrating an Access query to SQL Server, the problem is that in Access it allows to perform INNER JOIN in the UPDATE UPDATE (Aux_Nodos INNER JOIN Nodos_NULL_Titular ON Aux_Nodos.Necesidad = Nodos_NULL_Titular.Necesidad) INNER JOIN Out_Arc...
asked by 13.02.2017 / 16:38
1
answer

Update number every hour with setInterval [closed]

For now I have only been able to do this code var time = 1; var myInterval = setInterval(funtion(){ time += 1; },3600000) }); I need a div, each time the number is increased after one hour, <div id="time">1</div> The pr...
asked by 13.02.2017 / 19:16
1
answer

LIKE BINARY in MySQL

I want to select a set of results that, passing the option by like, but the result can be that it is lowercase or capitalized. I did this way: SELECT * FROM DocumentosAux WHERE numeroDocDisco like binary 'pbra'; Also: SELECT * FROM Docum...
asked by 14.02.2017 / 15:31
2
answers

Put a sum in the filters of a SQL query?

Good morning, I'm scheduling this query: SELECT t1.percod permisor, t1.pernom ciudad, t2.abocod cod_abonado, t2.abonom1 nombre, t2.aboape1 apellido, t2.abosts, t2.abocmsts, t2.abotlfsts, t2.aboipsts, t3.recicod, t3.recifch...
asked by 02.02.2017 / 14:13
3
answers

Group SQL SERVER records using Distinct and Case

I am trying to perform the grouping of records of two tables using the following query: select distinct detrec.iddestino, --sum(DetRec.NoBulto) as [Número de Bultos], sum(DetRec.Peso) as [Peso], case when enrec.OrigenEnvios=detrec.iddestin...
asked by 19.01.2017 / 15:24
4
answers

Consultation with Inner Join

A few days ago I asked a question to get data from a database linking several tables with **INNER JOIN** . Now I'm trying to mix the INNER and the COUNT but I do not know how to express it. I have these tables. Table...
asked by 03.05.2017 / 11:22
2
answers

Select the record with the highest value within a JOIN

I have a procedure with SELECT with several JOINS and, in one of them, I need to extract only one result (the most recent date) when several results can really be given. In principle, the dates will never be exact since it is stored in...
asked by 23.01.2017 / 16:37
1
answer

Query whose result includes a field that is the result of another query in mysql

I have a table of people that has the following fields, among others: +----------------------------+ |persona_id | persona_nombre | +-----------+----------------+ | 1 | persona 1 | | 2 | persona 2 | +-----------+-----...
asked by 04.01.2017 / 18:32
1
answer

SQL Server 2008 R2 do Update in different Like

Many of us already know that (Like '% search%') serves us in sql server to search for keywords in this opportunity I have to do this: UPDATE Table SET a.ItemID = 1000, a.type = 1, a.typeID = 0 FROM PS_GameData.dbo.CharItems a INNER JOIN PS_Gam...
asked by 05.01.2017 / 15:05