Questions tagged as 'sql'

Tagged questions
1
answer

Error System.Data.SqlClient.SqlException (0x80131904) Error Form with sql [duplicate]

I want help with a small error that is giving me a program that I am doing for my class, it is a small program of a hardware store where products are kept, clients (in order that if it is a distributor to apply a discount), types of product...
asked by 26.08.2016 / 04:07
2
answers

Select the immediate minor SQL [duplicated]

I need to ask a question in mysql where I have two sales and purchase tables these have the date field and I want to take c.fechacompra < v.fechaventa The problem is that I have many purchase date less than the date-of-sale and th...
asked by 07.07.2016 / 06:48
3
answers

SQL query to get the purchase price before the sale

I have a database (attached BD open BD to import ), in where I want to get a report in which I take out the sale list of each product in invoices, showing how much I sold it and how much it cost me. The problem is that the query I get: SELEC...
asked by 07.07.2016 / 15:48
0
answers

Help with error in process stored in sql

Good afternoon, I come to you to see if you can support me with a problem when running a process stored in sql and pass an input parameter I skip the following error:    com.microsoft.sqlserver.jdbc.SQLServerException: The error descri...
asked by 05.07.2016 / 01:51
1
answer

how to group the amount billed per currency (currency rate) and per month?

I have the following query: select sh.CurrencyRateID, cr.ToCurrencyCode, sum(TotalDue) as [cantidad facturada], month(OrderDate) as mes from sales.SalesOrderHeader sh join sales.CurrencyRate cr on sh.CurrencyRateID=cr.C...
asked by 26.06.2016 / 04:21
0
answers

Error Unknown column 'undefined' in 'where clause'

Good morning, I have a table created through java code. The table is created without any type of error, but when I go to MySQL and pulse 2 times on any cell, it shows me a popup that indicates Unknown column 'undefined' in 'where clause'...
asked by 24.02.2017 / 21:40
1
answer

"SQL Server" Server Error "DELETE" and "INSERT" from Excel

I have created a procedure that first deletes the records from my table and then imports them from excel. DELETE tabla WHERE columna='dato' INSERT INTO tabla SELEC * FROM OPENDATASOURCE ('Microsoft.ACE.OLEDB.12.0', 'Data Sourc...
asked by 19.10.2016 / 23:32
1
answer

Delete record with same value in different column only once

Good morning, in a trigger for insert I need to delete all the records that have a value greater than 0 in vat and at the same time delete one that does not say vat of the same client and same rut. (Does not have primary key) EJ: Cliente...
asked by 23.03.2016 / 13:31
1
answer

Modify URL to download report

I am using SQL Server Reporting Services (SSRS) and I want to download a report without the need to access the server to see the report, but automatically download the report on the user's computer. I want to see the possibility of m...
asked by 20.07.2016 / 17:29
3
answers

How to get the number of subsequent records in sql statement?

I have a table where I keep comments on topics: Id, id_tema, id_autor, comentario, fecha I need to ask a question that returns the number of comments after a certain comment on the same topic. The data I have is the Id of the comment, I hav...
asked by 20.11.2018 / 18:14