一.vs2005打开vs2008编译的项目:1.用记事本打开sln文件,将: Microsoft Visual Studio Solution File, Format Version 10.00 # Visual Studio 2008 改成: Microsoft Visual Studio Solution File, Format Version 9.00 # Visual Studio 2005 2.用记事本打开csproj文件,将: <Project ToolsVersion="
;with test(CID,money,NewAmount) as ( SELECT Row_Number() over ( order by money ) as CID ,money ,money *0.1 as NewAmount FROM test107 ) select b.CID , SUM(a.NewAmount ) sum_money, b.NewAmount --distinct b.CID ,case when SUM(a.NewAmount ) > 50000 then