aspnetpager复杂分页记录备忘

set nocount on

declare @indextable table(id int identity(1,1),nid int);
set rowcount 50
 
 --select * from #temp
--insert into @indextable(nid) select top 100 percent ROW_NUMBER() over(order by aa.终端编号,aa.电表编号,aa.数据日期,aa.数据时间) as rownum1   from [yhcbpara].[dbo].[YH电表参数表视图_无虚拟表] dbcsb right join(Select dbo.FormatDateTime(daybd.数据时间,':','','') as 时间, daybd.* from cbdata.[dbo].[RealBD20121018] daybd where  ((数据日期=20121018 and 数据时间>=0 ) or (数据日期>20121018 and 数据日期<20121028 ) or (数据日期=20121028 and 数据时间<=1500 ))  and  ( (daybd.终端编号=108 and daybd.电表编号=0) or (daybd.终端编号=110 and daybd.电表编号=0) or (daybd.终端编号=111 and daybd.电表编号=0) or (daybd.终端编号=120 and daybd.电表编号=0) or (daybd.终端编号=140 and daybd.电表编号=0) or (daybd.终端编号=142 and daybd.电表编号=0) or (daybd.终端编号=143 and daybd.电表编号=0) or (daybd.终端编号=144 and daybd.电表编号=0) or (daybd.终端编号=145 and daybd.电表编号=0) or (daybd.终端编号=148 and daybd.电表编号=0) or (daybd.终端编号=153 and daybd.电表编号=0) or (daybd.终端编号=159 and daybd.电表编号=0) or (daybd.终端编号=166 and daybd.电表编号=0) or (daybd.终端编号=171 and daybd.电表编号=0) or (daybd.终端编号=176 and daybd.电表编号=0) or (daybd.终端编号=177 and daybd.电表编号=0) or (daybd.终端编号=178 and daybd.电表编号=0) or (daybd.终端编号=197 and daybd.电表编号=0) or (daybd.终端编号=200 and daybd.电表编号=0) or (daybd.终端编号=205 and daybd.电表编号=0) or (daybd.终端编号=210 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=0) or (daybd.终端编号=217 and daybd.电表编号=0) or (daybd.终端编号=218 and daybd.电表编号=0) or (daybd.终端编号=222 and daybd.电表编号=0) or (daybd.终端编号=238 and daybd.电表编号=0) or (daybd.终端编号=250 and daybd.电表编号=0) or (daybd.终端编号=255 and daybd.电表编号=0) or (daybd.终端编号=259 and daybd.电表编号=0) or (daybd.终端编号=279 and daybd.电表编号=0) or (daybd.终端编号=286 and daybd.电表编号=0) or (daybd.终端编号=287 and daybd.电表编号=0) or (daybd.终端编号=294 and daybd.电表编号=0) or (daybd.终端编号=883 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=1) or (daybd.终端编号=212 and daybd.电表编号=2) or (daybd.终端编号=44 and daybd.电表编号=0) or (daybd.终端编号=47 and daybd.电表编号=0) or (daybd.终端编号=249 and daybd.电表编号=0) or (daybd.终端编号=10252 and daybd.电表编号=0) or (daybd.终端编号=10332 and daybd.电表编号=0) or (daybd.终端编号=10333 and daybd.电表编号=0) or (daybd.终端编号=11574 and daybd.电表编号=0) ) UNION ALL  Select dbo.FormatDateTime(daybd.数据时间,':','','') as 时间, daybd.* from cbdata.[dbo].[RealBD20121019] daybd where  ((数据日期=20121018 and 数据时间>=0 ) or (数据日期>20121018 and 数据日期<20121028 ) or (数据日期=20121028 and 数据时间<=1500 ))  and  ( (daybd.终端编号=108 and daybd.电表编号=0) or (daybd.终端编号=110 and daybd.电表编号=0) or (daybd.终端编号=111 and daybd.电表编号=0) or (daybd.终端编号=120 and daybd.电表编号=0) or (daybd.终端编号=140 and daybd.电表编号=0) or (daybd.终端编号=142 and daybd.电表编号=0) or (daybd.终端编号=143 and daybd.电表编号=0) or (daybd.终端编号=144 and daybd.电表编号=0) or (daybd.终端编号=145 and daybd.电表编号=0) or (daybd.终端编号=148 and daybd.电表编号=0) or (daybd.终端编号=153 and daybd.电表编号=0) or (daybd.终端编号=159 and daybd.电表编号=0) or (daybd.终端编号=166 and daybd.电表编号=0) or (daybd.终端编号=171 and daybd.电表编号=0) or (daybd.终端编号=176 and daybd.电表编号=0) or (daybd.终端编号=177 and daybd.电表编号=0) or (daybd.终端编号=178 and daybd.电表编号=0) or (daybd.终端编号=197 and daybd.电表编号=0) or (daybd.终端编号=200 and daybd.电表编号=0) or (daybd.终端编号=205 and daybd.电表编号=0) or (daybd.终端编号=210 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=0) or (daybd.终端编号=217 and daybd.电表编号=0) or (daybd.终端编号=218 and daybd.电表编号=0) or (daybd.终端编号=222 and daybd.电表编号=0) or (daybd.终端编号=238 and daybd.电表编号=0) or (daybd.终端编号=250 and daybd.电表编号=0) or (daybd.终端编号=255 and daybd.电表编号=0) or (daybd.终端编号=259 and daybd.电表编号=0) or (daybd.终端编号=279 and daybd.电表编号=0) or (daybd.终端编号=286 and daybd.电表编号=0) or (daybd.终端编号=287 and daybd.电表编号=0) or (daybd.终端编号=294 and daybd.电表编号=0) or (daybd.终端编号=883 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=1) or (daybd.终端编号=212 and daybd.电表编号=2) or (daybd.终端编号=44 and daybd.电表编号=0) or (daybd.终端编号=47 and daybd.电表编号=0) or (daybd.终端编号=249 and daybd.电表编号=0) or (daybd.终端编号=10252 and daybd.电表编号=0) or (daybd.终端编号=10332 and daybd.电表编号=0) or (daybd.终端编号=10333 and daybd.电表编号=0) or (daybd.终端编号=11574 and daybd.电表编号=0) ) UNION ALL  Select dbo.FormatDateTime(daybd.数据时间,':','','') as 时间, daybd.* from cbdata.[dbo].[RealBD20121020] daybd where  ((数据日期=20121018 and 数据时间>=0 ) or (数据日期>20121018 and 数据日期<20121028 ) or (数据日期=20121028 and 数据时间<=1500 ))  and  ( (daybd.终端编号=108 and daybd.电表编号=0) or (daybd.终端编号=110 and daybd.电表编号=0) or (daybd.终端编号=111 and daybd.电表编号=0) or (daybd.终端编号=120 and daybd.电表编号=0) or (daybd.终端编号=140 and daybd.电表编号=0) or (daybd.终端编号=142 and daybd.电表编号=0) or (daybd.终端编号=143 and daybd.电表编号=0) or (daybd.终端编号=144 and daybd.电表编号=0) or (daybd.终端编号=145 and daybd.电表编号=0) or (daybd.终端编号=148 and daybd.电表编号=0) or (daybd.终端编号=153 and daybd.电表编号=0) or (daybd.终端编号=159 and daybd.电表编号=0) or (daybd.终端编号=166 and daybd.电表编号=0) or (daybd.终端编号=171 and daybd.电表编号=0) or (daybd.终端编号=176 and daybd.电表编号=0) or (daybd.终端编号=177 and daybd.电表编号=0) or (daybd.终端编号=178 and daybd.电表编号=0) or (daybd.终端编号=197 and daybd.电表编号=0) or (daybd.终端编号=200 and daybd.电表编号=0) or (daybd.终端编号=205 and daybd.电表编号=0) or (daybd.终端编号=210 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=0) or (daybd.终端编号=217 and daybd.电表编号=0) or (daybd.终端编号=218 and daybd.电表编号=0) or (daybd.终端编号=222 and daybd.电表编号=0) or (daybd.终端编号=238 and daybd.电表编号=0) or (daybd.终端编号=250 and daybd.电表编号=0) or (daybd.终端编号=255 and daybd.电表编号=0) or (daybd.终端编号=259 and daybd.电表编号=0) or (daybd.终端编号=279 and daybd.电表编号=0) or (daybd.终端编号=286 and daybd.电表编号=0) or (daybd.终端编号=287 and daybd.电表编号=0) or (daybd.终端编号=294 and daybd.电表编号=0) or (daybd.终端编号=883 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=1) or (daybd.终端编号=212 and daybd.电表编号=2) or (daybd.终端编号=44 and daybd.电表编号=0) or (daybd.终端编号=47 and daybd.电表编号=0) or (daybd.终端编号=249 and daybd.电表编号=0) or (daybd.终端编号=10252 and daybd.电表编号=0) or (daybd.终端编号=10332 and daybd.电表编号=0) or (daybd.终端编号=10333 and daybd.电表编号=0) or (daybd.终端编号=11574 and daybd.电表编号=0) ) UNION ALL  Select dbo.FormatDateTime(daybd.数据时间,':','','') as 时间, daybd.* from cbdata.[dbo].[RealBD20121021] daybd where  ((数据日期=20121018 and 数据时间>=0 ) or (数据日期>20121018 and 数据日期<20121028 ) or (数据日期=20121028 and 数据时间<=1500 ))  and  ( (daybd.终端编号=108 and daybd.电表编号=0) or (daybd.终端编号=110 and daybd.电表编号=0) or (daybd.终端编号=111 and daybd.电表编号=0) or (daybd.终端编号=120 and daybd.电表编号=0) or (daybd.终端编号=140 and daybd.电表编号=0) or (daybd.终端编号=142 and daybd.电表编号=0) or (daybd.终端编号=143 and daybd.电表编号=0) or (daybd.终端编号=144 and daybd.电表编号=0) or (daybd.终端编号=145 and daybd.电表编号=0) or (daybd.终端编号=148 and daybd.电表编号=0) or (daybd.终端编号=153 and daybd.电表编号=0) or (daybd.终端编号=159 and daybd.电表编号=0) or (daybd.终端编号=166 and daybd.电表编号=0) or (daybd.终端编号=171 and daybd.电表编号=0) or (daybd.终端编号=176 and daybd.电表编号=0) or (daybd.终端编号=177 and daybd.电表编号=0) or (daybd.终端编号=178 and daybd.电表编号=0) or (daybd.终端编号=197 and daybd.电表编号=0) or (daybd.终端编号=200 and daybd.电表编号=0) or (daybd.终端编号=205 and daybd.电表编号=0) or (daybd.终端编号=210 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=0) or (daybd.终端编号=217 and daybd.电表编号=0) or (daybd.终端编号=218 and daybd.电表编号=0) or (daybd.终端编号=222 and daybd.电表编号=0) or (daybd.终端编号=238 and daybd.电表编号=0) or (daybd.终端编号=250 and daybd.电表编号=0) or (daybd.终端编号=255 and daybd.电表编号=0) or (daybd.终端编号=259 and daybd.电表编号=0) or (daybd.终端编号=279 and daybd.电表编号=0) or (daybd.终端编号=286 and daybd.电表编号=0) or (daybd.终端编号=287 and daybd.电表编号=0) or (daybd.终端编号=294 and daybd.电表编号=0) or (daybd.终端编号=883 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=1) or (daybd.终端编号=212 and daybd.电表编号=2) or (daybd.终端编号=44 and daybd.电表编号=0) or (daybd.终端编号=47 and daybd.电表编号=0) or (daybd.终端编号=249 and daybd.电表编号=0) or (daybd.终端编号=10252 and daybd.电表编号=0) or (daybd.终端编号=10332 and daybd.电表编号=0) or (daybd.终端编号=10333 and daybd.电表编号=0) or (daybd.终端编号=11574 and daybd.电表编号=0) ) UNION ALL  Select dbo.FormatDateTime(daybd.数据时间,':','','') as 时间, daybd.* from cbdata.[dbo].[RealBD20121022] daybd where  ((数据日期=20121018 and 数据时间>=0 ) or (数据日期>20121018 and 数据日期<20121028 ) or (数据日期=20121028 and 数据时间<=1500 ))  and  ( (daybd.终端编号=108 and daybd.电表编号=0) or (daybd.终端编号=110 and daybd.电表编号=0) or (daybd.终端编号=111 and daybd.电表编号=0) or (daybd.终端编号=120 and daybd.电表编号=0) or (daybd.终端编号=140 and daybd.电表编号=0) or (daybd.终端编号=142 and daybd.电表编号=0) or (daybd.终端编号=143 and daybd.电表编号=0) or (daybd.终端编号=144 and daybd.电表编号=0) or (daybd.终端编号=145 and daybd.电表编号=0) or (daybd.终端编号=148 and daybd.电表编号=0) or (daybd.终端编号=153 and daybd.电表编号=0) or (daybd.终端编号=159 and daybd.电表编号=0) or (daybd.终端编号=166 and daybd.电表编号=0) or (daybd.终端编号=171 and daybd.电表编号=0) or (daybd.终端编号=176 and daybd.电表编号=0) or (daybd.终端编号=177 and daybd.电表编号=0) or (daybd.终端编号=178 and daybd.电表编号=0) or (daybd.终端编号=197 and daybd.电表编号=0) or (daybd.终端编号=200 and daybd.电表编号=0) or (daybd.终端编号=205 and daybd.电表编号=0) or (daybd.终端编号=210 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=0) or (daybd.终端编号=217 and daybd.电表编号=0) or (daybd.终端编号=218 and daybd.电表编号=0) or (daybd.终端编号=222 and daybd.电表编号=0) or (daybd.终端编号=238 and daybd.电表编号=0) or (daybd.终端编号=250 and daybd.电表编号=0) or (daybd.终端编号=255 and daybd.电表编号=0) or (daybd.终端编号=259 and daybd.电表编号=0) or (daybd.终端编号=279 and daybd.电表编号=0) or (daybd.终端编号=286 and daybd.电表编号=0) or (daybd.终端编号=287 and daybd.电表编号=0) or (daybd.终端编号=294 and daybd.电表编号=0) or (daybd.终端编号=883 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=1) or (daybd.终端编号=212 and daybd.电表编号=2) or (daybd.终端编号=44 and daybd.电表编号=0) or (daybd.终端编号=47 and daybd.电表编号=0) or (daybd.终端编号=249 and daybd.电表编号=0) or (daybd.终端编号=10252 and daybd.电表编号=0) or (daybd.终端编号=10332 and daybd.电表编号=0) or (daybd.终端编号=10333 and daybd.电表编号=0) or (daybd.终端编号=11574 and daybd.电表编号=0) ) UNION ALL  Select dbo.FormatDateTime(daybd.数据时间,':','','') as 时间, daybd.* from cbdata.[dbo].[RealBD20121023] daybd where  ((数据日期=20121018 and 数据时间>=0 ) or (数据日期>20121018 and 数据日期<20121028 ) or (数据日期=20121028 and 数据时间<=1500 ))  and  ( (daybd.终端编号=108 and daybd.电表编号=0) or (daybd.终端编号=110 and daybd.电表编号=0) or (daybd.终端编号=111 and daybd.电表编号=0) or (daybd.终端编号=120 and daybd.电表编号=0) or (daybd.终端编号=140 and daybd.电表编号=0) or (daybd.终端编号=142 and daybd.电表编号=0) or (daybd.终端编号=143 and daybd.电表编号=0) or (daybd.终端编号=144 and daybd.电表编号=0) or (daybd.终端编号=145 and daybd.电表编号=0) or (daybd.终端编号=148 and daybd.电表编号=0) or (daybd.终端编号=153 and daybd.电表编号=0) or (daybd.终端编号=159 and daybd.电表编号=0) or (daybd.终端编号=166 and daybd.电表编号=0) or (daybd.终端编号=171 and daybd.电表编号=0) or (daybd.终端编号=176 and daybd.电表编号=0) or (daybd.终端编号=177 and daybd.电表编号=0) or (daybd.终端编号=178 and daybd.电表编号=0) or (daybd.终端编号=197 and daybd.电表编号=0) or (daybd.终端编号=200 and daybd.电表编号=0) or (daybd.终端编号=205 and daybd.电表编号=0) or (daybd.终端编号=210 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=0) or (daybd.终端编号=217 and daybd.电表编号=0) or (daybd.终端编号=218 and daybd.电表编号=0) or (daybd.终端编号=222 and daybd.电表编号=0) or (daybd.终端编号=238 and daybd.电表编号=0) or (daybd.终端编号=250 and daybd.电表编号=0) or (daybd.终端编号=255 and daybd.电表编号=0) or (daybd.终端编号=259 and daybd.电表编号=0) or (daybd.终端编号=279 and daybd.电表编号=0) or (daybd.终端编号=286 and daybd.电表编号=0) or (daybd.终端编号=287 and daybd.电表编号=0) or (daybd.终端编号=294 and daybd.电表编号=0) or (daybd.终端编号=883 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=1) or (daybd.终端编号=212 and daybd.电表编号=2) or (daybd.终端编号=44 and daybd.电表编号=0) or (daybd.终端编号=47 and daybd.电表编号=0) or (daybd.终端编号=249 and daybd.电表编号=0) or (daybd.终端编号=10252 and daybd.电表编号=0) or (daybd.终端编号=10332 and daybd.电表编号=0) or (daybd.终端编号=10333 and daybd.电表编号=0) or (daybd.终端编号=11574 and daybd.电表编号=0) ) UNION ALL  Select dbo.FormatDateTime(daybd.数据时间,':','','') as 时间, daybd.* from cbdata.[dbo].[RealBD20121024] daybd where  ((数据日期=20121018 and 数据时间>=0 ) or (数据日期>20121018 and 数据日期<20121028 ) or (数据日期=20121028 and 数据时间<=1500 ))  and  ( (daybd.终端编号=108 and daybd.电表编号=0) or (daybd.终端编号=110 and daybd.电表编号=0) or (daybd.终端编号=111 and daybd.电表编号=0) or (daybd.终端编号=120 and daybd.电表编号=0) or (daybd.终端编号=140 and daybd.电表编号=0) or (daybd.终端编号=142 and daybd.电表编号=0) or (daybd.终端编号=143 and daybd.电表编号=0) or (daybd.终端编号=144 and daybd.电表编号=0) or (daybd.终端编号=145 and daybd.电表编号=0) or (daybd.终端编号=148 and daybd.电表编号=0) or (daybd.终端编号=153 and daybd.电表编号=0) or (daybd.终端编号=159 and daybd.电表编号=0) or (daybd.终端编号=166 and daybd.电表编号=0) or (daybd.终端编号=171 and daybd.电表编号=0) or (daybd.终端编号=176 and daybd.电表编号=0) or (daybd.终端编号=177 and daybd.电表编号=0) or (daybd.终端编号=178 and daybd.电表编号=0) or (daybd.终端编号=197 and daybd.电表编号=0) or (daybd.终端编号=200 and daybd.电表编号=0) or (daybd.终端编号=205 and daybd.电表编号=0) or (daybd.终端编号=210 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=0) or (daybd.终端编号=217 and daybd.电表编号=0) or (daybd.终端编号=218 and daybd.电表编号=0) or (daybd.终端编号=222 and daybd.电表编号=0) or (daybd.终端编号=238 and daybd.电表编号=0) or (daybd.终端编号=250 and daybd.电表编号=0) or (daybd.终端编号=255 and daybd.电表编号=0) or (daybd.终端编号=259 and daybd.电表编号=0) or (daybd.终端编号=279 and daybd.电表编号=0) or (daybd.终端编号=286 and daybd.电表编号=0) or (daybd.终端编号=287 and daybd.电表编号=0) or (daybd.终端编号=294 and daybd.电表编号=0) or (daybd.终端编号=883 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=1) or (daybd.终端编号=212 and daybd.电表编号=2) or (daybd.终端编号=44 and daybd.电表编号=0) or (daybd.终端编号=47 and daybd.电表编号=0) or (daybd.终端编号=249 and daybd.电表编号=0) or (daybd.终端编号=10252 and daybd.电表编号=0) or (daybd.终端编号=10332 and daybd.电表编号=0) or (daybd.终端编号=10333 and daybd.电表编号=0) or (daybd.终端编号=11574 and daybd.电表编号=0) ) UNION ALL  Select dbo.FormatDateTime(daybd.数据时间,':','','') as 时间, daybd.* from cbdata.[dbo].[RealBD20121025] daybd where  ((数据日期=20121018 and 数据时间>=0 ) or (数据日期>20121018 and 数据日期<20121028 ) or (数据日期=20121028 and 数据时间<=1500 ))  and  ( (daybd.终端编号=108 and daybd.电表编号=0) or (daybd.终端编号=110 and daybd.电表编号=0) or (daybd.终端编号=111 and daybd.电表编号=0) or (daybd.终端编号=120 and daybd.电表编号=0) or (daybd.终端编号=140 and daybd.电表编号=0) or (daybd.终端编号=142 and daybd.电表编号=0) or (daybd.终端编号=143 and daybd.电表编号=0) or (daybd.终端编号=144 and daybd.电表编号=0) or (daybd.终端编号=145 and daybd.电表编号=0) or (daybd.终端编号=148 and daybd.电表编号=0) or (daybd.终端编号=153 and daybd.电表编号=0) or (daybd.终端编号=159 and daybd.电表编号=0) or (daybd.终端编号=166 and daybd.电表编号=0) or (daybd.终端编号=171 and daybd.电表编号=0) or (daybd.终端编号=176 and daybd.电表编号=0) or (daybd.终端编号=177 and daybd.电表编号=0) or (daybd.终端编号=178 and daybd.电表编号=0) or (daybd.终端编号=197 and daybd.电表编号=0) or (daybd.终端编号=200 and daybd.电表编号=0) or (daybd.终端编号=205 and daybd.电表编号=0) or (daybd.终端编号=210 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=0) or (daybd.终端编号=217 and daybd.电表编号=0) or (daybd.终端编号=218 and daybd.电表编号=0) or (daybd.终端编号=222 and daybd.电表编号=0) or (daybd.终端编号=238 and daybd.电表编号=0) or (daybd.终端编号=250 and daybd.电表编号=0) or (daybd.终端编号=255 and daybd.电表编号=0) or (daybd.终端编号=259 and daybd.电表编号=0) or (daybd.终端编号=279 and daybd.电表编号=0) or (daybd.终端编号=286 and daybd.电表编号=0) or (daybd.终端编号=287 and daybd.电表编号=0) or (daybd.终端编号=294 and daybd.电表编号=0) or (daybd.终端编号=883 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=1) or (daybd.终端编号=212 and daybd.电表编号=2) or (daybd.终端编号=44 and daybd.电表编号=0) or (daybd.终端编号=47 and daybd.电表编号=0) or (daybd.终端编号=249 and daybd.电表编号=0) or (daybd.终端编号=10252 and daybd.电表编号=0) or (daybd.终端编号=10332 and daybd.电表编号=0) or (daybd.终端编号=10333 and daybd.电表编号=0) or (daybd.终端编号=11574 and daybd.电表编号=0) ) UNION ALL  Select dbo.FormatDateTime(daybd.数据时间,':','','') as 时间, daybd.* from cbdata.[dbo].[RealBD20121026] daybd where  ((数据日期=20121018 and 数据时间>=0 ) or (数据日期>20121018 and 数据日期<20121028 ) or (数据日期=20121028 and 数据时间<=1500 ))  and  ( (daybd.终端编号=108 and daybd.电表编号=0) or (daybd.终端编号=110 and daybd.电表编号=0) or (daybd.终端编号=111 and daybd.电表编号=0) or (daybd.终端编号=120 and daybd.电表编号=0) or (daybd.终端编号=140 and daybd.电表编号=0) or (daybd.终端编号=142 and daybd.电表编号=0) or (daybd.终端编号=143 and daybd.电表编号=0) or (daybd.终端编号=144 and daybd.电表编号=0) or (daybd.终端编号=145 and daybd.电表编号=0) or (daybd.终端编号=148 and daybd.电表编号=0) or (daybd.终端编号=153 and daybd.电表编号=0) or (daybd.终端编号=159 and daybd.电表编号=0) or (daybd.终端编号=166 and daybd.电表编号=0) or (daybd.终端编号=171 and daybd.电表编号=0) or (daybd.终端编号=176 and daybd.电表编号=0) or (daybd.终端编号=177 and daybd.电表编号=0) or (daybd.终端编号=178 and daybd.电表编号=0) or (daybd.终端编号=197 and daybd.电表编号=0) or (daybd.终端编号=200 and daybd.电表编号=0) or (daybd.终端编号=205 and daybd.电表编号=0) or (daybd.终端编号=210 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=0) or (daybd.终端编号=217 and daybd.电表编号=0) or (daybd.终端编号=218 and daybd.电表编号=0) or (daybd.终端编号=222 and daybd.电表编号=0) or (daybd.终端编号=238 and daybd.电表编号=0) or (daybd.终端编号=250 and daybd.电表编号=0) or (daybd.终端编号=255 and daybd.电表编号=0) or (daybd.终端编号=259 and daybd.电表编号=0) or (daybd.终端编号=279 and daybd.电表编号=0) or (daybd.终端编号=286 and daybd.电表编号=0) or (daybd.终端编号=287 and daybd.电表编号=0) or (daybd.终端编号=294 and daybd.电表编号=0) or (daybd.终端编号=883 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=1) or (daybd.终端编号=212 and daybd.电表编号=2) or (daybd.终端编号=44 and daybd.电表编号=0) or (daybd.终端编号=47 and daybd.电表编号=0) or (daybd.终端编号=249 and daybd.电表编号=0) or (daybd.终端编号=10252 and daybd.电表编号=0) or (daybd.终端编号=10332 and daybd.电表编号=0) or (daybd.终端编号=10333 and daybd.电表编号=0) or (daybd.终端编号=11574 and daybd.电表编号=0) ) UNION ALL  Select dbo.FormatDateTime(daybd.数据时间,':','','') as 时间, daybd.* from cbdata.[dbo].[RealBD20121027] daybd where  ((数据日期=20121018 and 数据时间>=0 ) or (数据日期>20121018 and 数据日期<20121028 ) or (数据日期=20121028 and 数据时间<=1500 ))  and  ( (daybd.终端编号=108 and daybd.电表编号=0) or (daybd.终端编号=110 and daybd.电表编号=0) or (daybd.终端编号=111 and daybd.电表编号=0) or (daybd.终端编号=120 and daybd.电表编号=0) or (daybd.终端编号=140 and daybd.电表编号=0) or (daybd.终端编号=142 and daybd.电表编号=0) or (daybd.终端编号=143 and daybd.电表编号=0) or (daybd.终端编号=144 and daybd.电表编号=0) or (daybd.终端编号=145 and daybd.电表编号=0) or (daybd.终端编号=148 and daybd.电表编号=0) or (daybd.终端编号=153 and daybd.电表编号=0) or (daybd.终端编号=159 and daybd.电表编号=0) or (daybd.终端编号=166 and daybd.电表编号=0) or (daybd.终端编号=171 and daybd.电表编号=0) or (daybd.终端编号=176 and daybd.电表编号=0) or (daybd.终端编号=177 and daybd.电表编号=0) or (daybd.终端编号=178 and daybd.电表编号=0) or (daybd.终端编号=197 and daybd.电表编号=0) or (daybd.终端编号=200 and daybd.电表编号=0) or (daybd.终端编号=205 and daybd.电表编号=0) or (daybd.终端编号=210 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=0) or (daybd.终端编号=217 and daybd.电表编号=0) or (daybd.终端编号=218 and daybd.电表编号=0) or (daybd.终端编号=222 and daybd.电表编号=0) or (daybd.终端编号=238 and daybd.电表编号=0) or (daybd.终端编号=250 and daybd.电表编号=0) or (daybd.终端编号=255 and daybd.电表编号=0) or (daybd.终端编号=259 and daybd.电表编号=0) or (daybd.终端编号=279 and daybd.电表编号=0) or (daybd.终端编号=286 and daybd.电表编号=0) or (daybd.终端编号=287 and daybd.电表编号=0) or (daybd.终端编号=294 and daybd.电表编号=0) or (daybd.终端编号=883 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=1) or (daybd.终端编号=212 and daybd.电表编号=2) or (daybd.终端编号=44 and daybd.电表编号=0) or (daybd.终端编号=47 and daybd.电表编号=0) or (daybd.终端编号=249 and daybd.电表编号=0) or (daybd.终端编号=10252 and daybd.电表编号=0) or (daybd.终端编号=10332 and daybd.电表编号=0) or (daybd.终端编号=10333 and daybd.电表编号=0) or (daybd.终端编号=11574 and daybd.电表编号=0) ) UNION ALL  Select dbo.FormatDateTime(daybd.数据时间,':','','') as 时间, daybd.* from cbdata.[dbo].[RealBD20121028] daybd where  ((数据日期=20121018 and 数据时间>=0 ) or (数据日期>20121018 and 数据日期<20121028 ) or (数据日期=20121028 and 数据时间<=1500 ))  and  ( (daybd.终端编号=108 and daybd.电表编号=0) or (daybd.终端编号=110 and daybd.电表编号=0) or (daybd.终端编号=111 and daybd.电表编号=0) or (daybd.终端编号=120 and daybd.电表编号=0) or (daybd.终端编号=140 and daybd.电表编号=0) or (daybd.终端编号=142 and daybd.电表编号=0) or (daybd.终端编号=143 and daybd.电表编号=0) or (daybd.终端编号=144 and daybd.电表编号=0) or (daybd.终端编号=145 and daybd.电表编号=0) or (daybd.终端编号=148 and daybd.电表编号=0) or (daybd.终端编号=153 and daybd.电表编号=0) or (daybd.终端编号=159 and daybd.电表编号=0) or (daybd.终端编号=166 and daybd.电表编号=0) or (daybd.终端编号=171 and daybd.电表编号=0) or (daybd.终端编号=176 and daybd.电表编号=0) or (daybd.终端编号=177 and daybd.电表编号=0) or (daybd.终端编号=178 and daybd.电表编号=0) or (daybd.终端编号=197 and daybd.电表编号=0) or (daybd.终端编号=200 and daybd.电表编号=0) or (daybd.终端编号=205 and daybd.电表编号=0) or (daybd.终端编号=210 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=0) or (daybd.终端编号=217 and daybd.电表编号=0) or (daybd.终端编号=218 and daybd.电表编号=0) or (daybd.终端编号=222 and daybd.电表编号=0) or (daybd.终端编号=238 and daybd.电表编号=0) or (daybd.终端编号=250 and daybd.电表编号=0) or (daybd.终端编号=255 and daybd.电表编号=0) or (daybd.终端编号=259 and daybd.电表编号=0) or (daybd.终端编号=279 and daybd.电表编号=0) or (daybd.终端编号=286 and daybd.电表编号=0) or (daybd.终端编号=287 and daybd.电表编号=0) or (daybd.终端编号=294 and daybd.电表编号=0) or (daybd.终端编号=883 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=1) or (daybd.终端编号=212 and daybd.电表编号=2) or (daybd.终端编号=44 and daybd.电表编号=0) or (daybd.终端编号=47 and daybd.电表编号=0) or (daybd.终端编号=249 and daybd.电表编号=0) or (daybd.终端编号=10252 and daybd.电表编号=0) or (daybd.终端编号=10332 and daybd.电表编号=0) or (daybd.终端编号=10333 and daybd.电表编号=0) or (daybd.终端编号=11574 and daybd.电表编号=0) )) aa on dbcsb.编号=aa.电表编号 and dbcsb.终端编号=aa.终端编号  order by aa.终端编号,aa.电表编号,aa.数据日期,aa.数据时间;
--select * from @indextable
select * from (select top 100 percent ROW_NUMBER() over(order by aa.终端编号,aa.电表编号,aa.数据日期,aa.数据时间) as rownum2, dbcsb.ID ID1,dbcsb.终端名称,dbcsb.描述 as 电表名称,dbcsb.使用属性,aa.* from [yhcbpara].[dbo].[YH电表参数表视图_无虚拟表] dbcsb

right join(Select dbo.FormatDateTime(daybd.数据时间,':','','') as 时间, daybd.* from cbdata.[dbo].[RealBD20121019] daybd where  ((数据日期=20121019 and 数据时间>=0 ) or (数据日期>20121019 and 数据日期<20121029 ) or (数据日期=20121029 and 数据时间<=1100 ))  and  ( (daybd.终端编号=108 and daybd.电表编号=0) or (daybd.终端编号=110 and daybd.电表编号=0) or (daybd.终端编号=111 and daybd.电表编号=0) or (daybd.终端编号=120 and daybd.电表编号=0) or (daybd.终端编号=140 and daybd.电表编号=0) or (daybd.终端编号=142 and daybd.电表编号=0) or (daybd.终端编号=143 and daybd.电表编号=0) or (daybd.终端编号=144 and daybd.电表编号=0) or (daybd.终端编号=145 and daybd.电表编号=0) or (daybd.终端编号=148 and daybd.电表编号=0) or (daybd.终端编号=153 and daybd.电表编号=0) or (daybd.终端编号=159 and daybd.电表编号=0) or (daybd.终端编号=166 and daybd.电表编号=0) or (daybd.终端编号=171 and daybd.电表编号=0) or (daybd.终端编号=176 and daybd.电表编号=0) or (daybd.终端编号=177 and daybd.电表编号=0) or (daybd.终端编号=178 and daybd.电表编号=0) or (daybd.终端编号=197 and daybd.电表编号=0) or (daybd.终端编号=200 and daybd.电表编号=0) or (daybd.终端编号=205 and daybd.电表编号=0) or (daybd.终端编号=210 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=0) or (daybd.终端编号=217 and daybd.电表编号=0) or (daybd.终端编号=218 and daybd.电表编号=0) or (daybd.终端编号=222 and daybd.电表编号=0) or (daybd.终端编号=238 and daybd.电表编号=0) or (daybd.终端编号=250 and daybd.电表编号=0) or (daybd.终端编号=255 and daybd.电表编号=0) or (daybd.终端编号=259 and daybd.电表编号=0) or (daybd.终端编号=279 and daybd.电表编号=0) or (daybd.终端编号=286 and daybd.电表编号=0) or (daybd.终端编号=287 and daybd.电表编号=0) or (daybd.终端编号=294 and daybd.电表编号=0) or (daybd.终端编号=883 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=1) or (daybd.终端编号=212 and daybd.电表编号=2) or (daybd.终端编号=44 and daybd.电表编号=0) or (daybd.终端编号=47 and daybd.电表编号=0) or (daybd.终端编号=249 and daybd.电表编号=0) or (daybd.终端编号=10252 and daybd.电表编号=0) or (daybd.终端编号=10332 and daybd.电表编号=0) or (daybd.终端编号=10333 and daybd.电表编号=0) or (daybd.终端编号=11574 and daybd.电表编号=0) ) UNION ALL  Select dbo.FormatDateTime(daybd.数据时间,':','','') as 时间, daybd.* from cbdata.[dbo].[RealBD20121020] daybd where  ((数据日期=20121019 and 数据时间>=0 ) or (数据日期>20121019 and 数据日期<20121029 ) or (数据日期=20121029 and 数据时间<=1100 ))  and  ( (daybd.终端编号=108 and daybd.电表编号=0) or (daybd.终端编号=110 and daybd.电表编号=0) or (daybd.终端编号=111 and daybd.电表编号=0) or (daybd.终端编号=120 and daybd.电表编号=0) or (daybd.终端编号=140 and daybd.电表编号=0) or (daybd.终端编号=142 and daybd.电表编号=0) or (daybd.终端编号=143 and daybd.电表编号=0) or (daybd.终端编号=144 and daybd.电表编号=0) or (daybd.终端编号=145 and daybd.电表编号=0) or (daybd.终端编号=148 and daybd.电表编号=0) or (daybd.终端编号=153 and daybd.电表编号=0) or (daybd.终端编号=159 and daybd.电表编号=0) or (daybd.终端编号=166 and daybd.电表编号=0) or (daybd.终端编号=171 and daybd.电表编号=0) or (daybd.终端编号=176 and daybd.电表编号=0) or (daybd.终端编号=177 and daybd.电表编号=0) or (daybd.终端编号=178 and daybd.电表编号=0) or (daybd.终端编号=197 and daybd.电表编号=0) or (daybd.终端编号=200 and daybd.电表编号=0) or (daybd.终端编号=205 and daybd.电表编号=0) or (daybd.终端编号=210 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=0) or (daybd.终端编号=217 and daybd.电表编号=0) or (daybd.终端编号=218 and daybd.电表编号=0) or (daybd.终端编号=222 and daybd.电表编号=0) or (daybd.终端编号=238 and daybd.电表编号=0) or (daybd.终端编号=250 and daybd.电表编号=0) or (daybd.终端编号=255 and daybd.电表编号=0) or (daybd.终端编号=259 and daybd.电表编号=0) or (daybd.终端编号=279 and daybd.电表编号=0) or (daybd.终端编号=286 and daybd.电表编号=0) or (daybd.终端编号=287 and daybd.电表编号=0) or (daybd.终端编号=294 and daybd.电表编号=0) or (daybd.终端编号=883 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=1) or (daybd.终端编号=212 and daybd.电表编号=2) or (daybd.终端编号=44 and daybd.电表编号=0) or (daybd.终端编号=47 and daybd.电表编号=0) or (daybd.终端编号=249 and daybd.电表编号=0) or (daybd.终端编号=10252 and daybd.电表编号=0) or (daybd.终端编号=10332 and daybd.电表编号=0) or (daybd.终端编号=10333 and daybd.电表编号=0) or (daybd.终端编号=11574 and daybd.电表编号=0) ) UNION ALL  Select dbo.FormatDateTime(daybd.数据时间,':','','') as 时间, daybd.* from cbdata.[dbo].[RealBD20121021] daybd where  ((数据日期=20121019 and 数据时间>=0 ) or (数据日期>20121019 and 数据日期<20121029 ) or (数据日期=20121029 and 数据时间<=1100 ))  and  ( (daybd.终端编号=108 and daybd.电表编号=0) or (daybd.终端编号=110 and daybd.电表编号=0) or (daybd.终端编号=111 and daybd.电表编号=0) or (daybd.终端编号=120 and daybd.电表编号=0) or (daybd.终端编号=140 and daybd.电表编号=0) or (daybd.终端编号=142 and daybd.电表编号=0) or (daybd.终端编号=143 and daybd.电表编号=0) or (daybd.终端编号=144 and daybd.电表编号=0) or (daybd.终端编号=145 and daybd.电表编号=0) or (daybd.终端编号=148 and daybd.电表编号=0) or (daybd.终端编号=153 and daybd.电表编号=0) or (daybd.终端编号=159 and daybd.电表编号=0) or (daybd.终端编号=166 and daybd.电表编号=0) or (daybd.终端编号=171 and daybd.电表编号=0) or (daybd.终端编号=176 and daybd.电表编号=0) or (daybd.终端编号=177 and daybd.电表编号=0) or (daybd.终端编号=178 and daybd.电表编号=0) or (daybd.终端编号=197 and daybd.电表编号=0) or (daybd.终端编号=200 and daybd.电表编号=0) or (daybd.终端编号=205 and daybd.电表编号=0) or (daybd.终端编号=210 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=0) or (daybd.终端编号=217 and daybd.电表编号=0) or (daybd.终端编号=218 and daybd.电表编号=0) or (daybd.终端编号=222 and daybd.电表编号=0) or (daybd.终端编号=238 and daybd.电表编号=0) or (daybd.终端编号=250 and daybd.电表编号=0) or (daybd.终端编号=255 and daybd.电表编号=0) or (daybd.终端编号=259 and daybd.电表编号=0) or (daybd.终端编号=279 and daybd.电表编号=0) or (daybd.终端编号=286 and daybd.电表编号=0) or (daybd.终端编号=287 and daybd.电表编号=0) or (daybd.终端编号=294 and daybd.电表编号=0) or (daybd.终端编号=883 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=1) or (daybd.终端编号=212 and daybd.电表编号=2) or (daybd.终端编号=44 and daybd.电表编号=0) or (daybd.终端编号=47 and daybd.电表编号=0) or (daybd.终端编号=249 and daybd.电表编号=0) or (daybd.终端编号=10252 and daybd.电表编号=0) or (daybd.终端编号=10332 and daybd.电表编号=0) or (daybd.终端编号=10333 and daybd.电表编号=0) or (daybd.终端编号=11574 and daybd.电表编号=0) ) UNION ALL  Select dbo.FormatDateTime(daybd.数据时间,':','','') as 时间, daybd.* from cbdata.[dbo].[RealBD20121022] daybd where  ((数据日期=20121019 and 数据时间>=0 ) or (数据日期>20121019 and 数据日期<20121029 ) or (数据日期=20121029 and 数据时间<=1100 ))  and  ( (daybd.终端编号=108 and daybd.电表编号=0) or (daybd.终端编号=110 and daybd.电表编号=0) or (daybd.终端编号=111 and daybd.电表编号=0) or (daybd.终端编号=120 and daybd.电表编号=0) or (daybd.终端编号=140 and daybd.电表编号=0) or (daybd.终端编号=142 and daybd.电表编号=0) or (daybd.终端编号=143 and daybd.电表编号=0) or (daybd.终端编号=144 and daybd.电表编号=0) or (daybd.终端编号=145 and daybd.电表编号=0) or (daybd.终端编号=148 and daybd.电表编号=0) or (daybd.终端编号=153 and daybd.电表编号=0) or (daybd.终端编号=159 and daybd.电表编号=0) or (daybd.终端编号=166 and daybd.电表编号=0) or (daybd.终端编号=171 and daybd.电表编号=0) or (daybd.终端编号=176 and daybd.电表编号=0) or (daybd.终端编号=177 and daybd.电表编号=0) or (daybd.终端编号=178 and daybd.电表编号=0) or (daybd.终端编号=197 and daybd.电表编号=0) or (daybd.终端编号=200 and daybd.电表编号=0) or (daybd.终端编号=205 and daybd.电表编号=0) or (daybd.终端编号=210 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=0) or (daybd.终端编号=217 and daybd.电表编号=0) or (daybd.终端编号=218 and daybd.电表编号=0) or (daybd.终端编号=222 and daybd.电表编号=0) or (daybd.终端编号=238 and daybd.电表编号=0) or (daybd.终端编号=250 and daybd.电表编号=0) or (daybd.终端编号=255 and daybd.电表编号=0) or (daybd.终端编号=259 and daybd.电表编号=0) or (daybd.终端编号=279 and daybd.电表编号=0) or (daybd.终端编号=286 and daybd.电表编号=0) or (daybd.终端编号=287 and daybd.电表编号=0) or (daybd.终端编号=294 and daybd.电表编号=0) or (daybd.终端编号=883 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=1) or (daybd.终端编号=212 and daybd.电表编号=2) or (daybd.终端编号=44 and daybd.电表编号=0) or (daybd.终端编号=47 and daybd.电表编号=0) or (daybd.终端编号=249 and daybd.电表编号=0) or (daybd.终端编号=10252 and daybd.电表编号=0) or (daybd.终端编号=10332 and daybd.电表编号=0) or (daybd.终端编号=10333 and daybd.电表编号=0) or (daybd.终端编号=11574 and daybd.电表编号=0) ) UNION ALL  Select dbo.FormatDateTime(daybd.数据时间,':','','') as 时间, daybd.* from cbdata.[dbo].[RealBD20121023] daybd where  ((数据日期=20121019 and 数据时间>=0 ) or (数据日期>20121019 and 数据日期<20121029 ) or (数据日期=20121029 and 数据时间<=1100 ))  and  ( (daybd.终端编号=108 and daybd.电表编号=0) or (daybd.终端编号=110 and daybd.电表编号=0) or (daybd.终端编号=111 and daybd.电表编号=0) or (daybd.终端编号=120 and daybd.电表编号=0) or (daybd.终端编号=140 and daybd.电表编号=0) or (daybd.终端编号=142 and daybd.电表编号=0) or (daybd.终端编号=143 and daybd.电表编号=0) or (daybd.终端编号=144 and daybd.电表编号=0) or (daybd.终端编号=145 and daybd.电表编号=0) or (daybd.终端编号=148 and daybd.电表编号=0) or (daybd.终端编号=153 and daybd.电表编号=0) or (daybd.终端编号=159 and daybd.电表编号=0) or (daybd.终端编号=166 and daybd.电表编号=0) or (daybd.终端编号=171 and daybd.电表编号=0) or (daybd.终端编号=176 and daybd.电表编号=0) or (daybd.终端编号=177 and daybd.电表编号=0) or (daybd.终端编号=178 and daybd.电表编号=0) or (daybd.终端编号=197 and daybd.电表编号=0) or (daybd.终端编号=200 and daybd.电表编号=0) or (daybd.终端编号=205 and daybd.电表编号=0) or (daybd.终端编号=210 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=0) or (daybd.终端编号=217 and daybd.电表编号=0) or (daybd.终端编号=218 and daybd.电表编号=0) or (daybd.终端编号=222 and daybd.电表编号=0) or (daybd.终端编号=238 and daybd.电表编号=0) or (daybd.终端编号=250 and daybd.电表编号=0) or (daybd.终端编号=255 and daybd.电表编号=0) or (daybd.终端编号=259 and daybd.电表编号=0) or (daybd.终端编号=279 and daybd.电表编号=0) or (daybd.终端编号=286 and daybd.电表编号=0) or (daybd.终端编号=287 and daybd.电表编号=0) or (daybd.终端编号=294 and daybd.电表编号=0) or (daybd.终端编号=883 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=1) or (daybd.终端编号=212 and daybd.电表编号=2) or (daybd.终端编号=44 and daybd.电表编号=0) or (daybd.终端编号=47 and daybd.电表编号=0) or (daybd.终端编号=249 and daybd.电表编号=0) or (daybd.终端编号=10252 and daybd.电表编号=0) or (daybd.终端编号=10332 and daybd.电表编号=0) or (daybd.终端编号=10333 and daybd.电表编号=0) or (daybd.终端编号=11574 and daybd.电表编号=0) ) UNION ALL  Select dbo.FormatDateTime(daybd.数据时间,':','','') as 时间, daybd.* from cbdata.[dbo].[RealBD20121024] daybd where  ((数据日期=20121019 and 数据时间>=0 ) or (数据日期>20121019 and 数据日期<20121029 ) or (数据日期=20121029 and 数据时间<=1100 ))  and  ( (daybd.终端编号=108 and daybd.电表编号=0) or (daybd.终端编号=110 and daybd.电表编号=0) or (daybd.终端编号=111 and daybd.电表编号=0) or (daybd.终端编号=120 and daybd.电表编号=0) or (daybd.终端编号=140 and daybd.电表编号=0) or (daybd.终端编号=142 and daybd.电表编号=0) or (daybd.终端编号=143 and daybd.电表编号=0) or (daybd.终端编号=144 and daybd.电表编号=0) or (daybd.终端编号=145 and daybd.电表编号=0) or (daybd.终端编号=148 and daybd.电表编号=0) or (daybd.终端编号=153 and daybd.电表编号=0) or (daybd.终端编号=159 and daybd.电表编号=0) or (daybd.终端编号=166 and daybd.电表编号=0) or (daybd.终端编号=171 and daybd.电表编号=0) or (daybd.终端编号=176 and daybd.电表编号=0) or (daybd.终端编号=177 and daybd.电表编号=0) or (daybd.终端编号=178 and daybd.电表编号=0) or (daybd.终端编号=197 and daybd.电表编号=0) or (daybd.终端编号=200 and daybd.电表编号=0) or (daybd.终端编号=205 and daybd.电表编号=0) or (daybd.终端编号=210 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=0) or (daybd.终端编号=217 and daybd.电表编号=0) or (daybd.终端编号=218 and daybd.电表编号=0) or (daybd.终端编号=222 and daybd.电表编号=0) or (daybd.终端编号=238 and daybd.电表编号=0) or (daybd.终端编号=250 and daybd.电表编号=0) or (daybd.终端编号=255 and daybd.电表编号=0) or (daybd.终端编号=259 and daybd.电表编号=0) or (daybd.终端编号=279 and daybd.电表编号=0) or (daybd.终端编号=286 and daybd.电表编号=0) or (daybd.终端编号=287 and daybd.电表编号=0) or (daybd.终端编号=294 and daybd.电表编号=0) or (daybd.终端编号=883 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=1) or (daybd.终端编号=212 and daybd.电表编号=2) or (daybd.终端编号=44 and daybd.电表编号=0) or (daybd.终端编号=47 and daybd.电表编号=0) or (daybd.终端编号=249 and daybd.电表编号=0) or (daybd.终端编号=10252 and daybd.电表编号=0) or (daybd.终端编号=10332 and daybd.电表编号=0) or (daybd.终端编号=10333 and daybd.电表编号=0) or (daybd.终端编号=11574 and daybd.电表编号=0) ) UNION ALL  Select dbo.FormatDateTime(daybd.数据时间,':','','') as 时间, daybd.* from cbdata.[dbo].[RealBD20121025] daybd where  ((数据日期=20121019 and 数据时间>=0 ) or (数据日期>20121019 and 数据日期<20121029 ) or (数据日期=20121029 and 数据时间<=1100 ))  and  ( (daybd.终端编号=108 and daybd.电表编号=0) or (daybd.终端编号=110 and daybd.电表编号=0) or (daybd.终端编号=111 and daybd.电表编号=0) or (daybd.终端编号=120 and daybd.电表编号=0) or (daybd.终端编号=140 and daybd.电表编号=0) or (daybd.终端编号=142 and daybd.电表编号=0) or (daybd.终端编号=143 and daybd.电表编号=0) or (daybd.终端编号=144 and daybd.电表编号=0) or (daybd.终端编号=145 and daybd.电表编号=0) or (daybd.终端编号=148 and daybd.电表编号=0) or (daybd.终端编号=153 and daybd.电表编号=0) or (daybd.终端编号=159 and daybd.电表编号=0) or (daybd.终端编号=166 and daybd.电表编号=0) or (daybd.终端编号=171 and daybd.电表编号=0) or (daybd.终端编号=176 and daybd.电表编号=0) or (daybd.终端编号=177 and daybd.电表编号=0) or (daybd.终端编号=178 and daybd.电表编号=0) or (daybd.终端编号=197 and daybd.电表编号=0) or (daybd.终端编号=200 and daybd.电表编号=0) or (daybd.终端编号=205 and daybd.电表编号=0) or (daybd.终端编号=210 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=0) or (daybd.终端编号=217 and daybd.电表编号=0) or (daybd.终端编号=218 and daybd.电表编号=0) or (daybd.终端编号=222 and daybd.电表编号=0) or (daybd.终端编号=238 and daybd.电表编号=0) or (daybd.终端编号=250 and daybd.电表编号=0) or (daybd.终端编号=255 and daybd.电表编号=0) or (daybd.终端编号=259 and daybd.电表编号=0) or (daybd.终端编号=279 and daybd.电表编号=0) or (daybd.终端编号=286 and daybd.电表编号=0) or (daybd.终端编号=287 and daybd.电表编号=0) or (daybd.终端编号=294 and daybd.电表编号=0) or (daybd.终端编号=883 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=1) or (daybd.终端编号=212 and daybd.电表编号=2) or (daybd.终端编号=44 and daybd.电表编号=0) or (daybd.终端编号=47 and daybd.电表编号=0) or (daybd.终端编号=249 and daybd.电表编号=0) or (daybd.终端编号=10252 and daybd.电表编号=0) or (daybd.终端编号=10332 and daybd.电表编号=0) or (daybd.终端编号=10333 and daybd.电表编号=0) or (daybd.终端编号=11574 and daybd.电表编号=0) ) UNION ALL  Select dbo.FormatDateTime(daybd.数据时间,':','','') as 时间, daybd.* from cbdata.[dbo].[RealBD20121026] daybd where  ((数据日期=20121019 and 数据时间>=0 ) or (数据日期>20121019 and 数据日期<20121029 ) or (数据日期=20121029 and 数据时间<=1100 ))  and  ( (daybd.终端编号=108 and daybd.电表编号=0) or (daybd.终端编号=110 and daybd.电表编号=0) or (daybd.终端编号=111 and daybd.电表编号=0) or (daybd.终端编号=120 and daybd.电表编号=0) or (daybd.终端编号=140 and daybd.电表编号=0) or (daybd.终端编号=142 and daybd.电表编号=0) or (daybd.终端编号=143 and daybd.电表编号=0) or (daybd.终端编号=144 and daybd.电表编号=0) or (daybd.终端编号=145 and daybd.电表编号=0) or (daybd.终端编号=148 and daybd.电表编号=0) or (daybd.终端编号=153 and daybd.电表编号=0) or (daybd.终端编号=159 and daybd.电表编号=0) or (daybd.终端编号=166 and daybd.电表编号=0) or (daybd.终端编号=171 and daybd.电表编号=0) or (daybd.终端编号=176 and daybd.电表编号=0) or (daybd.终端编号=177 and daybd.电表编号=0) or (daybd.终端编号=178 and daybd.电表编号=0) or (daybd.终端编号=197 and daybd.电表编号=0) or (daybd.终端编号=200 and daybd.电表编号=0) or (daybd.终端编号=205 and daybd.电表编号=0) or (daybd.终端编号=210 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=0) or (daybd.终端编号=217 and daybd.电表编号=0) or (daybd.终端编号=218 and daybd.电表编号=0) or (daybd.终端编号=222 and daybd.电表编号=0) or (daybd.终端编号=238 and daybd.电表编号=0) or (daybd.终端编号=250 and daybd.电表编号=0) or (daybd.终端编号=255 and daybd.电表编号=0) or (daybd.终端编号=259 and daybd.电表编号=0) or (daybd.终端编号=279 and daybd.电表编号=0) or (daybd.终端编号=286 and daybd.电表编号=0) or (daybd.终端编号=287 and daybd.电表编号=0) or (daybd.终端编号=294 and daybd.电表编号=0) or (daybd.终端编号=883 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=1) or (daybd.终端编号=212 and daybd.电表编号=2) or (daybd.终端编号=44 and daybd.电表编号=0) or (daybd.终端编号=47 and daybd.电表编号=0) or (daybd.终端编号=249 and daybd.电表编号=0) or (daybd.终端编号=10252 and daybd.电表编号=0) or (daybd.终端编号=10332 and daybd.电表编号=0) or (daybd.终端编号=10333 and daybd.电表编号=0) or (daybd.终端编号=11574 and daybd.电表编号=0) ) UNION ALL  Select dbo.FormatDateTime(daybd.数据时间,':','','') as 时间, daybd.* from cbdata.[dbo].[RealBD20121027] daybd where  ((数据日期=20121019 and 数据时间>=0 ) or (数据日期>20121019 and 数据日期<20121029 ) or (数据日期=20121029 and 数据时间<=1100 ))  and  ( (daybd.终端编号=108 and daybd.电表编号=0) or (daybd.终端编号=110 and daybd.电表编号=0) or (daybd.终端编号=111 and daybd.电表编号=0) or (daybd.终端编号=120 and daybd.电表编号=0) or (daybd.终端编号=140 and daybd.电表编号=0) or (daybd.终端编号=142 and daybd.电表编号=0) or (daybd.终端编号=143 and daybd.电表编号=0) or (daybd.终端编号=144 and daybd.电表编号=0) or (daybd.终端编号=145 and daybd.电表编号=0) or (daybd.终端编号=148 and daybd.电表编号=0) or (daybd.终端编号=153 and daybd.电表编号=0) or (daybd.终端编号=159 and daybd.电表编号=0) or (daybd.终端编号=166 and daybd.电表编号=0) or (daybd.终端编号=171 and daybd.电表编号=0) or (daybd.终端编号=176 and daybd.电表编号=0) or (daybd.终端编号=177 and daybd.电表编号=0) or (daybd.终端编号=178 and daybd.电表编号=0) or (daybd.终端编号=197 and daybd.电表编号=0) or (daybd.终端编号=200 and daybd.电表编号=0) or (daybd.终端编号=205 and daybd.电表编号=0) or (daybd.终端编号=210 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=0) or (daybd.终端编号=217 and daybd.电表编号=0) or (daybd.终端编号=218 and daybd.电表编号=0) or (daybd.终端编号=222 and daybd.电表编号=0) or (daybd.终端编号=238 and daybd.电表编号=0) or (daybd.终端编号=250 and daybd.电表编号=0) or (daybd.终端编号=255 and daybd.电表编号=0) or (daybd.终端编号=259 and daybd.电表编号=0) or (daybd.终端编号=279 and daybd.电表编号=0) or (daybd.终端编号=286 and daybd.电表编号=0) or (daybd.终端编号=287 and daybd.电表编号=0) or (daybd.终端编号=294 and daybd.电表编号=0) or (daybd.终端编号=883 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=1) or (daybd.终端编号=212 and daybd.电表编号=2) or (daybd.终端编号=44 and daybd.电表编号=0) or (daybd.终端编号=47 and daybd.电表编号=0) or (daybd.终端编号=249 and daybd.电表编号=0) or (daybd.终端编号=10252 and daybd.电表编号=0) or (daybd.终端编号=10332 and daybd.电表编号=0) or (daybd.终端编号=10333 and daybd.电表编号=0) or (daybd.终端编号=11574 and daybd.电表编号=0) ) UNION ALL  Select dbo.FormatDateTime(daybd.数据时间,':','','') as 时间, daybd.* from cbdata.[dbo].[RealBD20121028] daybd where  ((数据日期=20121019 and 数据时间>=0 ) or (数据日期>20121019 and 数据日期<20121029 ) or (数据日期=20121029 and 数据时间<=1100 ))  and  ( (daybd.终端编号=108 and daybd.电表编号=0) or (daybd.终端编号=110 and daybd.电表编号=0) or (daybd.终端编号=111 and daybd.电表编号=0) or (daybd.终端编号=120 and daybd.电表编号=0) or (daybd.终端编号=140 and daybd.电表编号=0) or (daybd.终端编号=142 and daybd.电表编号=0) or (daybd.终端编号=143 and daybd.电表编号=0) or (daybd.终端编号=144 and daybd.电表编号=0) or (daybd.终端编号=145 and daybd.电表编号=0) or (daybd.终端编号=148 and daybd.电表编号=0) or (daybd.终端编号=153 and daybd.电表编号=0) or (daybd.终端编号=159 and daybd.电表编号=0) or (daybd.终端编号=166 and daybd.电表编号=0) or (daybd.终端编号=171 and daybd.电表编号=0) or (daybd.终端编号=176 and daybd.电表编号=0) or (daybd.终端编号=177 and daybd.电表编号=0) or (daybd.终端编号=178 and daybd.电表编号=0) or (daybd.终端编号=197 and daybd.电表编号=0) or (daybd.终端编号=200 and daybd.电表编号=0) or (daybd.终端编号=205 and daybd.电表编号=0) or (daybd.终端编号=210 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=0) or (daybd.终端编号=217 and daybd.电表编号=0) or (daybd.终端编号=218 and daybd.电表编号=0) or (daybd.终端编号=222 and daybd.电表编号=0) or (daybd.终端编号=238 and daybd.电表编号=0) or (daybd.终端编号=250 and daybd.电表编号=0) or (daybd.终端编号=255 and daybd.电表编号=0) or (daybd.终端编号=259 and daybd.电表编号=0) or (daybd.终端编号=279 and daybd.电表编号=0) or (daybd.终端编号=286 and daybd.电表编号=0) or (daybd.终端编号=287 and daybd.电表编号=0) or (daybd.终端编号=294 and daybd.电表编号=0) or (daybd.终端编号=883 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=1) or (daybd.终端编号=212 and daybd.电表编号=2) or (daybd.终端编号=44 and daybd.电表编号=0) or (daybd.终端编号=47 and daybd.电表编号=0) or (daybd.终端编号=249 and daybd.电表编号=0) or (daybd.终端编号=10252 and daybd.电表编号=0) or (daybd.终端编号=10332 and daybd.电表编号=0) or (daybd.终端编号=10333 and daybd.电表编号=0) or (daybd.终端编号=11574 and daybd.电表编号=0) ) UNION ALL  Select dbo.FormatDateTime(daybd.数据时间,':','','') as 时间, daybd.* from cbdata.[dbo].[RealBD20121029] daybd where  ((数据日期=20121019 and 数据时间>=0 ) or (数据日期>20121019 and 数据日期<20121029 ) or (数据日期=20121029 and 数据时间<=1100 ))  and  ( (daybd.终端编号=108 and daybd.电表编号=0) or (daybd.终端编号=110 and daybd.电表编号=0) or (daybd.终端编号=111 and daybd.电表编号=0) or (daybd.终端编号=120 and daybd.电表编号=0) or (daybd.终端编号=140 and daybd.电表编号=0) or (daybd.终端编号=142 and daybd.电表编号=0) or (daybd.终端编号=143 and daybd.电表编号=0) or (daybd.终端编号=144 and daybd.电表编号=0) or (daybd.终端编号=145 and daybd.电表编号=0) or (daybd.终端编号=148 and daybd.电表编号=0) or (daybd.终端编号=153 and daybd.电表编号=0) or (daybd.终端编号=159 and daybd.电表编号=0) or (daybd.终端编号=166 and daybd.电表编号=0) or (daybd.终端编号=171 and daybd.电表编号=0) or (daybd.终端编号=176 and daybd.电表编号=0) or (daybd.终端编号=177 and daybd.电表编号=0) or (daybd.终端编号=178 and daybd.电表编号=0) or (daybd.终端编号=197 and daybd.电表编号=0) or (daybd.终端编号=200 and daybd.电表编号=0) or (daybd.终端编号=205 and daybd.电表编号=0) or (daybd.终端编号=210 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=0) or (daybd.终端编号=217 and daybd.电表编号=0) or (daybd.终端编号=218 and daybd.电表编号=0) or (daybd.终端编号=222 and daybd.电表编号=0) or (daybd.终端编号=238 and daybd.电表编号=0) or (daybd.终端编号=250 and daybd.电表编号=0) or (daybd.终端编号=255 and daybd.电表编号=0) or (daybd.终端编号=259 and daybd.电表编号=0) or (daybd.终端编号=279 and daybd.电表编号=0) or (daybd.终端编号=286 and daybd.电表编号=0) or (daybd.终端编号=287 and daybd.电表编号=0) or (daybd.终端编号=294 and daybd.电表编号=0) or (daybd.终端编号=883 and daybd.电表编号=0) or (daybd.终端编号=212 and daybd.电表编号=1) or (daybd.终端编号=212 and daybd.电表编号=2) or (daybd.终端编号=44 and daybd.电表编号=0) or (daybd.终端编号=47 and daybd.电表编号=0) or (daybd.终端编号=249 and daybd.电表编号=0) or (daybd.终端编号=10252 and daybd.电表编号=0) or (daybd.终端编号=10332 and daybd.电表编号=0) or (daybd.终端编号=10333 and daybd.电表编号=0) or (daybd.终端编号=11574 and daybd.电表编号=0) )) aa

 on dbcsb.编号=aa.电表编号 and dbcsb.终端编号=aa.终端编号   order by aa.终端编号,aa.电表编号,aa.数据日期,aa.数据时间
) cc

 --inner join @indextable t on cc.rownum2=t.nid
 where cc.rownum2  between 26 and 50  order by cc.终端编号,cc.电表编号,cc.数据日期,cc.数据时间
--drop table #temp2
set nocount off

--select * from [yhcbpara].[dbo].[YH电表参数表视图_无虚拟表]

 

--select * from [yhcbpara].[dbo].[YH电表参数表视图_无虚拟表]