declare @intCount int;
declare @ShowPosition varchar(50);
declare @DocSort varchar(10);
declare @MemberType varchar(10);
declare @ReCommendType varchar(10);
declare @RecomendBy varchar(10);
declare @RecomendNum varchar(10);
declare @ShowTimes varchar(10);
select @intCount=COUNT(ShowPosition) from [dbo].[tbTemp]
if @intCount>0
begin
declare Type_Cursor CURSOR FOR select
[ShowPosition]
,[DocSort]
,[MemberType]
,[ReCommendType]
,[RecomendBy]
,[RecomendNum]
,[ShowTimes] FROM [dbo].[tbTemp] where DATEDIFF(day,getdate(),RunDateTime)<=0
open Type_Cursor
fetch next from Type_Cursor into
@ShowPosition
,@DocSort
,@MemberType
,@ReCommendType
,@RecomendBy
,@RecomendNum
,@ShowTimes
while(@@fetch_status=0)
begin
print @ShowPosition --循环打印出ShowPosition的值
--处理各种复杂情况开始
--处理各种复杂情况结束
fetch next from Type_Cursor into
@ShowPosition
,@DocSort
,@MemberType
,@ReCommendType
,@RecomendBy
,@RecomendNum
,@ShowTimes
end
CLOSE Type_Cursor
DEALLOCATE Type_Cursor
end
declare @ShowPosition varchar(50);
declare @DocSort varchar(10);
declare @MemberType varchar(10);
declare @ReCommendType varchar(10);
declare @RecomendBy varchar(10);
declare @RecomendNum varchar(10);
declare @ShowTimes varchar(10);
select @intCount=COUNT(ShowPosition) from [dbo].[tbTemp]
if @intCount>0
begin
declare Type_Cursor CURSOR FOR select
[ShowPosition]
,[DocSort]
,[MemberType]
,[ReCommendType]
,[RecomendBy]
,[RecomendNum]
,[ShowTimes] FROM [dbo].[tbTemp] where DATEDIFF(day,getdate(),RunDateTime)<=0
open Type_Cursor
fetch next from Type_Cursor into
@ShowPosition
,@DocSort
,@MemberType
,@ReCommendType
,@RecomendBy
,@RecomendNum
,@ShowTimes
while(@@fetch_status=0)
begin
print @ShowPosition --循环打印出ShowPosition的值
--处理各种复杂情况开始
--处理各种复杂情况结束
fetch next from Type_Cursor into
@ShowPosition
,@DocSort
,@MemberType
,@ReCommendType
,@RecomendBy
,@RecomendNum
,@ShowTimes
end
CLOSE Type_Cursor
DEALLOCATE Type_Cursor
end