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
| Table DocumentsDemandes
--------------------------
CREATE TABLE [dbo].[DocumentsDemandes](
[DemandeID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[DocumentID] [int] NULL,
[Libelle] [varchar](200) COLLATE French_CI_AS NULL,
[DocumentNo] [varchar](15) COLLATE French_CI_AS NULL,
[DocumentNoFolio] [varchar](15) COLLATE French_CI_AS NULL,
[DocumentText] [text] COLLATE French_CI_AS NULL,
[SiteID] [int] NULL,
[NombreExemplaire] [int] NULL,
[DateDemande] [varchar](10) COLLATE French_CI_AS NULL,
[DateDocument] [varchar](10) COLLATE French_CI_AS NULL,
[DateExpedition] [varchar](10) COLLATE French_CI_AS NULL,
[NoHologram] [varchar](20) COLLATE French_CI_AS NULL,
[NoPapier] [varchar](20) COLLATE French_CI_AS NULL,
[identiteID] [int] NOT NULL
CONSTRAINT [PK_DocumentsDemandes] PRIMARY KEY CLUSTERED
procédure stockée SP_TESTBYMASTER13
---------------------------------------
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
create procedure SP_TESTBYMASTER13 @NOM_DB varchar(128),@Year1 varchar(20),@Year2 varchar(20)
AS
declare @MA_REQUETE VARCHAR(8000)
declare @nom_complet varchar(128)
set @nom_complet=@NOM_DB+'dbo.DocumentsDemandes.DateDemande'
SET @MA_REQUETE = 'SELECT Libelle,'''
+convert(DateTime,@nom_complet,103)+''', COUNT(DemandeID) AS Nombre FROM ' + @NOM_DB+'.dbo.DocumentsDemandes where '''
+convert(DateTime,@nom_complet,103)+''' between '''
+convert(DateTime,@Year1,103)+''' and '''
+convert(DateTime,@Year2,103)+'''GROUP BY Libelle,'''
+convert(DateTime,@nom_complet,103)+''' ORDER BY '''
+convert(DateTime,@nom_complet,103);
EXEC (@MA_REQUETE) |
