Questions tagged as 'sql'

Tagged questions
0
answers

How to perform an Update in Mysql with Subqueries?

Cordial Greeting. I am currently developing an academic project for a restaurant system, but I have several days stuck with a problem, I hope you can help me, first these are the relationships of the tables used: What I try to do is...
asked by 25.03.2018 / 16:40
0
answers

Generate Excel Reports in Automatic

I have a big problem, I am generating an application that generates certain reports in excel, I have some formats that I develop, the problem is that I do not know how to fill them automatically according to a selected value (Example: if I selec...
asked by 27.03.2018 / 18:30
0
answers

Error with Insert MSSQL, PetaPoco and C # (WPF)

Good morning, I am developing a desktop application using WPF, in visual Studio 2017 ; and I'm using the PetaPoco library for CRUD with SQL. I would like to know if you could advise me in this case, since I do not find much information on...
asked by 30.03.2018 / 20:11
1
answer

Change result SELECT by sequential

I have the following query: SELECT DISTINCT N.SNUMERO, I.SNOMBRE, S.SSERVICIO FROM PROC_CEDULA CD JOIN CAT_NUMINTERV N ON CD.NIDCATNUMINT=N.NIDNUMINT JOIN CAT_INTERVENCIONES I ON CD.NIDCATINTERVENCION=I.NIDINTERVENCION JOIN CAT_SERVICIOS S ON...
asked by 21.03.2018 / 19:45
1
answer

I get an error when logging

The error that it gives me is when trying to access apanel.php sometimes it accesses and sometimes it does not, I think it's thing of the sessions but I'm not sure. PHP: <?php session_start(); include("cabecera.php");...
asked by 21.03.2018 / 14:56
0
answers

Changing the format when exporting Datagridview to Excel

I have the following code to export to Excel, from my Datagridview. Private Sub EXPORTARToolStripMenuItem_Click(sender As Object, e As EventArgs) Handles EXPORTARToolStripMenuItem.Click Dim exApp As New Microsoft.Office.Interop.Excel.Appli...
asked by 22.03.2018 / 13:59
0
answers

Auto-incremental secondary field in SQL Server

good day! I do this thread because I'm working with a transformer database The subject is the following, I have something like that .. Table Transformer *Código comercial 1º Cliente 1º Nota de venta Fecha de diseño Norma etcetera...
asked by 22.03.2018 / 14:44
1
answer

Problem loading a table with SQL data in c #

I'm creating a web page and I want to show a table with saved data from that same table on a SQL server. For now I have this: public partial class historyTable : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e)...
asked by 19.03.2018 / 21:04
1
answer

Print document saved on server

I am creating a web page where users can upload files ( exel or word ) and save them in a SQL server and then others can see those files and have the possibility to print them. The truth is that I am having problems to create a method that allow...
asked by 18.03.2018 / 15:32
0
answers

Relations in SQL

I recently had a question with my teacher in databases that could not solve, I would like to ask what is the best way or what is the appropriate way to solve this problem. As you can see in the photo I have the tables Clientes and H...
asked by 16.03.2018 / 04:10