Monday, 9 September 2013

want to edit Sqlserver query

want to edit Sqlserver query

My query ------------
SELECT dbo.tbScheduleDetail.CareProfessionalIDF,
dbo.tbScheduleDetail.CareProviderIDF,
dbo.tbScheduleTimeSlot.ScheeduleWeekDays,
dbo.tbScheduleTimeSlot.ScheduleTimeSlotIDP,
dbo.tbScheduleTimeSlot.ScheduleStartTime,
dbo.tbScheduleTimeSlot.ScheduleEndTime,
dbo.tbCareProvider.CareProviderName,
dbo.tbCitizen.FirstName + ' ' + dbo.tbCitizen.MiddleName
+ ' ' + dbo.tbCitizen.FamilyName AS
CareProfessionalName,
dbo.tbScheduleDetail.ScheduleFor,
dbo.tbScheduleDetail.ScheduleStartDate,
dbo.tbScheduleDetail.ScheduleEndDate,
dbo.tbScheduleTimeSlot.SplitIntervalStart,
dbo.tbScheduleTimeSlot.SplitIntervalEnd,
dbo.tbScheduleTimeSlot.SlotInterval,
dbo.tbScheduleDetail.IsActive,
dbo.tbScheduleTimeSlot.IsSplitSchedule
FROM dbo.tbScheduleTimeSlot INNER JOIN
dbo.tbScheduleDetail ON
dbo.tbScheduleTimeSlot.ScheduleDetailIDF =
dbo.tbScheduleDetail.ScheduleDetailIDP INNER JOIN
dbo.tbCareProvider ON
dbo.tbScheduleDetail.CareProviderIDF =
dbo.tbCareProvider.CareProviderIDP INNER JOIN
dbo.tbCareProfessional ON
dbo.tbScheduleDetail.CareProfessionalIDF =
dbo.tbCareProfessional.CareProfessionalIDP INNER JOIN
dbo.tbCitizen ON dbo.tbCareProfessional.CitizenIDF =
dbo.tbCitizen.CitizenIDP
WHERE (dbo.tbScheduleTimeSlot.IsActive = 1) and CareProviderIDF=4
I want to edit this query with group by
dbo.tbScheduleDetail.CareProfessionalIDF.
Quick edit for formatting

No comments:

Post a Comment