SQL Server 列存存储过程：获取活动列表并处理时间范围

use [websitedb]
go
/****** object:  storedprocedure [dbo].[up_get_activity_list]    script date: 06/23/2011 14:05:57 ******/
set ansi_nulls on
go
set quoted_identifier on
go
-- =============================================
-- author: <migangpeng>
-- create date: <2011-06-16 13:30>
-- description: <description,,>
-- =============================================
alter procedure [dbo].[up_get_activity_list]
-- add the parameters for the stored procedure here
    @v_smembertype nvarchar(20) ,
    @v_dstart datetime ,
    @v_dend datetime
as 
    begin
--a. set nocount on added to prevent extra result sets from

        declare @v_sdynamic nvarchar(2048) ,                 --动态sql
            @v_stime varchar(10) ,  --日期
            @v_sactivity varchar(10) ,  --活动
            @v_sqeruysql nvarchar(4000) ,  --获取活动数
            @v_sinsertsql nvarchar(4000) ,  --record记录集插入字符集
            @v_supdatesql nvarchar(4000) ,  --条件更新记录集
            @v_sexecutesql nvarchar(4000) ,  --求值字符集
            @v_screatesql nvarchar(4000) ,  --临时表创建字符集
            @v_stempsql nvarchar(4000) ,  --临时桥接字符集

            @v_cvalue int ,  --运算值变量
            @v_ccardout int ,  --升级值变量
            @v_cdatetotal int ,  --单日期参与人数
            @v_ccount int  --计数值变量
        --detetime recod delimit
        declare cur_date_cursor cursor
        for
            select distinct
                    convert(nvarchar(10), d.createtime, 101) as 'date'
            from    dbo.reglist d
            where   d.memberlevel like @v_smembertype
                    and d.createtime between @v_dstart and @v_dend
            order by convert(nvarchar(10), d.createtime, 101) asc

        --activity recod delimit
        declare cur_activity_cursor cursor global
        for
            select distinct
                    e.activitycode 'activity'
            from    dbo.reglist e
            where   len(e.activitycode) <= 7
                    and e.memberlevel like @v_smembertype
                    and convert(varchar(10), e.createtime, 101) between convert(varchar(10), @v_dstart, 101)
                                                              and
                                                              convert(varchar(10), @v_dend, 101)
            order by e.activitycode asc
           
--b. interfering with select statements.
        set nocount on ;
        set @v_screatesql = n'create table ##tmp201106('