salut, ma puteti ajuta va rog cu un update
am tabela urmatoare
create
table aaa (
[NodId] [int]
NOT NULL ,
[CodContract] [varchar]
(20) NULL,
[CodCategorie] [varchar]
(20) NOT NULL ,
[DataInregistrare] [datetime]
NOT NULL ,
[DataInregistrareAjustata] [datetime]
NULL ,
[CodClient] [int]
NOT NULL ,
[NumeClient] [varchar]
(61) NULL ,
[Moneda] [varchar]
(3) NULL ,
[DobandaPlatita] [money]
NULL ,
[PrincipalPlatit] [money]
NULL ,
[ComFlatFee] [money]
NULL ,
[ComRetailer] [money]
NULL ,
[ComAsigurari] [money]
NULL ,
[PrincipalRestant] [money]
NULL ,
[DobandaRestanta] [money]
NULL ,
[RataPlatita] [money]
NULL ,
[Sold] [money]
NULL ,
[DataReferinta] [datetime]
NOT NULL ,
[RataSchimbRONMedie] [decimal]
(30, 4) NULL ,
[RataSchimbRON] [decimal]
(20, 10) NULL ,
[SoldIRR] [money]
NULL ,
[ValoareContract] [money]
NOT NULL ,
[RataDobandaAnuala] [float]
NULL ,
[DurataCreditInitiala] [int]
NOT NULL ,
[DataInceputCredit] [datetime]
NOT NULL ,
[DataSfarsitCredit] [datetime]
NULL ,
[LuniScurse] [int]
NOT NULL ,
[LuniRamase] [int]
NOT NULL ,
[TipRezidentaClient] [varchar]
(10) NULL ,
[TipCredit] [int]
NOT NULL ,
[Terminat] [int]
NOT NULL ,
[RataSchimbRONZi] [decimal]
(20, 13) NULL ,
[AmendamentPrincipal] [money]
NULL ,
[ComAdministrareLunar] [money]
NULL ,
[ComAsigurareLunar] [money]
NULL
)
ON [PRIMARY]
GO
in care am mii de "CodContract"-e si fiecare cu data lui "DataInregistrare"
un exemplu de select cu clauza where pe tabela pt "select * from aaa where CodContract = 'LD0800103084' order by DataInregistrare asc" arata asa:
NodId CodContract CodCategorie DataInregistrare ....... Principal
10 LD0800103084 21068_225 2007-03-16 00:00:00.000 ........ 0
10 LD0800103084 21068_225 2007-03-23 00:00:00.000 ........ 200
10 LD0800103084 21068_225 2007-04-23 00:00:00.000 ........ 192
10 LD0800103084 21068_225 2007-05-23 00:00:00.000 ........ 192
10 LD0800103084 21068_225 2007-06-22 00:00:00.000 ........ 192
ma intereseaza sa fac un update principal = 0 pe inregistrarea top 2 order by DataInregistare asc pt. toate CodContractele care au aceeasi luna (si an) la DataInregistrare pe primele 2 inregistrari pe fiecare contract in parte (ordonate dupa DataInregistrare asc)
dupa update as vrea sa arate asa:
NodId CodContract CodCategorie DataInregistrare ....... Principal
10 LD0800103084 21068_225 2007-03-16 00:00:00.000 ........ 0
10 LD0800103084 21068_225 2007-03-23 00:00:00.000 ........ 0
10 LD0800103084 21068_225 2007-04-23 00:00:00.000 ........ 192
10 LD0800103084 21068_225 2007-05-23 00:00:00.000 ........ 192
10 LD0800103084 21068_225 2007-06-22 00:00:00.000 ........ 192
tabela are ~ 1 milion inregistrari
multumesc
alex.