Query for get data as per specific interval
Assume tablename=UserOrders,column=Price,column for date=CreatedDate, column for confirm order=Status, column for delete row status=IsActive:
Query:
For @interval you can pass any int value.(for ex. for 1 day interval you can pass 1440)
DECLARE
@interval INT
SELECT DATEADD(MINUTE,FLOOR(DATEDIFF(MINUTE,0,CreatedDate)/@interval)*@interval,0) [date],MAX(Price) high,Min(Price) as low,
ISNULL((SELECT TOP 1 Price FROM
UserOrders WHERE DATEADD(MINUTE,FLOOR(DATEDIFF(MINUTE,0,CreatedDate)/@interval)*@interval,0)=DATEADD(MINUTE,FLOOR(DATEDIFF(MINUTE,0,U.CreatedDate)/@interval)*@interval,0)...
Live Traffic Feed
A visitor from Voronezh viewed 'filter row datagrid with multiple column on keyup ' 23 days 7 hrs ago
A visitor from Washington viewed 'filter row datagrid with multiple column on keyup ' 25 days 2 hrs ago
A visitor from Gatchina viewed 'filter row datagrid with multiple column on keyup ' 26 days 15 hrs ago
A visitor from Yekaterinburg viewed 'Open Source cryptocurrency Exchanges | Vimal Vatal' 28 days 10 hrs ago