I'm currently making an export with this Script:
/* FromTable 1:Otrntransaction, 2:OtrnTrnTaxAmount, 3:Marckup */ SELECT '1' AS FromTable, T1.ID_Trn AS IdDiarioTrans, T1.PostingDate AS Fecha, T2.AccountNo AS Folio,...
I added a new field to the table 1 of the name delete to mark the ones that are duplicates and that are marked in 1 with the following code, but when you delete them and try to upload them, they still appear duplicates
select count(*) from tab...
Good morning ...
I have a defined table (SQL Server 2012) as well;
CREATE TABLE cliente(
id [int] IDENTITY(1,1) NOT NULL,
codigo [varchar](10) NOT NULL,
nombre [varchar](100) NOT NULL,
apellidos [varchar](100) NOT NULL,
direccion [varchar...
I have two tables of which I have repeated values and what I want to obtain is the all value with maximum date of each table and that they do not repeat themselves and I do not know how to perform.
I have two tables one of them is A which has...
I'm joining two tables in SQL using a LEFT OUTER JOIN.
This is my query:
SELECT V_InvoiceHeader.IDFactura, V_InvoiceHeader.FechaDocumento, V_InvoiceHeader.NombreCliente, V_InvoiceHeader.NIT, V_InvoiceHeader.DireccionFacturacion, V_In...
I have a database sql server 2012, where I have a table that contains a datetime field, and what I need is to get the last insert that was made, I have the following table and I hope you can help me
--------------------------------------------...
Hello I have a Table that has a Date column, this has three date formats (04/10/2018) (2018-10-04) (20181004), what I would like to do is in a query to be able to match the format of three.
Thanks
I present the following concern, I need to make an update of the initial amount in the article table, brought from the table articulo18abril as a condition I have established that if they have the same id is assigned the amount that corresponds...
I have the following stored procedure, which allows to generate a report in Excel. The fact is that when several users are generating the report, a series of errors appear indicating that there is already an object called ##rpttabla in th...
If you could help me, I have a table like this:
identificativo fecha
72028586 11/05/2018
72028586 13/05/2018
72045976 17/05/2018
72063798 13/05/2018
and I need to make a query to show me th...