Questions tagged as 'sql'

Tagged questions
1
answer

Ormlite Inner Join in five tables

I want to create some JOIN in five tables like this example: SELECT * FROM TableA AS TA INNER JOIN TableB AS TB ON TA.Id = TB.IdTA INNER JOIN TableC AS TC ON TB.IdTC = TC.Id INNER JOIN TableD AS TD ON TC.Id = TD.IdTC INNER JOIN...
asked by 11.04.2014 / 14:05
1
answer

Call Function or Procedure Several Times

How to create a Function or Procedure that calls another Procedure to perform a neighborhood change in my ERP system? Follow the procedure below I want to set values for the parameters of it. It should be called based on a neighborhood table...
asked by 09.04.2014 / 22:05
1
answer

How do I insert into a ternary relationship?

I am creating this template yet I do not know if it is correct. Because I have basic knowledge in database. How do I insert into a ternary relationship that happens in Supplier - Suppliers_has_product - Product?     
asked by 22.03.2014 / 14:42
1
answer

Batch calling "dtsx" does not connect to Avaya CMS

I created a service in dtsx that needs to connect to CMS Avaya . It turns out that when I squeeze it through Visual Studio it follows the process to the end normally. But when I call a batch it does not allow authentica...
asked by 04.04.2014 / 16:18
0
answers

Query Sql to provision bank balances

Good afternoon, I need to set up a query that calculates for me in a column the current balance by deducting the amount to be paid and adding the amount receivable, thus: balance_residual = (receive - pay + bank balance) I have three source tabl...
asked by 04.01.2019 / 20:07
0
answers

Different Value - Oracle Query

In the query below in column Valor_Total_da_Ordem it is giving a totally different value, much higher than it actually was to be. The value is giving 55990,62. Being that the correct value is to be 1333.11. What could have happened?...
asked by 27.12.2018 / 12:33
1
answer

SQL CE Database Insert Error

I am creating an application for a PDA, how much do I try to do the data insertion in the database I always encounter this error.    There was an error parsing the query. [Token line number = 1, Token line offset = 100, Token in error =)]...
asked by 28.02.2014 / 14:18
0
answers

Blank comparative filter in Power Bi

Hello, I created two filters to make a comparison by duplicating the facts with the records for the measurements and the tables that make the filter with the proper relationships. However, for some reason, when filtering through a specific filte...
asked by 20.12.2018 / 13:36
0
answers

Database connection failure: SQLSTATE [HY000] [2002] No such file or directory

I'm having this error in MySQL when I try to connect. Everything works perfectly when run by localhost, but when run by hosting, this happens: SQLSTATE[HY000] [2002] No such file or directory I changed the address, password, bank name ... A...
asked by 20.12.2018 / 02:47
1
answer

Making temporary table comparison

Good morning, I have questions on how to perform a comparison between a temporary table and a database table. What I want to return is, among all the data in the temporary table, it returns the ones I have in the database (null) and the ones I d...
asked by 14.12.2018 / 13:47