WHILE(@Count <=12)
BEGIN
       set @calMonth = datepart(month, @calDate)
       set @calYear = datepart(year, @calDate)

       select @calMonth, @calYear
       Exec sp_CalendarProc @ai_Year = @CalYear, @ai_Month = @CalMonth
       Exec sp_CalendarProc @ai_Year = @CalYear, @ai_Month = @CalMonth

       SET @Count = @Count+1
       set @calDate = dateadd(month, 1, @calDate)
END       

quote:

---

Originally posted by agastyamahi

Hi, I have a query below

BEGIN

DECLARE @CalDate datetime
SET @CalDate = (select (DateAdd(mm, 1, Max (Cast((Cast(CalYear AS CHAR(4)) + '/' + Cast(CalMonth AS CHAR(2)) + '/' + '01') AS DATETIME))))
FROM CalRecord WHERE CalType = 'F' And CalStatus = 1)


declare @CalMonth int
set @CalMonth = datepart(mm, @CalDate)

DECLARE @CalYear int
SET @CalYear = datepart(yyyy,@CalDate)

DECLARE @count INT
SET @count = 1

WHILE(@Count <=12)
BEGIN

Exec sp_CalendarProc @ai_Year = @CalYear, @ai_Month = @CalMonth
Exec sp_CalendarProc @ai_Year = @CalYear, @ai_Month = @CalMonth
set @CalMonth = @CalMonth + 1

SET @Count = @Count+1

IF (@Count > 12)
BEGIN
@CalMonth = 1
@CalYear = @CalYear + 1
END

END
END

My CalRecord table has the Year and Month column, with data for 2013(Month 1 to 12) and 2014(Month 1 to 12)in it.

My @CalDate returns 2013-06-01, now I need to run stored proc with year = 2013 and month = 6. After this, in the similar way I want my month to be incremented(and year to be incremented after 2013/12), so I added the set @CalMonth = @CalMonth + 1 statement, but I am running into issues since I am getting data for month 13,14,15....but I should not. I need the stored proc to run only from 2013-06 to 2014-05.

Could you please correct the query I have

Thanks

---

quote:

---

Originally posted by agastyamahi

Thank you very much that worked.

I need a suggestion, I am starting my career in SQL, I am unable to code based on the requirement sometimes. Could you please let me know how I can improve my coding skills

---