Questions tagged as 'sql'

Tagged questions
1
answer

Query is printed on a single td

I have a table which reflects a purchase made by a client or buyer, which has an identifier that would be the number of the order, it reflects that the customer requested, but it shows me in several tds the data of the order use a group by but i...
asked by 11.09.2017 / 03:19
1
answer

Sum of rows in Oracle PL / SQL

I want to add these two amounts but I get two different rows because they are unequal the amount should give me "2231" and a single row: MONTO NAC CEDULA CODIGO SUBCODIGO FISCAL FECHA 1673,25 V 8018573 28 50 2017 11/05/17 557...
asked by 13.09.2017 / 00:28
1
answer

How do I insert an image from VB.net to Sql?

How do I insert an image from VB.net to Sql? That's the way I'm using to save the other data cmd2.CommandText = "insert into trabajadores (sueldo, acceso, login, password, estado) values ('" + txtsueldo.Text + "','" + cmb...
asked by 19.09.2017 / 19:22
1
answer

Make fields of different tables appear in forms and queries

What I would like to do to help you understand better is the following: I have a client table with the following fields: IdCliente int not null primary key auto_increment; Nombre varcjar; Apellido varchar; Direccion varchar; Telefono varcha...
asked by 16.10.2017 / 04:13
1
answer

Condemn WHERE with a Subselect - SQL

I can not show the requisitions that have their status in NULL. Query principal that brings requisitions associated with "X" data: SELECT re.[codigo] AS codigo_requisicion FROM [Control_Documental].[dbo].[Requisicion] AS re LEFT JOIN [Cont...
asked by 28.09.2017 / 15:39
1
answer

How to call the value of a jComboBox?

I do the following query to add elements to the comboBox: cmbCargo.setModel(obj.LlenarCombobox("costo", "SELECT * FROM tipoServicio")); (The first value is the field that is shown in the query) Using this method public...
asked by 31.08.2017 / 02:59
2
answers

Problem with complex PostgreSQL query

Please, I need help with a query in PostgreSQL The query is as follows: SELECT DISTINCT("ventas"."Product Category") AS "Categoria de Producto", (EXTRACT(MONTH FROM "ventas"."Order Date")) AS "Mes", "ventas"."region" AS "Región", "ventas"."...
asked by 03.11.2017 / 09:52
1
answer

separate SQL field

I have the following table with the following data select * from archivo_final cs_promocion 3 d_promocion DSCTO NESPRESSO st_promocion A fecha_desde 2017-07-04 fecha_hasta 2017-12-31 almacenes 109,111,1...
asked by 02.11.2017 / 17:19
1
answer

Convert Row to Column SQL server query

Good morning, I need to transpose or change the result of a table in the following way: The structure of the table is 5 columns (description of users, permission1, permission2, permission3, permission4) the description field is varchar...
asked by 31.08.2017 / 19:01
1
answer

Return a value of a SQL Server SP working with DATASET in VB

Good morning, I have the following case, I am working with dataset in visual basic, having an SP in SLQ server which returns a query, but add a parameter to know the number of records to return, to make a validation in SQL Server works well for...
asked by 28.08.2017 / 22:29