views:

39

answers:

0

I am new to Stored procedure in mysql

This is the procedure for returning difference of date excluding Weekends, but it returns error

#1312 - PROCEDURE blog1.DayCount can't return a result set in the given context

This is the procedure

DROP PROCEDURE IF EXISTS daycount; 
CREATE PROCEDURE DayCount( d1 DATE, d2 DATE ) 
SELECT dd.iDiff, dd.iDiff - dd.iWeekEndDays AS iWorkDays, dd.iWeekEndDays 
FROM ( 
  SELECT 
    dd.iDiff, 
    ((dd.iWeeks * 2) +  
    IF(dd.iSatDiff >= 0 AND dd.iSatDiff < dd.iDays, 1, 0) +  
    IF (dd.iSunDiff >= 0 AND dd.iSunDiff < dd.iDays, 1, 0)) AS iWeekEndDays 
  FROM ( 
    SELECT 
      dd.iDiff, 
      FLOOR(dd.iDiff / 7) AS iWeeks, 
      dd.iDiff % 7 iDays, 
      5 - dd.iStartDay AS iSatDiff, 
      6 - dd.iStartDay AS iSunDiff 
    FROM ( 
      SELECT 
        1 + DATEDIFF(d2, d1) AS iDiff, 
        WEEKDAY(d1) AS iStartDay 
      ) AS dd 
  ) AS dd 
) AS dd ; 


CALL DayCount( '2009-8-1','2009-9-15');