title: Cursorfetch:The number of variables declared in the INTO list must match that of selected columns
body: <pre><code>declare @id int
  declare @empid int
  set @id = 0
  declare @schedindate datetime
  declare @ss nvarchar(100)
  declare @indice nvarchar(2)
  declare @FromDate datetime
  declare @ToDate datetime
  declare @TimeInR datetime
  declare @TimeOutR datetime
  set @FromDate = '2009-01-14'
  set @ToDate = '2010-01-30'
  
  Declare cc cursor for select distinct empid from ta_timecard where schedindate between @FromDate and @ToDate
  open cc
  fetch next from cc into @empid
  while (@@fetch_status = 0)
  begin
      set @id = @id + 1
      insert into ta_MonthlyAttendance (ID, EmpID) values (@id, @empid)
  
      declare cc2 cursor for select distinct schedindate, TimeInR, TimeOutR from ta_timecard where empid = @empid and schedindate between @FromDate and @ToDate
      open cc2
      fetch next from cc2 into @schedindate, @TimeInR
      while (@@fetch_status = 0)
      begin
  
          set @indice = cast(datediff(day, @fromdate, @schedindate) as nvarchar(4))
          set @TimeInR = (select TOP 1 ta_TimeCard.TimeInR from ta_TimeCard where (@schedindate between @FromDate and @ToDate) and EmpID=@empid)
          set @schedindate = (select TOP 1 ta_TimeCard.SchedInDate from ta_TimeCard where (@schedindate between @FromDate and @ToDate) and empid=@empid)
          set @ss = 'update ta_MonthlyAttendance set NOD ' + @indice  + ' = + dbo.ta_dayofweek('+ char(39) + convert(nvarchar(50), @schedindate, 102) + char(39) +' ) , TimeInR ' + @indice + ' =  + @TimeInR + where empid = ' + cast(@empid as nvarchar(20))
          execute sp_executesql @ss
          fetch next from cc2 into @schedindate, @TimeInR
  end
  close cc2
  deallocate cc2
  fetch next from cc into @empid
  end
  close cc
  Deallocate cc
  </code></pre>
  <p>this code gives error in the line &quot;fetch next from cc2 into @schedindate, @TimeInR&quot;</p>
  <p>where's my fault? I can't find it..</p>