I have a .NET Windows Forms application that connects to a SQL Server server directly, without the use of an intermediate layer like a WebService > or WebAPI , by SqlConnection . This application is installed on the client's compute...
Good Night Personal,
I'm developing an application that makes a relationship between a Player and one or more games (online games), the problem is that a game can have a one more different skills, I wonder if you have a way to leave the new d...
I'm trying to group the rows by group in sqlserver and as a result I want to:
CICLO | CODFIL | CODITPROD | ROW
1 | 1 | 10 | 1
11 | 1 | 10 | 2
12 | 1 | 10 | 3
1 | 2 | 10 | 1
11...
I have the following query:
SELECT finempe.data_empenho
, finempe.num_empenho
, finhisem.quantidade
, finhisem.historico
, finhisem.valor
, finhisem.valor_total
FROM finempe
RIGHT JOIN finhisem ON
(finhis...
Can anyone tell me why the result of the query below is bringing the Balance to zero in the first 4 records? I'm calculating the inputs plus the outputs. Calculates correctly if there are values in the two columns, but when there is no value in...
I am trying to create a query in SQL Server to know if the city that was filled at the time of registration that the person did, is equal to a city field of another table that already has all the municipalities of Brazil, how can I do This?...
In SQL Server connection strings I usually see the options Integrated Security and Persist Security , what does each mean and what values can they receive?
This question came to me by seeing the comments of the following questio...
I have a DataContext set in a CartesianChart that does not display data ... no error is displayed, just guess I am making wrong use of the DataContext and I can not fix it, I'm using the LiveChart-WPF package
Xaml:
<lvc:Cart...
Hello, I would like to know how to do this query: "Search for the names of the patients who had more consultations in January 2016."
select * from PACIENTES
select * from CONSULTAS
These are the photos from my table
I need your help,
I have a query in my system, which has 4 cases
SELECT TOP 3 * FROM (
SELECT Title, SUM(Count) AS Count
FROM (
SELECT
CASE WHEN EstadoId = EstadoIdAutor AND EstadoId = Meddoc1 AND Estado...