求一SQL语句

with dataTable as (SELECT ROW_NUMBER() OVER (ORDER BY DateTime asc) AS RowIndex,*, a.AcceptMoney - a.ActuallyMoney as Profits from ( select Convert(varchar, ProduceTime, 111) as DateTime , COUNT(orderid) as OrderNumber, SUM(PersonCount) as Number, SUM(Fare) as AcceptMoney, SUM(CustFare) as ActuallyMoney from B_Orders where PromulgatorCode = 1 and DATEDIFF(MONTH, ProduceTime, '2010-3-31 0:00:00') = 0 group by Convert(varchar, ProduceTime, 111)) a) select * from dataTable where 1=1 and RowIndex between @row1 and @row2



求这个Sql语句查询结果的总条数

---

with dataTable as (SELECT ROW_NUMBER() OVER (ORDER BY DateTime asc) AS RowIndex,*, a.AcceptMoney - a.ActuallyMoney as Profits from ( select Convert(varchar, ProduceTime, 111) as DateTime , COUNT(orderid) as OrderNumber, SUM(PersonCount) as Number, SUM(Fare) as AcceptMoney, SUM(CustFare) as ActuallyMoney from B_Orders where PromulgatorCode = 1 and DATEDIFF(MONTH, ProduceTime, '2010-3-31 0:00:00') = 0 group by Convert(varchar, ProduceTime, 111)) a) select count(*) from dataTable where 1=1 and RowIndex between @row1 and @row2

---

引用

with dataTable as (SELECT ROW_NUMBER() OVER (ORDER BY DateTime asc) AS RowIndex,*, a.AcceptMoney - a.ActuallyMoney as Profits from ( select Convert(varchar, ProduceTime, 111) as DateTime , COUNT(order……

up

---

不能这样加~这样加了绑定数据的时候会出问题

---

那样就拿不到，字段名称

---