USE [csoft] GO /****** Object: StoredProcedure [dbo].[Search] Script Date: 08/11/2010 22:22:10 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER Procedure [dbo].[Search] @prd varchar(2), @rep varchar(2), @yy varchar(4), @mm varchar(2), @sno_o varchar(4) output, @vtext_o VARCHAR(8000) output AS DECLARE @VTEXT VARCHAR(8000) DECLARE @SNO VARCHAR(4) Declare @SQL VarChar(8000) DECLARE @Q VARCHAR(2) declare @num varchar(10) DECLARE db_cursor CURSOR FOR SELECT sno, view_text FROM month_scripts2 where prd_code = @prd and rep_code = @rep set @num=0 SET @Q = '''' OPEN db_cursor FETCH NEXT FROM db_cursor INTO @SNO,@VTEXT WHILE @@FETCH_STATUS = 0 BEGIN -- set @num = @num + 1 SET @SQL = @VTEXT SET @SQL = REPLACE(@SQL,'''MM''',@Q+@MM+@Q) SET @SQL = REPLACE(@SQL,'''YYYY''',@Q+@YY+@Q) PRINT @sno + ' - ' + @SQL -- print -- Exec ( @SQL) -- if @num = 150 -- break FETCH NEXT FROM db_cursor INTO @SNO,@VTEXT,@sno_o,@vtext_o END CLOSE DB_CURSOR DEALLOCATE DB_CURSOR
FETCH NEXT FROM db_cursor INTO @SNO,@VTEXT,@sno_o,@vtext_o
FETCH NEXT FROM db_cursor INTO @SNO,@VTEXT
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)