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) |
Partager