SELECT SUM(I.[SAMPLE]) as SAMPLE_SUM, 
     I.SAMPLE_DATE, 
     T.TOPIC_DESCRIPTION
FROM ENS_MV.eNERGYSolveID.dbo.INTERVAL AS I
     JOIN TOPICS AS T ON (I.TOPIC_ID = T.TOPIC_ID)
     JOIN SUBMETER AS SM ON (I.DEVICE_ID=SM.DEVICE_ID)
     JOIN #TEMP AS TE ON SM.SUB_METER_ID = TE.SUBMETER_ID
WHERE  I.TOPIC_ID = @int_reading_type
	AND I.SAMPLE_DATE BETWEEN @dt_date_from AND @dt_date_to
GROUP BY I.SAMPLE_DATE, T.TOPIC_DESCRIPTION
ORDER BY I.SAMPLE_DATE

CREATE PROC TEST (
   	@vch_submeter_id       	VARCHAR(1000),
    	@dt_date_from 		DATETIME,
	@dt_date_to		DATETIME,
             @int_reading_type	INT=NULL,
	@int_interval		INT=NULL
)
AS
SET NOCOUNT ON

DECLARE @comma_place INT
DECLARE @int_submeter_id VARCHAR(50)

CREATE TABLE #TEMP(SUBMETER_ID VARCHAR(50))

WHILE len(@vch_submeter_id) > 0
BEGIN
	SET @comma_place=patindex('%;%',@vch_submeter_id)
	SET @int_submeter_id = substring(@vch_submeter_id, 1, @comma_place-1)
	SET @vch_submeter_id = substring(@vch_submeter_id, @comma_place+1, len(@vch_submeter_id))
	INSERT INTO #TEMP(SUBMETER_ID)
	VALUES(@int_submeter_id)
END

IF @int_interval = 15
BEGIN

	SELECT SUM(I.[SAMPLE]) as SAMPLE_SUM, I.SAMPLE_DATE,   T.TOPIC_DESCRIPTION
	FROM ENS_MV.eNERGYSolveID.dbo.INTERVAL AS I
		JOIN TOPICS AS T ON (I.TOPIC_ID = T.TOPIC_ID)
		JOIN SUBMETER AS SM ON (I.DEVICE_ID=SM.DEVICE_ID)
		JOIN #TEMP AS TE ON SM.SUB_METER_ID = TE.SUBMETER_ID
	WHERE  I.TOPIC_ID = @int_reading_type
		AND I.SAMPLE_DATE BETWEEN @dt_date_from AND @dt_date_to
	GROUP BY I.SAMPLE_DATE, T.TOPIC_DESCRIPTION
	ORDER BY I.SAMPLE_DATE
END