SELECT 字段列表....
FROM (
SELECT *,
CASE WHEN RIGHT(BEGIN_LOAD_TIME, 8) < '19:30:00' THEN LEFT(BEGIN_LOAD_TIME, 10)
ELSE LEFT( CONVERT(varchar(19),
dateadd([d], 1, CONVERT(datetime,BEGIN_LOAD_TIME)), 20)
,10)
END AS yyyyMMdd
FROM V_OUTPUT_HISTORY
) as Tmp
GROUP BY yyyyMMdd
FROM (
SELECT *,
CASE WHEN RIGHT(BEGIN_LOAD_TIME, 8) < '19:30:00' THEN LEFT(BEGIN_LOAD_TIME, 10)
ELSE LEFT( CONVERT(varchar(19),
dateadd([d], 1, CONVERT(datetime,BEGIN_LOAD_TIME)), 20)
,10)
END AS yyyyMMdd
FROM V_OUTPUT_HISTORY
) as Tmp
GROUP BY yyyyMMdd
(SELECT *,CASE WHEN RIGHT(BEGIN_LOAD_TIME, 8) < '19:30:00' THEN LEFT(BEGIN_LOAD_TIME, 10) ELSE LEFT(CONVERT(varchar(19), dateadd([d], 1, CONVERT(datetime,BEGIN_LOAD_TIME)), 20), 10) END AS yyyyMMdd
FROM V_OUTPUT_HISTORY
) t
group by yyyyMMdd