SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Stored Procedure dbo.sp_change_owner_all    Script Date: 7/17/2004 9:42:04 AM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_change_owner_all]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_change_owner_all]
GO

CREATE PROCEDURE sp_change_owner_all

--Name:  		sp_change_owner_all
--
--Purpose:		Change the owner of all objects in a database owned by a given user to another.
--
--Type:			Utility
--
--Format:		EXEC sp_change_owner_all 'derrick','dbo'
--
--Example_1:	EXEC sp_change_owner_all 'derrick','dbo'	--Changes owner from common to dbo.
--
--Author:			Date:		Type:		Description:
--Derrick Leggett	02/27/2004	Created		Created procedure to help in web project.  
--											Creates a new clone of an existing website.
--

@txt_old_name VARCHAR(55),
@txt_new_name VARCHAR(55)

AS

DECLARE @objects TABLE(
	int_id INT PRIMARY KEY IDENTITY(1,1),
	txt_name VARCHAR(255))

INSERT @objects(
	txt_name)

	SELECT so.name
	FROM sysobjects so INNER JOIN sysusers su ON so.uid = su.uid
	WHERE 
		su.name = @txt_old_name
		AND type IN ('P','U','V')

DECLARE
	@int_counter INT,
	@int_max INT,
	@txt_object VARCHAR(256),
	@txt_sql VARCHAR(2500)

SELECT
	@int_counter = (SELECT MIN(int_id) FROM @objects),
	@int_max = (SELECT MAX(int_id) FROM @objects)

WHILE @int_counter <= @int_max
BEGIN

SELECT @txt_object = (SELECT txt_name FROM @objects WHERE int_id = @int_counter)

SELECT @txt_sql = 'sp_changeobjectowner ''' + @txt_old_name + '.' + @txt_object + ''',''' + @txt_new_name + ''

EXEC(@txt_sql)

SELECT @int_counter = @int_counter + 1
END

GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

Select tbl_WhiteCode.chrExtractFileName as Extract_FileName,
count(tbl_WhiteCode.pkWhiteCode) as ExportCount,
SUM(CASE WHEN left(tbl_WhiteCode.chrWhiteCodePrecision,1)='B' THEN 1 ELSE 0 END) AS BulkCount,
SUM(CASE WHEN left(tbl_WhiteCode.chrWhiteCodePrecision,1)<>'B' THEN 1 ELSE 0 END) AS RamCount,

tbl_WhiteCode.dteImportTimeStamp as Set_Date
from tbl_Gate
inner join tbl_WhiteCode
on tbl_Gate.fkWhiteCode=tbl_WhiteCode.pkWhiteCode
inner join tbl_Report_Key
on tbl_Gate.pkGateGuid=tbl_Report_Key.fkGuidKey

Where tbl_Report_Key.fkUser=@fkUser
and tbl_Report_Key.fkReport=@fkReport 
and intRecycleBin=0 and chrExtractFileName is not null
Group by tbl_WhiteCode.chrExtractFileName,
tbl_WhiteCode.dteImportTimeStamp