
declare @t1 datetime
declare @t2 datetime
set @t1 = getdate()
select entete.DO_Piece from f_docligne ligne
-- left join F_DOCENTETE entete on entete.DO_Piece = ligne.DO_Piece
-- left join F_CMLIEN lien on ligne.DL_No = lien.DL_NoOut
where entete.Expeditions = 'Co' and entete.do_domaine = 0 and entete.do_type = 1 and AR_Ref is not null
order by DO_Piece
set @t2 = getdate()
print 'Résultat des courses : ' + RTRIM(CONVERT(varchar(20), datediff(ms,@t1,@t2))) + ' millisecondes'