IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_TestEngineerDetailsGet]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_TestEngineerDetailsGet]
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_TestEngineerDetailsGet]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_TestEngineerDetailsGet] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_TestEngineerDetailsGet]
		  @Name		nvarchar(255)	= null
AS
BEGIN
	SET NOCOUNT ON;
	declare @EngineerId int
	set @EngineerId = dbo.foo_IdGetEngineer(@Name)

	SELECT [Name]
		  ,[TestEngineerName]
		  ,[TestEngineerPhone]
		  ,[TestEngineerFax]
		  ,[TestEngineerEmail]
		  ,[LocalOnly]
		  ,[LastModified]
		  ,[LastModifiedBy]
		  ,[Version]
	FROM [dbo].[TestEngineerDetails] where @Name is null or [TestEngineerId] = @EngineerId


END






























GO