-- Stored Procedure: dbo.ArchUtilChangeActionsByDate
-- Bill Wunder

use admin
GO
SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ArchUtilChangeActionsByDate]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ArchUtilChangeActionsByDate]
GO

CREATE Procedure dbo.ArchUtilChangeActionsByDate
 /* Param List */
AS

/******************************************************************************
** File: dbo.ArchUtilChangeActionsByDate.PRC
** Name: admin.dbo.ArchUtilChangeActionsByDate
** Desc: Get the number of changes of each type of SQL Object for each day
**
** Auth: Bill Wunder
** Date: 7-25-2003
*******************************************************************************
** Change History
*******************************************************************************
** Date:  Author:  Description:
** -------- -------- ---------------------------------------
**    
*******************************************************************************/
set nocount on

select top 100 percent 
 cast(cast(RecCreatedDt as varchar(11)) as datetime) as [Date]
 , ChangeAction
 , Count(*) as [Number of changed Items] 
from admin.dbo.ArchUtilChanges
where VSSItem <> ''
group by cast(cast(RecCreatedDt as varchar(11)) as datetime), ChangeAction
order by cast(cast(RecCreatedDt as varchar(11)) as datetime) desc , ChangeAction
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON 
GO