Expand|Select|Wrap|Line Numbers
- CREATE TABLE #TTemp (Date datetime, CashIn money)
- DECLARE @datetime datetime
- SET @datetime = '12/01/2008 02:00:00'
- INSERT INTO #TTemp (Date, CashIn) SELECT StartTime, CashIn FROM OrderDetail (nolock) WHERE IDType = 'P'
- AND StartTime BETWEEN @datetime AND DATEADD(HOUR, 1, @datetime)
- SELECT * FROM #TTemp
- DROP TABLE #TTemp
Expand|Select|Wrap|Line Numbers
- StartTime BETWEEN '12/01/2008 02:00:00' AND '12/01/2008 03:00:00'
Here's some sample data I pulled up with this query:
Expand|Select|Wrap|Line Numbers
- SELECT TOP 5 StartTime, CashIn FROM OrderDetail WHERE IDType = 'P'
- AND StartTime BETWEEN '12/01/2008 02:00:00' AND '12/01/2008 03:00:00'
2008-12-01 02:00:14.000 9.55
2008-12-01 02:12:58.000 80.41
2008-12-01 02:13:17.000 96.15
2008-12-01 02:13:20.000 76.25
2008-12-01 02:13:26.000 1279.60
Thanks all!!!