--Checks the EN50160 measurements from a source and date range to see what values are returned.

USE [ION_Data]
GO

--Set the variables you want to check.  (SourceID, and Date Range).  Leave the RC variable alone.
DECLARE @RC int = 1
DECLARE	@SourceIDs		NVARCHAR(MAX) = '104'
DECLARE @StartDatesUtc	NVARCHAR(MAX) = N'2019-02-01'
DECLARE	@EndDatesUtc	NVARCHAR(MAX) = N'2019-07-01'

-- TODO: Set parameter values here.
EXECUTE @RC = [dbo].[spDAL_GetEN50160PowerFrequencyDataION]     @SourceIDs   ,@StartDatesUtc   ,@EndDatesUtc
EXECUTE @RC = [dbo].[spDAL_GetEN50160SupplyVoltageMagnitudeDataION]    @SourceIDs  ,@StartDatesUtc  ,@EndDatesUtc
EXECUTE @RC = [dbo].[spDAL_GetEN50160FlickerDataION]   @SourceIDs  ,@StartDatesUtc  ,@EndDatesUtc
EXECUTE @RC = [dbo].[spDAL_GetEN50160SupplyVoltageDipsDataION]   @SourceIDs  ,@StartDatesUtc  ,@EndDatesUtc
EXECUTE @RC = [dbo].[spDAL_GetEN50160ShortAndLongInterruptionsDataION]    @SourceIDs  ,@StartDatesUtc  ,@EndDatesUtc
EXECUTE @RC = [dbo].[spDAL_GetEN50160v2010TemporaryOvervoltagesDataION]    @SourceIDs  ,@StartDatesUtc  ,@EndDatesUtc
EXECUTE @RC = [dbo].[spDAL_GetEN50160SupplyVoltageUnbalanceDataION]    @SourceIDs  ,@StartDatesUtc  ,@EndDatesUtc
EXECUTE @RC = [dbo].[spDAL_GetEN50160HarmonicVoltageDataION]     @SourceIDs   ,@StartDatesUtc   ,@EndDatesUtc
EXECUTE @RC = [dbo].[spDAL_GetEN50160InterharmonicVoltageDataION]    @SourceIDs  ,@StartDatesUtc  ,@EndDatesUtc
EXECUTE @RC = [dbo].[spDAL_GetEN50160MainsSignalingData]    @SourceIDs  ,@StartDatesUtc  ,@EndDatesUtc
EXECUTE @RC = [dbo].[spDAL_GetEN50160SupplyVoltageDipsDataION]    @SourceIDs  ,@StartDatesUtc  ,@EndDatesUtc
EXECUTE @RC = [dbo].[spDAL_GetEN50160TemporaryOvervoltagesDataION]    @SourceIDs  ,@StartDatesUtc  ,@EndDatesUtc
EXECUTE @RC = [dbo].[spDAL_GetEN50160v2010SupplyVoltageDipsDataION]    @SourceIDs  ,@StartDatesUtc  ,@EndDatesUtc
EXECUTE @RC = [dbo].[spDAL_GetEN50160v2010SupplyVoltageMagnitudeDataION]    @SourceIDs  ,@StartDatesUtc  ,@EndDatesUtc
