Questions tagged as 'sql'

Tagged questions
0
answers

SQL - Read a txt file and separate rows by blanks

Hello friends I am trying to process some txt's that I receive from a system other than mine, I need to take this information and store it in a table within my SQL Server , the question is that my data It comes separated by 2 characters, very l...
asked by 11.07.2018 / 23:36
1
answer

Does anyone know how to connect to SAP tables to develop a web application?

what's up ?? My problem is that I am developing a web application for a company and it uses the 'SAP' program to control all its data. This software has a database with tables as if it were mysql, but the problem is that I do not know how to...
asked by 18.07.2018 / 20:58
0
answers

File opens locally but not on the server

I want to upload a txt file that is already delimited by commas and, when I do the local tests with the following code, it works for me as I expected $databasetable = temp; $fieldseparator = ","; $lineseparator = "\n"; $csvfile='c:/archivos/...
asked by 11.07.2018 / 21:23
0
answers

Double quotes, backslash, replace in sql

a help here, I try to replace double quotes (") with (\") backslahs + double quotes, in the database to be able to take it to JSON, but I do not understand gives me this error Msg 8152, Level 16, State 14, Line 20 String or binary data would b...
asked by 11.07.2018 / 22:08
0
answers

statistic chart google char php

Good I'm doing statistical graph with chart php and google chart. The graph goes well but now I want the values that only come out when I pass the mouse is shown. Now I want the values to be noticed without passing the mouse. I'm doing it...
asked by 19.07.2018 / 19:13
1
answer

How to resolve this SQL query

List name and phone number of drivers who did not drive a vehicle model after the year 2010. WHAT YOU TRY ME SELECT c.nombre, c.telefono FROM chofer as c INNER JOIN viaje as v on c.nro_chofer = v.nro_chofer WHERE NOT EXISTS (SELECT * F...
asked by 16.07.2018 / 02:42
1
answer

How to capture two data AND get lost time?

Hi guys, I have a question a bit urgent and I will present the case so you can understand me try to be as clear as possible, I have a database connected to a PLC that gives me the speed of 3 machines with the time and the date of that spee...
asked by 10.07.2018 / 17:10
2
answers

Help creating a function in PostgreSQL that inserts datps in columns with a delimiter character

I have a table with characters Name, Aepllido, Cedula and Date of Birth, and I receive a series of sentences similar to Luis*Lopez*273982*24/12/1998|Juan*Gonzalez*232234*03/12/1987|Julio*Perez*274234*03/12/1995 I want to be able to delimit...
asked by 10.07.2018 / 17:57
0
answers

SQL pivot, concatenate during the pivot

I'm trying to concatenate the data after the pivot select [ARC_ID] from (select [MTD_ID],[ARC_ID],[MET_ARC_VALOR] from [dbo].[TB_BGP_METADATA_ARCHIVO]) as SourceTable pivot(MAX([MET_ARC_VALOR]) for [MTD_ID] in([1],[2],[3],[4],[5],[6])) as P...
asked by 09.07.2018 / 23:24
1
answer

Help with a SQL query, sums

I'm doing an SQL in which I want to add whose product is similar that is. I have my sql, I attach them to you. select distinct cat.Nombre as Categoria, pro2.Nombre as Producto, InventarioInicial, ocd.CostoUnitario from Inventario as inv2 in...
asked by 12.07.2018 / 19:04