Hello, I have a system developed in Classic ASP, in which I select up to 5 times on a screen.
These times are sent to the other page via querystring, however the next format is followed by an exclamation. Example 7, 10.19.
What I need is to get...
I have a lot of research on how to set up a query in sql server but I have not been very successful.
First, I have a system that controls an industrial courtyard in which there are organizational levels and I have the structure that has the n...
I'm creating a Budgets form, similar to this one in the photo:
As you can see, in the New button, you generate a new row in the bank with the budget number in the Código field and the client in the NomeCliente field. But whe...
I'm doing a conversion on some bd objects where they have a fixed database name.
Example:
select * from banco.dbo.tabela ...
In this case, we are exchanging this banco fixed, with a variable that contains the name in each database...
I have two tables, questions and answers, and I would like to update them according to what is selected: Bank Sql Server 2005
Problem:
--usuário excluindo a pergunta (não está gravando a data da exclusão é não está excluindo as perguntas)
u...
When I run the following Procedure, SQLServer gives the error:
error Must declare the variable scalar "@VDIAPARALISADO".
Procedure:
BEGIN
SELECT @VDIAPARALISADO = COUNT(F.DATA)
FROM ED_FERIADO F
WHERE F.EDEMPRESA_ID = @PEDEMPRESA_ID...
How to check if a table exists in the SQL Server 2005 database, and if it does not exist, create it and the columns.
The purpose of this process and create this routine for when I need to create a new field in my application, I put it inside thi...
I need to make a procedure that instantiates the cli_TotalCompras column of the client table with the customer's total (in value).
In the vendaProduto table I have the value ( vpr_ValorUnit ), the quantity ( vpr...
I have the following table
ID | Início | Fim | Horas
333 | 01/01/2017 | 03/01/2017 | 5
333 | 02/01/2017 | 05/01/2017 | 1
333 | 05/01/2017 | 07/01/2017 | 3
333 | 01/01/2017 | 07/01/2017 | 6
I need a result like this...
I have a query from the period from 26 to 30-06 which brings the following result:
Data_Cancelado Cancelados
27-06-2017 4
29-06-2017 5
However, I want it to come this way, that is, I want it to come to the query...