Questions tagged as 'sql'

Tagged questions
0
answers

Delphi sql using coalesce

In delphi I have TIBQuery: select * from TB_PRECO where coalesce(DT_CAMPANHA,'') = coalesce(:DT_CAMPANHA,coalesce(DT_CAMPANHA,'')) and coalesce(DT_VECTOPRECO,'') >= coalesce(:DT_ATUAL, coalesce(DT_VECTOPRECO,'')) and DESC_GRUPO = coalesce(:...
asked by 23.03.2018 / 20:53
1
answer

Join Names in a row

Good afternoon, we use SQL SERVER 2008 as the official database server and have the following query: SELECT P.NOME AS [PROFESSOR], STIPOCURSO.NOME AS [NÍVEL DE ENSINO], SPL.CODPERLET AS [ANO], ST...
asked by 05.04.2018 / 19:45
0
answers

Persist data in related tables (1 x N)

I have these 2 related classes, and the requested class has a Collection of "OrderItems" ... The Order class: public class PedidoDTO { public int pedidoID { get; set; } public int codigo { get; set; } public Date...
asked by 18.08.2018 / 22:16
4
answers

Select first name?

I have a table with the following names: João Goldy Alfredo, Gaby, João Antônio, Rodrigo, Maria Aparecida, Mario How can I get them to get their first names, and those who do not have a last name, should show anyway. What I've tried:...
asked by 27.06.2018 / 01:08
0
answers

Data does not send to the database [closed]

So, I created a CRUD class, the code is not returning any errors, but it is not being inserted into the database. I've tried to clean it in many ways, but I can not find a way. CRUD.class.php class CRUD extends Connection { pri...
asked by 25.01.2018 / 14:51
1
answer

Search ip via sql

Does anyone know if there is a way I can search via sql (firebird) all the ips that are using a Table or Views? I'm trying to update a view, however I'm trying the following error: This operation is not defined for system tables. unsuccess...
asked by 04.01.2018 / 11:26
1
answer

Show NULL SQL values [duplicate]

Good evening, I'm new to SQL and I have a question. I have the following database: Mygoalistopresentthenamesoftheemployees,theirroleandthenameofthedepartmentwheretheywork,havingtobetheresultorderedbythenameofthedepartmentandwithinthedep...
asked by 11.10.2018 / 22:43
1
answer

Error Running Report in SQL Server Reporting Services

The following error is occurring when you run some Reporting Services report:    "Error in report processing. (rsProcessingAborted)   create a connection to the 'Production' data source.   (rsErrorOpeningConnection) A network-related or insta...
asked by 05.10.2018 / 13:36
3
answers

SQL searching for records from a Date and Time

I have the following SQL: select * from tb_valores where DATA >= '14/12/17' and HORA >= '16:34:00') I would like to bring all records from that date and time. The problem is that if I have records like: '14/12/17' '10:20:00' '14/...
asked by 15.12.2017 / 20:20
2
answers

GROUP BY with 2 Tables

I need to do a select with JOIN on two tables but I can not group to not repeat the rows. Here is the SQL expression: SELECT Andamento.NumeroProcesso, Andamento.Chave, Andamento.Codigo, Andamento.DataAnda...
asked by 24.11.2017 / 13:54