Questions tagged as 'sql-server'

Tagged questions
1
answer

error in SQL server in query to a linked server

Good afternoon, I have linked sqlServer with PostgreSQL, the connection is successful, I can see the databases that I have in PostgreSQL except for the database tables, otherwise it is when I want to access the tables in the database that comes...
asked by 28.09.2017 / 22:41
2
answers

Condition called null data, from a subselect - transact sql

I need to see purchases that do not have a nombre_etapa associated with it. I leave the code: SELECT re.[compras] AS compras, ( SELECT e.[nombre] as nombre_etapa_e FROM [Control_Documental].[dbo].[Registro_Etapa_Documento] AS e ) as...
asked by 28.09.2017 / 05:55
2
answers

Xampp SQL server 2014 PHP 7.1.9

I have a xampp running with PHP 7.1.9. I use the sql server 2014. But now I need the drivers for PHP. I can only find a version that supports 5.5, 5.6 ... ( link ) Is there a way to let this work with PHP 7.1.9?     
asked by 27.09.2017 / 10:08
0
answers

How to improve the speed of this query in SQL Server?

I have a query that is very slow and I wanted to see how it can be improved. Currently there is an installed SQL SERVER 2008 R2 express edition the query is this select top 9999999 albfacca.can,albfacca.ejealb,albfacca.numalb,albfacca.fec...
asked by 18.10.2017 / 12:10
1
answer

Link PostgreSQL and SQL server express 2012

Good afternoon, I would like to know if it is possible to link my local database (PostgreSQL) with SQLExpress 2012 (I am downloading to install). The same tables that I have in PosgreSQL have them in SQLExpress 2012, if I add a data in SQLExpres...
asked by 20.09.2017 / 21:19
0
answers

Display in JSON format data from a database in SQL Server 2008 (AngularJS)

I need your help in the following please: I am using AngularJS, I have a database in SQL SERVER 2008 are more than 5 thousand records that I have per table, what I want to do is bring all the information through JSON and show it, to be able t...
asked by 13.09.2017 / 19:16
1
answer

How to remove percentage in sql server

this is my query porcentaje = isnull(( select sum(x.valor)*100/(select sum(ccc.Valor) from CuentasPorCobrar ccc) from CuentaCorriente x where x.Detalle like 'Pago%'...
asked by 28.09.2017 / 18:21
1
answer

SQL Server - Insert record block to a table with data from other tables

Good morning, I hope you can help me since I am just beginning to apply in what is SQL Server, I am working in a system of worksheet and I wanted to know how to insert in a table (Template.dbf) some data of the table (worker.dbf) plus some other...
asked by 01.09.2017 / 17:44
3
answers

Update with a value the record in LEFT JOIN

Good morning ... I have this query select Numeros.n ,coalesce(Numeros.IdPaciente, datos.IdPaciente) IdPaciente, FechaAnalitica,GlucosaPre,Sodio,Calcio from Numeros left join ( select ROW_NUMBER () over (order by IdPaciente asc) Row#,...
asked by 01.09.2017 / 20:54
0
answers

It is possible to calculate the average in the availability column

I would like to know if it is possible to add the availability and divide it by the number of teams to obtain the average of availability (Availability) The Query is as follows: DECLARE @StartDate DateTime DECLARE @EndDate DateTime SET @Sta...
asked by 29.08.2017 / 22:08