Stored Procedure Woes:

Does anyone have a quick sec to run down this and break it down for me what it is doing?


I have some clue, but not the whole picture.... I commented where I have the most trouble.





CREATE PROCEDURE dbo.GetReviewerApptsInRange


(


@sUserID char(50),


@start as datetime,


@end as datetime


)


AS


SET NOCOUNT ON;


Select a.ApptKey,


' ' as TempApptKey,


isnull(a.Addrkey,0) Addrkey, '' not sure what this does


a.StartTime,


isnull(a.EndTime,a.starttime) as EndTime, '' not sure what this does


isnull(a.Subject,'') as Subject, '' not sure what this does


isnull(a.Notes,'') as [Description], '' not sure what this does


a.StudyType,


isnull(a.ScheduleSource,'original') schedulesource, '' not sure what this does


isnull(a.reviewerid,'') reviewer,


a.ChangeID,


isnull(a.Location,'') Location


-- a.ChangeDate,


-- (select count(cs.medrecactkey) '' not sure what this does


-- from OdisChartScheduleStatus cs


-- join OdisAppointments oa


-- on cs.apptkey = oa.apptkey


-- where cs.apptkey = a.apptkey) as chartcount--placeholder for assignments





FROM OdisAppointments a


WHERE a.reviewerid = @sUserID


and a.starttime >= @start


and a.endtime <= @end





order by a.apptkey





GO








'' Much thanks, Mike