I have the table tableA and tableB .
I'm making a select of all fields from both tables by joining them together with left Join
select * from tableA
left join tableB on tableA.id = tableB.id
But the relationship is...
Hello everyone. I'm running the query below and it is displaying the error: "Operand type clash: int is incompatible with date".
My intent when performing this query is to validate if the ORIGINAL_ORIGINAL field is a valid date, and if so, va...
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...
I have an application, which performs the API tests by postman.
Debugging the app, the test goes through all my layers and returns: 'status: 200 ok'. However, the object is not inserted into my table. I have tried to map a request to the Sql...
I have a SQL database with two tables. One of these stores measures created ( table 1 ) and the other actions of these measures ( table 2 ).
I inserted a datagridView with the data in table 1 and created a column named " SITUACAO...
I have the following situation:
In the same form, I enter a student:
SqlCommand inserirAluno = new SqlCommand("INSERT INTO ALUNOS (Nome, DataNascimento, CPF, Endereco, Bairro, " +
"CEP, Cidade, IdEstado, Sexo) " +...
Problem
I need to generate a report usage LOG with the user, report name, date of use, and selected parameters. Most of the fields were obtained using the Built-In Faithful . However, I can not get a string with all report parameters ( nam...
Good evening, I'm new to SQL and I have a question.
I have the following database:
Mygoalistopresentthenamesoftheemployees,theirroleandthenameofthedepartmentwheretheywork,havingtobetheresultorderedbythenameofthedepartmentandwithinthedep...
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...
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...