Comments by rajin kp (Top 57 by date)

my code is shown below.
declare @StartDate smalldatetime='2013-02-12 00:00:00';
declare @EndDate smalldatetime='2013-02-15 00:00:00';
declare @Notes nvarchar(500);
declare @AbsentReasonCode int;
--12 - 19 => 12 - 15,16 - 19
declare @_StartDateTable smalldatetime ;
declare @_EndDateTable smalldatetime ;
declare @_AbsentReasonCode int ;
declare @_update int=0;
declare CursorAttendance cursor for
select StartDate,EndDate,AbsentReasonCode from attendance
where StartDate<@EndDate and EndDate>@StartDate and StudentID=@StudentID
order by StartDate;
--case 1
open CursorAttendance;
FETCH NEXT
FROM CursorAttendance INTO @_StartDateTable , @_EndDateTable,@_AbsentReasonCode
WHILE @@FETCH_STATUS = 0
BEGIN
set @_update=0;
while dbo.GetDatePart(@_StartDateTable)<dbo.getdatepart(@_enddatetable)
begin
="" --print(cast(="" @_startdatetable="" as="" nvarchar(50))+','+cast(="" @enddate="" nvarchar(50)))
="" if="" dbo.getdatepart(@_startdatetable)="">=dbo.GetDatePart(@StartDate)
and dbo.GetDatePart(@_StartDateTable)<= dbo.GetDatePart(@EndDate)
begin
set @_update=1;

end
--else if dbo.GetDatePart(@_StartDateTable)<dbo.getdatepart(@startdate)
--="" and="" dbo.getdatepart(@_startdatetable)<="dbo.GetDatePart(@EndDate)
" begin
="" set="" @_update="2;
"
="" --end
="" ------------------------------------------
="" @_startdatetable="@_StartDateTable+1;
" ------------------------------------------="" if="" dbo.getdatepart(@_startdatetable)="">dbo.GetDatePart(@EndDate)
begin
print('****--------splited date for student 42457,AttendanceID=100 -----*****');
set @_update=0;
print (cast( @StartDate as nvarchar(50))+','+cast(@EndDate as nvarchar(50)));
print (cast( @_StartDateTable as nvarchar(50))+','+cast(@_EndDateTable as nvarchar(50)));
print('****--------------*****');
--print(@_StartDateTable)print(@_EndDateTable);
--insert into dbo.Attendance values( @StartDate,@EndDate);
--insert into dbo.Attendance values( @_StartDateTable,@_EndDateTable,@_AbsentReasonCode);
--delete from Attendance where AttendanceID=@AttendanceID;
--
end
else if @_update=2
begin
print('****------@_update=2-------*****');
end

end
-------------------------------------------


FETCH NEXT
FROM CursorAttendance INTO @_StartDateTable , @_EndDateTable,@_AbsentReasonCode END
CLOSE CursorAttendance
DEALLOCATE CursorAttendance
-------------------------------------------------------

consider that my table contain Schoolid and classid and yearid,table contain stunt leave details from different year id .I want to datediff based on yearid,studentid.ie basic query "select sum(datediff(d,startdate,enddate)),yearid,studentid from table_name group by yearid,studentid". this is the first query i write.I want apply PIVOT on this query to make result in a single row : student,acyear,class,reason1,...