-- =============================================
-- Author:		<Dirk Strauss>
-- Create date:	<10 April 2017>
-- Description:	<Return the list of properties captured in The Property Solution>
-- =============================================
CREATE PROCEDURE [dbo].[sproc_PROP1_GetProperties] 
	@surfaceName VARCHAR(150)	
AS
BEGIN
	
	SET NOCOUNT ON;

	   DECLARE @surfaceId INT = (SELECT recId FROM [dbo].[pal_Surface] WHERE name = @surfaceName)
	   EXEC dbo.sp_GetSurfaceData @SurfaceID = @surfaceId 
END
