IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_MMEFiguresGet]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_MMEFiguresGet]
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_MMEFiguresGet]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[sp_MMEFiguresGet] AS' 
END
GO
ALTER PROCEDURE [dbo].[sp_MMEFiguresGet]
		  @Id		int	= null
AS
BEGIN
	SET NOCOUNT ON;
	SELECT [ID]
		  ,[txtShortName]
		  ,[txtDescription]
		  ,[txtRemarks]
		  ,[datRevision]
		  ,[intAuthor]
		  ,[intPage]
		  ,[intPages]
		  ,[txtImageFile]
		  ,[intVersion]
		  ,[bolExpired]
		  ,[txtSortkey]
		  ,[bitStdPath]
		  ,[IntIDStdPath]
		  ,[txtPath]
		  ,[LAST_CHANGE]
		  ,[LAST_CHANGE_TEXT]
		  ,[HISTORY]
		  ,[ISOFlag]
	  FROM [dbo].[v_MMEFigures] where @Id is null or ID = @Id

END






























GO