DingWeizhe

SELECT * INTO [TMP_LASTDAY] FROM (
	SELECT [GRP_ID], MAX([YMD]) AS [YMD]
	FROM [tbl]
	GROUP BY [GRP_ID]
) [N];


SELECT [N].[GRP_ID], [N].[YMD_1W] INTO [TMP_1W] FROM (
	SELECT

DingWeizhe

ID, GRP_ID, DATE, PRICE
1,1,2014-08-01,305
2,1,2014-08-02,300
3,1,2014-08-03,301
4,1,2014-08-04,302
5,1,2014-08-05,304
6,1,2014-08-06,300
7,1,2014-08-07,303
8,1,2014-08-08,305
9,2,2014-07-29,101

DingWeizhe

http://sandbox.host.smartgslb.com/fb0/xss1.php?code=pkav