text: ﻿-- =============================================
  -- Author:		Pierre J.-L. Plourde
  -- Create date:	20/01/2022
  -- Description:	Retrieves all Flow Test Data entries matching the input FlowTestId
  -- =============================================
  CREATE PROCEDURE [dbo].[spFlowTestData_RetrieveByFlowTestId]
  	-- Add the parameters for the stored procedure here
  	@FlowTestId INT
  AS
  BEGIN
  	-- SET NOCOUNT ON added to prevent extra result sets from
  	-- interfering with SELECT statements.
  	SET NOCOUNT ON;
  
  	-- Insert statements for procedure here
  	SELECT [Id],
  		[FlowTestId],
  		[AssetRoleId],
  		[AssetTypeId],
  		[AssetNumber],
  		[HydrantNozzleId],
  		[StaticPsi],
  		[ResidualPsi],
  		[FlowGpm],
  		[ModelStaticPsi],
  		[ModelResidualPsi],
  		[ModelFlowGpm],
  		[ErrorStaticPsi],
  		[ErrorResidualPsi],
  		[ErrorFlowGpm],
  		[Elevation],
  		[CorrectedErrorResidualPsi]
  	FROM [dbo].[FlowTestData]
  	WHERE [FlowTestId] = @FlowTestId;
  END
  GO
  