Questions tagged as 'sql'

Tagged questions
0
answers

Consultation in the Moodle bank in order to bring the number of students approved in a certain course

I need to create a script that searches the bank of Moodle for the number of students approved in a given course and the number of students dropping out, I ask the help of experts about the Moodle bank schema for a path in order to assemble my q...
asked by 18.10.2018 / 16:23
0
answers

(SSIS) For Each Loop Container can not find file

Hello. I need to mount a task in SSIS that finds a CSV file in a folder on the network and imports that file into a table. It looks very simple, but the detail is that the directory changes name every day, with the mask Z: \ Folder \ Year \ Mont...
asked by 23.10.2018 / 17:15
1
answer

I'm having a doubt on the text_input of kivy + sql

Hello, I'm trying to make a registration page and I'm doing some tests in this code, for example, I'm trying to make it when I enter a name in the user field and press enter save this data in SQL but it is giving error, could someone give me a li...
asked by 25.10.2018 / 15:49
2
answers

SELECT Cursor using top1

I need to return only the highest value of one of the lines below, taking into account that I also need to submit the order code. I tried to run via cursor but without success. By the cursor would pass the 3 lines, but would need to con...
asked by 25.10.2018 / 23:42
1
answer

File import into SSIS with columns in different positions each day

I have the following situation: I import a Flat File from a * .CSV file into a table in the database. Using SSIS in Visual Studio. However, each day the file I receive has the order of the columns changed. Thus, the "e-mail" field, for example,...
asked by 15.10.2018 / 17:12
1
answer

Filter with SQL query from a combobox - c #

I am creating a stock program and would like the query of items to be filtered by a combobox, ie, when typing in the search field only the results regarding the parameter of the combobox appear. This is my SQL query code: DataTable tabela =...
asked by 12.10.2018 / 21:54
2
answers

Case in Sub Select SQL SERVER

Good afternoon, I'm having trouble making a case in a subquery. I need to bring an information called the order_id from the sf_vendas_boleto table, however when it comes NULL I need to bring the order_id from the sf_vendas_online table. Fo...
asked by 18.10.2018 / 20:18
0
answers

MySQL - LOAD DATA INFILE with conditional

I need to import txt file into a table where the data is structured by fixed column, that is, the TIPO field is identified by the first 2 digits of the record, the CBO field from 3 to 8 , and so on. The TIPO field...
asked by 22.10.2018 / 00:52
1
answer

Search without special SQL characters

I need to do a search with SELECT, but the title is not displayed, because some calls that are opened come with special characters. Can anyone help me? I use this command to search the database: SELECT id,titulo,data FROM gl_data WHERE stat...
asked by 15.10.2018 / 22:00
1
answer

How to fill combobox with SQL query? W#

I would like to know if it is possible to pass data from an SQL query to a combobox using C #. I researched the subject and found examples, but when I adapted to my case, I could not use it. I'm doing it this way: private void carregacombo() {...
asked by 10.10.2018 / 04:21