-- =============================================
-- Author:		<Dirk Strauss>
-- Create date:	<12 April 2017>
-- Description:	<Return the list of tenants captured in The Property Solution>
-- =============================================
CREATE PROCEDURE [dbo].[sproc_PROP1_GetTenants] 
	@surfaceName VARCHAR(150)	
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
	   
	   DECLARE @surfaceId INT = (SELECT recId FROM [dbo].[pal_Surface] WHERE name = @surfaceName)
	   EXEC dbo.sp_GetSurfaceData @SurfaceID = @surfaceId 
END




