Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT Date_Time, Tag1_Value, Tag2_Value, Tag3_Value, Tag4_Value
- FROM (SELECT DATEADD(minute, DATEDIFF(minute, 0, Date_Time), 0) AS Date_Time
- , Tag1_Value, Tag2_Value, Tag3_Value, Tag4_Value
- FROM ProDataTable) AS a
- GROUP BY Date_Time, Tag1_Value, Tag2_Value, Tag3_Value, Tag4_Value
- ORDER BY Date_Time
Add Comment
Please, Sign In to add comment