I want to make a trigger that as soon as I make a dismissal to the rest of the employees I raise the salary by 20%, but I do not know how to operate directly with the cursor explícito in this trigger , since the query would g...
Hello colleagues I have this query that works well to find the difference between two dates in days, hours, minutes and seconds but when I pass it to the trigger it does not work anymore I get a number 4873 I do not know what I'm doing wrong, my...
Hi, I have a problem with a query. I want to filter by date ranges with two columns. Start and End.
X | Inicio | Fin
1 |2018-10-01 | 2018-10-31
2 |2018-11-01 | 2018-11-30
3 |2018-11-15 | 2018-12-15
Inicio BETWEEN @parametroInicial...
I am trying to get the next available date from a calculation that I show acontinuacion.
That's the query I'm using but it does not work.
SELECT DateID = ROW_NUMBER() over (order by B.Date_Key) ,C.FundDate FROM DIM_DATE B LEFT JOIN DIM_St...
I need to create a query that every time I find a value "Sent" in the Status column, then subtract it in the Events column taking into account a next value that is after Sent.
Table that I am using:
Catalogo Status Eventos
------...
I'm making a data set for an application, and when I insert a Time record, it gives me the following error:
INSERT INTO [ope_prodqa_dev]
(
staff,
turn,
date_prodqa,
hour_dev
)
VALUES
(
1,
4...
As you can see I do not want to show me data for the month of April 2018 but if
there are records for the month of April, if there is a date for the month of April, discard that paritemcod and
go to the next one because there are 20 paritemcod...
I have a table called Registers with this structure:
What I do is add a new column to the right where a balance is going to be calculated (either add or subtract) based on the value of each record in the Concept column; something like t...
Well I mean, I have a database in SQL SERVER called SIELAB and another database in PostgreSQL called reservations , I managed to make the connection correctly and I have already managed to execute a SELECT query from a stored procedure...
During the process of producing a solution in C # records were saved forming a "folio" with a literal, a cell value and an id
'C'+ISNULL(Columna1,'')+Columna2
Example of result:
C96
CX85
The queries have not changed, the same database...