1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
CREATE VIEW xxxxxxxx
AS
SELECT crb.compteur_id,
crb.type_pt_id,
min (crb.datepoint)
AS dtmin,
max (crb.datepoint)
AS dtmax,
count (*)
AS [count],
max (version)
AS maxversion,
(SELECT TOP 1 datepoint
FROM codap.gtm_crb10mn
WHERE version = max (crb.version) AND type_pt_id = crb.type_pt_id)
AS dtmaxversion,
max (crb.dateversion)
AS dtlastupdate
FROM xxxxxxx
where crb.version =
(SELECT max (crb2.version)
FROM xxxxxxx
WHERE crb2.datepoint = crb.datepoint
AND crb2.type_pt_id = crb.type_pt_id
AND crb2.compteur_id = crb.compteur_id)
GROUP BY crb.type_pt_id, crb.compteur_id |
