

GO

/****** Object:  StoredProcedure [dbo].[reg_doc_documento_evaluacion]    Script Date: 07/26/2013 10:01:34 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[reg_doc_documento_evaluacion]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[reg_doc_documento_evaluacion]
GO


GO

/****** Object:  StoredProcedure [dbo].[reg_doc_documento_evaluacion]    Script Date: 07/26/2013 10:01:34 ******/
SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER OFF
GO

CREATE PROCEDURE [dbo].[reg_doc_documento_evaluacion]
	@p_id INT
AS
BEGIN
	SELECT 	[id] AS [id],
		[uid] AS [uid],
		[eid] AS [eid],
		[id_usuario_modifico] AS [id_usuario_modifico],
		[id_usuario_creo] AS [id_usuario_creo],
		[fechaModificacion] AS [fechaModificacion],
		[fechaCreacion] AS [fechaCreacion],
		[active] AS [active],
		[documento_evaluacion] AS [documento_evaluacion],
		[personaEncuestada] AS [personaEncuestada],
		[fechaEncuesta_ff] AS [fechaEncuesta_ff],
		[id_documento] AS [id_documento],
		[id_evaluacion] AS [id_evaluacion],
		[observaciones] AS [observaciones]
	FROM [doc_documento_evaluacion]
	WHERE	(id = @p_id)

END

GO





