Resole this Issue Please-- Cursorfetch: The number of variables declared in the INTO list must match that of selected columns.

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