Modifications diverses

[auf_coda_additions.git] / db / vues / auf_v_ControleBoursierBanques.sql

USE [coda-prod]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [dbo].[auf_v_ControleBoursierBanques]
AS
SELECT     TOP 100 PERCENT E.code, B.nb_comptes
FROM         dbo.oas_element E LEFT OUTER JOIN
                          (SELECT     elmcode, COUNT(*) AS nb_comptes
                            FROM          oas_elmbanklist
                            WHERE      elmcode LIKE '%L'
                            GROUP BY elmcode) B ON E.code = B.elmcode
WHERE     (E.elmlevel = 2) AND (E.deldate IS NULL) AND (E.endyear LIKE 0) AND (E.code LIKE '%L')
ORDER BY B.nb_comptes DESC
GO