Bonjour,

Je voudrais de l'aide car je dois modifier des scripts SQL2000 en SQL2005.
Ce sont les '*=' et '=*' qui me perturbent le plus.
Je sais qu'il faut utiliser LEFT OUTER - RIGHT OUTER JOIN, au niveau performance, qu'en pensez-vous ?

Je suis débutant et j'aurai aimé avoir de l'aide sur ce script :
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
DECLARE @as_bro_id varchar(16)
 
select	bro_orderid, bro_orderseq,	bro_remarks, bro_status, bro_date_mod,	bro_uid_mod, bro_order_from, bro_secnumber,	bro_secdescription,
			bro_ccy1, bro_set1cstnbr, bro_set1cst_portf, bro_set1cstinst, bro_setacseq, bro_setccy,	bro_dealinst,
			bro_cstnumber, bro_cstportf, bro_sec_expnom, bro_amount1, bro_amount2, bro_sec_actionnom, bro_sec_expprice,
			bro_secprice1, bro_sec_actionprice, bro_secprice2, bro_fe1_disc, bro_fe2_disc, bro_sec_marge, bro_sec_expdate,
			bro_sec_actdate, bro_sec_brok, bro_custodi, bro_sec_expamount, bro_sxcode, tds_desc1, tds_desc2, tds_cp_last,
			tds_maturity, tds_cprate, tds_desc_rpt, pta_descint, eic_name, tac_code1, tac_code2, ssi1.ncs_number ncs_mid, ssi2.ncs_number ncs_isin,
			ssi3.ncs_number ncs_vd, cds_namerpt, tro_descint, sro_descint, tst_trt,	dfa_descint, bro_sec_inputtype
FROM dbo.tblbookorder bro,
     dbo.tblsecur tds,
     dbo.tblactype pta,
     dbo.tblcie eic, 
     dbo.tbltab03 tac,
     dbo.tblcodif ssi1,  --ncs
     dbo.tblcodif ssi2,  --ncs
     dbo.tblcodif ssi3,  --ncs
     dbo.tblcusact acs,
     dbo.tbltodian cds,
     dbo.tblordtype tro,
     dbo.tblordstype sro,
     dbo.tblordtstype tst,
     dbo.tblfeedisc dfa 
 
WHERE   bro_orderid  =  @as_bro_id
	AND  tds_number   =* bro_secnumber
	AND  pta_code     =  bro_dealinst
	AND  acs_customer =* bro_cstnumber
	AND  acs_secur    =* bro_secnumber
	AND  acs_portf    =* bro_cstportf
	AND  acs_atype    =* bro_dealinst
	AND  acs_ccy      =* bro_ccy1
	AND  bro_custodi  =  cds_number 
	AND  eic_code     =  1
	AND  tac_code     =  10
	AND  ssi1.ncs_sec =* bro_secnumber
	AND  ssi1.ncs_code = "DIM"
	AND  ssi2.ncs_sec  =* bro_secnumber
	AND  ssi2.ncs_code = "NISI"
	AND  ssi3.ncs_sec  =* bro_secnumber
	AND  ssi3.ncs_code = "VD"
	AND  bro_ort       *= tro_code
	AND  bro_ors       *= sro_code
	AND  bro_ort       *= tst_ort
	AND  bro_ors       *= tst_ors
    AND ((bro_fe1_disc IS NOT NULL AND bro_fe1_disc *= dfa.dfa_code)
     OR  (bro_fe2_disc IS NOT NULL AND bro_fe2_disc *= dfa.dfa_code)
     OR  (bro_fe1_disc IS NULL AND bro_fe2_disc IS NULL AND dfa.dfa_code = 0 ))
Merci par avance pour votre aide.