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
28
29
30
31
32
33
34
35
36
37
38
39
40
| DECLARE @SEQNRHIST INT;
DECLARE @BARCODE CHAR(13);
DECLARE @DATE DATETIME;
DECLARE @ACTION CHAR(1);
DECLARE @ORIGIN INT;
DECLARE @DESTTYPE INT;
DECLARE @DEST INT;
DECLARE @VALUE INT;
DECLARE @SALETYPE INT;
DECLARE @USERTYPE INT;
DECLARE C CURSOR FOR
SELECT
SEQNRHIST
BARCODE,
DATTIM,
ACTION,
ORIGIN,
DESTTYPE,
DEST,
VALUE,
SALETYPE,
USERTYPE
FROM
T_CHEQUE_ACHAT_HISTORY
ORDER BY
DATTIM,
SEQNRHIST
OPEN C;
FETCH C INTO @SEQNRHIST, @BARCODE, @DATE, @ACTION, @ORIGIN, @DESTTYPE, @DEST, @VALUE, @SALETYPE, @USERTYPE;
WHILE @@FETCH_STATUS = 0
BEGIN
--TOUT UN TAS DE TRAITEMENT
FETCH C INTO @SEQNRHIST, @BARCODE, @DATE, @ACTION, @ORIGIN, @DESTTYPE, @DEST, @VALUE, @SALETYPE, @USERTYPE;
END
CLOSE C;
DEALLOCATE C; |
