WITH    tempbl
          AS ( SELECT   ROW_NUMBER() OVER ( ORDER BY HomepagePromote.AddedID ASC ) AS Row ,
                        *
               FROM     ( SELECT    HomepagePromote.AddedID ,
                                    DomaineData.DomaineOriName ,
                                    VinData.VinOriName ,
                                    DomaineData.DomaineTraName ,
                                    VinData.VinTraName ,
                                    VintageData.Vintage ,
                                    ProdItems.SellPrice ,
                                    ProdItems.VinID ,
                                    ProdItems.VintageID ,
                                    dbo.f_GetCateLvlAll(VinData.VinID, '-',
                                                        '1') AS CateLvl ,
                                    SD1.DataTraDesc AS STYPE ,
                                    SD2.DataOriDesc AS VUL ,
                                    HomepagePromote.PromoteDesc AS VinTraDesc ,
                                    VintageCap.BtFilePath
                          FROM      HomepagePromote
                                    LEFT JOIN ProdItems ON HomepagePromote.AddedID = ProdItems.AddedID
                                    LEFT JOIN VintageCap ON ProdItems.VintageID = VintageCap.VintageID
                                                            AND ProdItems.VulID = VintageCap.VulID
                                                            AND ProdItems.VinID = VintageCap.VinID
                                    LEFT JOIN VintageData ON ProdItems.VintageID = VintageData.VintageID
                                    LEFT JOIN VinData ON ProdItems.VinID = VinData.VinID
                                    LEFT JOIN DomaineData ON VinData.DomaineID = DomaineData.DomaineID
                                    LEFT JOIN SysBasicData AS SD1 ON VinData.VinType = SysBasicData.DataCode
                                    LEFT JOIN SysBasicData AS SD2 ON ProdItems.VulID = SysBasicData.DataCode
                          WHERE     HomepagePromote.AddedID IN ( 57, 66 )
                        ) AS DataALl
             ) --这个位置少了半个括号
    SELECT  *
    FROM    tempbl
    WHERE   Row BETWEEN CAST(1 AS VARCHAR) AND CAST(4 AS VARCHAR)