I need to display this:
So:
Following the link's instructions:
Using the PIVOT operator without aggregation
I can not place a subquery inside the IN in PIVOT
Dynamic Pivot with SQL Server
I came to this script:
create t...
I have the following table:
Nome | Posicao
Item1 | NULL
Item2 | NULL
Item3 | NULL
I would like it to look like this:
Nome | Posicao
Item1 | 1
Item2 | 2
Item3 | 3
Sorting criteria is Name
I want to pick up some date 60 months ago.
I'm in a project that shows only files Sent to 60 months, but 60 months rather than 5 years, may not make any difference.
Any ideas? I tried to use datediff, but I'm not successful. I want to do t...
I put the jar and did the build path. I've been trying for some time to connect to the microsoft bank but it gives this error:
Exception in thread "main" java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Falha na...
I would like to know how to set an insert pattern in a column in SQL.
Example:
CREATE TABLE XPTO(
ID INT IDENTITY(1,1),
NOME VARCHAR(100) NOT NULL,
ATIVO CHAR(1) NOT NULL)
In this case, I want to limit the ACTIVE fie...
I have 2 SQL Server databases in my SQL Server Management Studio.
I would like to put a password in one of them, making it impossible to access it, is it possible?
The client does not have a server (Windows Server or Linux) and does not want to host the system in a data center or in clouds for example, and wants to use the system on an intranet.
At the moment 3 employees will use the system being deve...
I am trying to perform a query in SQL. Here is the method:
public void excluirVenda(int Codigo)
{
Conexao conexao = new Conexao();
SqlCommand cmd = conexao.CreateCommand();
SqlTransaction transaction = null;...