Questions tagged as 'sql'

Tagged questions
2
answers

Problem receiving data from form with ajax

Edited: With trim I "fixed" the spaces (I would like to know why the values are arriving with spaces: /) but I could not fix the problem with the + symbol. I will formulate my question that I asked previously like this: I have a tab...
asked by 01.02.2017 / 01:19
2
answers

Query dynamic?

I have the following query: select CONCAT('PtdBal',(select right(substring(PerNbr,5,2)-1+100,2) from SLApplication.dbo.GLSetup)) from SLApplication.dbo.AcctHist where substring(Sub, 16, 6) = '189621' and acct like '822%...
asked by 01.02.2017 / 00:46
2
answers

Concatenate data of a user and print them only once

I'm working on scriptcase and managing pdfp to generate reports, but I have a problem. I try to print the user's data in a single line, for example: id ------nombre----------------- datos --------------fecha1 -------fecha2 1 ------ david p...
asked by 15.12.2016 / 19:51
1
answer

Help with Oracle SQL query 11g

I need to make two queries in sql, but I'm stuck in one part, I explain. The first query asks me the following:    You want to know by customer: The total of invoices made in the month, the total value of purchases made in the month, the v...
asked by 20.04.2017 / 01:49
1
answer

UPDATE with INNER JOIN in Mysql

I have this database schema for an electronic calendar. I have a table of events and one of equipment which is a many to many relationship. Once an event is deleted, I need to change the status of the equipment (eg, projector, notebook, point...
asked by 13.12.2016 / 13:49
3
answers

Consult two tables and use of min ()

We start with two tables: Aminales: ID_animal, nombre, especie, incenter 1 Toby 2 1 2 Micke 2 1 3 Jake 2 1 4 Tom 2...
asked by 19.11.2016 / 20:53
1
answer

Export packages with "dbms_metadata.get_ddl"

I am exporting packages using dbms_metadata.get_ddl . For example: select dbms_metadata.get_ddl('PACKAGE_BODY','NOMBRE_PAQ','SCHEMA_NA‌​ME') from dual; But when generating the spool with the package code, a blank line is generated bef...
asked by 28.11.2016 / 15:15
1
answer

Error using openrowset

I have a problem regarding openrowset . I am running the following encoding: SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=C:\Procesos\PRUEBA.xlsx', [Hoja1$]) and I get the following error:    The O...
asked by 04.11.2016 / 23:44
1
answer

Separate Bill Receipts

I am in a situation where I need your help, I have a sales system made in Javafx (well it is more like a CRM), the fact is that in one of the modules is a billing or sales system, what happens is that for legal issues I have to correct or redo s...
asked by 05.11.2016 / 21:35
1
answer

Run trigger (Sql) for multiple fields

I am working on a sales system for food sites with c # and SQL. I have created a trigger that decreases the stock when a product is added to the sale. Each product (plate) is related to a table that stores the ingredients and how many of them ar...
asked by 20.12.2016 / 05:13