Hello a tous !!!!

Voila, je suis débutant en SQL Serveur et j'ai besoin de votre aide.

J'ai une requête qui me permet de supprimer des comptes d'une base.
et j'ai plusieurs comptes a supprimer.

Comment puis-je faire pour les supprimer tous d'un coup sans avoir à changer à chaque fois mon N° de compte dans ma requête?

ci-dessous le code :

Code : Sélectionner tout - Visualiser dans une fenêtre à part
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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
USE 'XXXXXX'
 
-- Check user rights
IF CURRENT_USER != 'dbo'
BEGIN
   RAISERROR(15247, 20, 1) WITH NOWAIT;
   RETURN
END;
 
IF NOT EXISTS(SELECT VERSION FROM dbo.DB_VERSION WHERE VERSION LIKE '2.3.23.%')
    RAISERROR('Wrong database version', 20, 1) WITH LOG;
GO
 
 
-- Initialize transaction
BEGIN TRANSACTION U2_T1;
 
	-- Start flow
	BEGIN
 
	DECLARE @old_code NVARCHAR(10)
	-- Initialize values
	SET @old_code = 'XXXXX'
 
	IF @old_code is null
		RAISERROR('old_code must contain a legal value', 20, 1)  WITH LOG;
 
	IF NOT EXISTS(SELECT ACC_CODE FROM ACCOUNTS WHERE ACC_CODE = @old_code)
		RAISERROR('new_code doesn''t exists in table ACCOUNTS', 20, 1)  WITH LOG;
 
	DELETE ACC_GROUP_CONTENT WHERE ACC_CODE = @old_code
	DELETE ACC_GROUPING WHERE POOLING_ACC = @old_code
	DELETE ACCOUNT_ID WHERE ACC_CODE = @old_code
	DELETE ARCHIVING_ACCOUNTS WHERE ACCOUNT_CODE = @old_code
	DELETE ARCHIVING_REJECT_REASON WHERE ACCOUNT_CODE = @old_code
	DELETE AUDIT_CASH_LEDGER_INFO WHERE ACC_CODE = @old_code
	DELETE AUDIT_CASH_TRAN_INFO WHERE DEBIT_ACC_CODE = @old_code
	DELETE AUDIT_CASH_TRAN_INFO WHERE CREDIT_ACC_CODE = @old_code
	DELETE AUDIT_REC_ACC_INFO WHERE ACC_CODE = @old_code
	DELETE AUDIT_REC_BANK_INFO WHERE ACC_CODE = @old_code
	DELETE BK_CLAIM_LEDGER WHERE ACC_CODE = @old_code
	DELETE BK_MAN_CONTROL WHERE ACC_CODE = @old_code
	DELETE BK_MAN_LEDGER WHERE ACC_CODE = @old_code
	DELETE BK_MAN_LEDGER_UNIQUE WHERE ACC_CODE = @old_code
	DELETE BK_MAN_LOCK WHERE ACC_CODE = @old_code
	DELETE BK_MAN_REPORT WHERE ACC_CODE = @old_code
	DELETE BK_MAN_STAT WHERE ACC_CODE = @old_code
	DELETE BK_MAN_TEMP WHERE ACC_CODE = @old_code
	DELETE BUDGET_EXCEPTIONS WHERE ACC_CODE = @old_code
	DELETE CASH_BALANCES WHERE ACC_CODE = @old_code
	DELETE CASH_DISC_LEDGER WHERE ACC_CODE = @old_code
	DELETE CASH_INT_FLOW_COND WHERE ACC_CODE = @old_code
	DELETE CASH_LEDGER WHERE ACC_CODE = @old_code
	DELETE CASH_MODEL WHERE ACC_CODE = @old_code
	DELETE CASH_MODEL WHERE BENEFICIARY_ACC = @old_code
	DELETE CASH_MODEL WHERE CASH_ACC = @old_code
	DELETE CASH_POOL_COND WHERE ACC_CODE = @old_code
	DELETE CASH_PREMIUM_LEDGER WHERE ACC_CODE = @old_code
	DELETE CASH_TRANSACTIONS WHERE DEBIT_ACC_CODE = @old_code
	DELETE CASH_TRANSACTIONS WHERE CREDIT_ACC_CODE = @old_code
	DELETE COMMERC_ARCH WHERE CHARGE_ACC = @old_code
	DELETE COMMERC_TRANSFER WHERE CHARGE_ACC = @old_code
	DELETE COMMERCIAL_MODEL WHERE ACC_CODE = @old_code
	DELETE COMMERCIAL_MODEL WHERE CHARGE_ACC = @old_code
	DELETE COMMISSION_COND WHERE ACC_CODE = @old_code
	DELETE CREDIT_COND WHERE ACC_CODE = @old_code
	DELETE DISCOUNT_MODELS WHERE ACC_CODE = @old_code
	DELETE DOM_MASS_TRANSFER WHERE ACC_CODE = @old_code
	DELETE DOM_STAND_MODELS WHERE ACC_CODE = @old_code
	DELETE DOM_STAND_MOULD WHERE ACC_CODE = @old_code
	DELETE DOMESTIC_MODEL WHERE BENEFICIARY_ACC = @old_code
	DELETE DOMESTIC_MODEL WHERE ACC_CODE = @old_code
	DELETE DOMESTIC_MOULD WHERE ACC_CODE = @old_code
	DELETE DRAFTS_POST WHERE ACCOUNT_CODE = @old_code
	DELETE FEE_LINKS WHERE ACC_CODE = @old_code
	DELETE FINANCING_COND WHERE ACC_CODE = @old_code
	DELETE FX_HOLDINGS WHERE ACC_CODE = @old_code
	DELETE FX_HOLDINGS WHERE CNT_ACC_CODE = @old_code
	DELETE HOLDING_COUPLES WHERE HOLDING_ACC = @old_code
	DELETE HOLDING_COUPLES WHERE FILIAL_ACC = @old_code
	DELETE IBC_FLOW_LINK WHERE ACC_CODE = @old_code
	DELETE IBC_FLOW_LIST WHERE ACC_CODE = @old_code
	DELETE INTERCMP_PAYMENTS WHERE ISSUER_ACC_CODE = @old_code
	DELETE INTERCMP_PAYMENTS WHERE BENEFICIARY_ACC_CODE = @old_code
	DELETE INTERNAT_ARCH WHERE CHARGE_ACC = @old_code
	DELETE INTERNAT_MODEL WHERE ACC_CODE = @old_code
	DELETE INTERNAT_MODEL WHERE CHARGE_ACC = @old_code
	DELETE INTERNAT_TRANSFER WHERE CHARGE_ACC = @old_code
	DELETE INVESTMENT_COND WHERE ACC_CODE = @old_code
	DELETE LIMITS_ACCOUNTS WHERE ACC_CODE = @old_code
	DELETE LIMITS_ACCOUNTS_CREDIT WHERE ACC_CODE = @old_code
	DELETE LIMITS_ACCOUNTS_DEBIT WHERE ACC_CODE = @old_code
	DELETE LOAN_FLOWS WHERE ACC_CODE = @old_code
	DELETE LOANS WHERE AMORT_CMP_ACC = @old_code
	DELETE LOANS WHERE ADDIT_PAYMENT_CMP_ACCOUNT=@old_code
	DELETE LOANS WHERE PAYMENTS_CMP_ACC = @old_code
	DELETE LOANS WHERE INT_CMP_ACC = @old_code
	DELETE LOANS WHERE FEE_CMP_ACC = @old_code
	DELETE MUTUAL_FUNDS WHERE ACC_CODE = @old_code
	DELETE MUTUAL_FUNDS WHERE DEPOSIT_CMP_ACC = @old_code
	DELETE MUTUAL_FUNDS WHERE FEE_CMP_ACC = @old_code
	DELETE NREC_ACC WHERE ACC_CODE = @old_code
	DELETE NREC_BANK WHERE ACC_CODE = @old_code
	DELETE OVERDRAFT_COND WHERE ACC_CODE = @old_code
	DELETE PAYMENT WHERE ACC_CODE = @old_code
	DELETE PAYMENT WHERE CASH_ACC = @old_code
	DELETE PAYMENT WHERE CHARGE_ACC = @old_code
	DELETE PAYMENT_ARCH WHERE CHARGE_ACC = @old_code
	DELETE PAYMENT_ARCH WHERE ACC_CODE = @old_code
	DELETE PAYMENT_ARCH WHERE CASH_ACC = @old_code
	DELETE PAYMENT_MODEL WHERE ACC_CODE = @old_code
	DELETE PAYMENT_MODEL WHERE CASH_ACC = @old_code
	DELETE PRE_GROUP WHERE ACC_CODE = @old_code
	DELETE PRE_REC WHERE PRE_REC_ACC_CODE = @old_code
	DELETE REC_ACC WHERE ACC_CODE = @old_code
	DELETE REC_ACC_ARH WHERE ACC_CODE = @old_code
	DELETE REC_BANK WHERE ACC_CODE = @old_code
	DELETE REC_BANK_ARH WHERE ACC_CODE = @old_code
	DELETE SHORT_TERMS WHERE FEE_CMP_ACC = @old_code
	DELETE SHORT_TERMS WHERE RED_CMP_ACC = @old_code
	DELETE SHORT_TERMS WHERE INT_CMP_ACC = @old_code
	DELETE SHORT_TERMS WHERE DEPOSIT_CMP_ACC = @old_code
	DELETE SHORT_TERMS WHERE ACC_CODE = @old_code
	DELETE SPE_RAP_ACCOUNTS WHERE ACC_CODE = @old_code
	DELETE STANDING_DEPOSITS WHERE ACC_CODE = @old_code
	DELETE STANDING_DEPOSITS WHERE CHARGE_ACC_CODE = @old_code
	DELETE STANDING_DEPOSITS WHERE UNPAID_ACC_CODE = @old_code
	DELETE STANDING_PROFILES WHERE ACC_CODE = @old_code
	DELETE STANDINGS WHERE ACC_CODE = @old_code
	DELETE STANDINGS_ARCHIVE WHERE ACC_CODE = @old_code
	DELETE STATS_REC_AR WHERE ACC_CODE = @old_code
	DELETE SUFFIXES WHERE ACC_CODE = @old_code
	DELETE TRANSFER_PROFILE WHERE ACC_CODE = @old_code
	DELETE TRANSFER_PROFILE WHERE CASH_ACC = @old_code
	DELETE VALUE_TERMS WHERE ACC_CODE = @old_code
	DELETE ZERO_BALANCING_ACCOUNT WHERE BANK_ACCOUNT = @old_code
 
	DELETE FROM ACCOUNTS WHERE ACC_CODE = @old_code
 
END;
GO
 
COMMIT TRAN U2_T1;
Merci pour votre aide