SQL Syntax Error

[Anonymous]

Iam trying to run a power bi Direct query from SQL.  I have the correct databse and server in but when i run a direct query i get a syntax result.  Import works fine, but i need a direct report for refresh.

SET NOCOUNT ON

DECLARE @StartDate DateTime

DECLARE @EndDate DateTime

SET @StartDate = DateAdd(hh,-24,GetDate())

SET @EndDate = GetDate()

SET NOCOUNT OFF

SELECT * FROM (

SELECT DateTime, Value, vValue, StartDateTime

FROM History

WHERE History.TagName IN ('CityWaterActualFlow')

AND wwRetrievalMode = 'Cyclic'

AND wwCycleCount = 100

AND wwVersion = 'Latest'

AND DateTime >= @StartDate

AND DateTime <= @EndDate) temp WHERE temp.StartDateTime >= @StartDate

Not sure what im doing wrong here or whats wrong with my SQL syntax. 

Thanks,

[lbendlin]

This SQL statement has lots of room for improvement.

SELECT DateTime, Value, vValue, StartDateTime
FROM History
WHERE TagName = 'CityWaterActualFlow'
AND wwRetrievalMode = 'Cyclic'
AND wwCycleCount = 100
AND wwVersion = 'Latest'
AND DateTime between DateAdd(d,-1,GetDate()) and GetDate()
AND StartDateTime >= DateAdd(d,-1,GetDate())