IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_TestObjectTemplateExist]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_TestObjectTemplateExist]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_TestObjectTemplateExist]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_TestObjectTemplateExist] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_TestObjectTemplateExist]
	 @TestSetupName		nvarchar(50)	= null
	,@TemplateName		nvarchar(50)	= null
	,@rv				int				= 0		output
AS
BEGIN
	SET NOCOUNT ON;
	declare @TemplateId int
	declare @TestSetupId int

	set @TemplateId = dbo.foo_IdGetTemplate(@TemplateName)
	set @TestSetupId = dbo.foo_IdGetTestSetup(@TestSetupName)

	if(exists(select  tObj.TestObjectName as TestObjectSerialNumber
	from TestSetupObjects as tsObj 
		INNER JOIN TestSetups as ts on tsObj.TestSetupId = ts.TestSetupId
		INNER JOIN TestObjects as tObj on tObj.TestObjectId = tsObj.TestObjectId 
	where ts.TestSetupId =@TestSetupId AND tobj.TemplateId=@TemplateId))
	begin
		set @rv = 1
	end

END




























GO