Jody

           

          一個簡單的存儲過程!

          create procedure wap_data_content_zf as
          declare @data_0 varchar(100)
          declare @date_1 varchar(100)
          declare @date_2 varchar(100)
          declare @yvisit integer
          declare @yadd integer
          declare @mvisit integer
          declare @madd integer


          set @data_0=convert(char(8),getdate(),112)
          set @data_1=convert(char(8),dateadd(day,-1,getdate()),112)
          set @date_2=left(convert(char(30),dateadd(day,-1,getdate()),121),10)

          print @temp_0
          print @temp_1
          print @temp_2

          select @yvisit=count(distinct(mid)) from dbo.wap_log_access_2006_6 where uri='/wap/pd/yysl_yk/index.jsp'
          and mid != ''
          and create_time >= '2006-06-06 00:00:00'
          and create_time <= '2006-06-06 23:59:59'

          select @mvisit=count(distinct(mid)) from dbo.wap_log_access_2006_6 where uri='/wap/pd/mlmhc_yk/index.jsp'
          and mid != ''
          and create_time >= '2006-06-06 00:00:00'
          and create_time <= '2006-06-06 23:59:59'

          select @yadd=count(distinct(mid)) from dbo.wap_log_fee_2006_6 as a
          where a.uri='/wap/pd/yysl_yk/get.jsp'
          and a.mid != ''
          and a.portal_id=0
          and a.create_time >= '2006-06-06 00:00:00'
          and a.create_time <= '2006-06-06 23:59:59'
          and exists(select * from dbo.wapuser as b where a.mid = b.mid and b.serviceid='30050631'
          and b.firsttime >= '2006-06-06 00:00:00'
          and b.firsttime <= '2006-06-06 23:59:59')

          select @madd=count(distinct(mid)) from dbo.wap_log_fee_2006_6 as a
          where a.uri='/wap/pd/mlmhc_yk/get.jsp'
          and a.mid != ''
          and a.portal_id=0
          and a.create_time >= '2006-06-06 00:00:00'
          and a.create_time <= '2006-06-06 23:59:59'
          and exists(select * from dbo.wapuser as b where a.mid = b.mid and b.serviceid='02011095'
          and b.firsttime >= '2006-06-06 00:00:00'
          and b.firsttime <= '2006-06-06 23:59:59')

          insert into wap_data_content_zf wap(date,mvisit,madd,yvisit,yadd)
          ?????? values(@temp_2,@mvisit,@madd,@yvisit,@yadd)

          posted on 2006-06-26 14:23 zhaofei1394 閱讀(282) 評論(0)  編輯  收藏 所屬分類: SQL Server

          導航

          統計

          常用鏈接

          留言簿(1)

          隨筆分類

          隨筆檔案

          文章分類

          文章檔案

          友情鏈接

          搜索

          最新評論

          閱讀排行榜

          評論排行榜

          主站蜘蛛池模板: 嘉义市| 望都县| 凤庆县| 武鸣县| 大荔县| 怀化市| 赞皇县| 申扎县| 黑龙江省| 梁河县| 汾阳市| 兴化市| 汉阴县| 涿州市| 长春市| 浮山县| 天津市| 台南县| 安国市| 北宁市| 教育| 措美县| 大荔县| 平南县| 定南县| 山西省| 万山特区| 化州市| 大庆市| 九龙城区| 玛曲县| 青川县| 九台市| 叙永县| 寿阳县| 商河县| 马尔康县| 龙胜| 涿州市| 平原县| 陕西省|