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
| ALTER PROCEDURE [dbo].[FillPAO]
AS
BEGIN
SELECT dbo.OPCVM.[Code client] AS codcli,
dbo.Portfolio.code_opcvm AS codopcvm,
dbo.FormateChiffres(dbo.Portfolio.Nombre_de_titres) AS nbtitre,
dbo.Assemblée.[Code société] AS codsoc,
dbo.Assemblée.[Code assemblée] AS codass,
dbo.Assemblée.[Date de tenue d'assemblée] AS dateag
INTO #TempPosAg
FROM dbo.Assemblée INNER JOIN
dbo.Société ON dbo.Assemblée.[Code société] = dbo.Société.[Code société] INNER JOIN
dbo.Portfolio ON dbo.Société.[Code société] = dbo.Portfolio.Id_Societe INNER JOIN
dbo.OPCVM ON dbo.Portfolio.code_opcvm = dbo.OPCVM.[N°OPCVM]
INSERT INTO [dbo].[Positions_AG_OPCVM]([code_assemblee],[N°OPCVM],[cli], [SharesatRecorddate], [MeetingWithShares])
SELECT codass, codopcvm, codcli, SUM(nbtitre), 1
FROM #TempPosAg WHERE (DATEDIFF(DAY, GETDATE(), dateag) = 3)
AND NOT EXISTS (SELECT [code_assemblee],[N°OPCVM],[cli] FROM [Positions_AG_OPCVM])
GROUP BY codass, codopcvm, codcli
SELECT @@ROWCOUNT
END |
Partager