展开全部
-- 模拟销售的表.
CREATE TABLE #temp (
[销售时间] datetime,
[销量] int,
[实销] int
)
go
-- 由于 成本与毛利, 我估计应该是在另外一个表里面的,62616964757a686964616fe58685e5aeb931333332623963 这里就不模拟了
INSERT INTO #temp
-- 9点的
SELECT '2013-07-16 09:55:15', 9, 900 UNION ALL
-- 10点的
SELECT '2013-07-16 10:15:15', 1, 100 UNION ALL
SELECT '2013-07-16 10:25:15', 15, 1500 UNION ALL
SELECT '2013-07-16 10:35:15', 10, 1000 UNION ALL
-- 11点的
SELECT '2013-07-16 11:15:15', 1, 100 UNION ALL
SELECT '2013-07-16 11:25:15', 2, 200 UNION ALL
SELECT '2013-07-16 11:35:15', 3, 300 UNION ALL
SELECT '2013-07-16 11:45:15', 4, 400 UNION ALL
SELECT '2013-07-16 11:55:15', 5, 500 UNION