Questions tagged as 'sql'

Tagged questions
0
answers

Query in the background? Download time

I have a code that has to show a list of options downloaded from the database through the element. The problem is that this query takes a long time to load (since I have to show more than 150000 records). The code I currently have is this:...
asked by 22.11.2018 / 18:10
1
answer

php show the number of times a relationship appears

Hello very good that such I have a problem in php and I do not want to save the value in the database, I would like to know if you know any way to see the times that appears a relation fingers tables in the database ie I I have a class and anoth...
asked by 22.11.2018 / 17:46
0
answers

How can I create a dynamic array in php

I am working on a system where I have two tables in question .. the first one is wp_prflxtrflds_user_field_data that has saved the departamento, nro de interno y sucursal de un usuario . The problem is that these three data are stor...
asked by 23.11.2018 / 15:20
0
answers

It says that there is no volatile table created in a store procedure in teradata

I'm creating a stored procedure in teradata , where in I created a volatile table that I then call to do a data insertion. I do not know why the volatile table does not recognize me, can you help me? Script: replace PROCEDURE ship...
asked by 27.11.2018 / 21:19
0
answers

Angular 6 - Does not update parent class field in daughter class view

I try to make an api RESTfull with Angular 6 and Java, which must perform the CRUD operations, until now everything seems to work correctly, except to edit and insert in Employee and Auto. The model is composed of 3 tables, Branch, Employee a...
asked by 22.11.2018 / 21:40
0
answers

Connect SQL Server with Macro in Excel

on this occasion I want to request your valuable help. I have a stored procedure with 3 parameters in SQL and I need to create a Macro in Excel with 3 text fields that will feed the parameters. Then, I must collect the result of the Execution of...
asked by 22.11.2018 / 23:38
0
answers

Separate SQL Server counters

My question is as follows I have a calculated column that concatenates a value with the column number to generate the field: CREATE TABLE #Ejemplo ( ID INT IDENTITY, NumeroRadicado AS ('AG' + RIGHT(REPLICATE('0', 15) + CONVERT(VARCHAR...
asked by 21.11.2018 / 22:14
0
answers

how to put 2 tables in sql SELECT *?

I made a mini system to upload photos as profile and cover, but when I put the two includes 1 if it works and the other. If anyone knows help me please I'm a novice in this include ("conexion.php"); $sql="SELECT * FROM 'daniel_banner...
asked by 23.11.2018 / 01:07
0
answers

Run a query every hour with php

I have the following query $query = "UPDATE cat_marca as tabla_c SET tabla_c.precio = (SELECT tabla_c.precio * tabla_b.porcentaje FROM cat_concepto as tabla_a INNER JOIN cat_depreciacion...
asked by 23.11.2018 / 00:01
0
answers

I have several invoices that I made a json from SQL 2017, but I have a problem in the structure

I generate my JSON from SQL 2017 which generates this structure taken from a table. "detalle": [{ "numero": "1", "codigo": [{ "tipo": "04", "codigo": "593" }, { "tipo": "04",...
asked by 23.11.2018 / 00:31