I have a query that out puts all the data I want, unfortunately I don't like the way its displayed and I'd like to combine data from multiple results into a single result. Problem is I have no idea how to do it... Let me try and explain....
SELECT S_Name, S_Address1, S_Postcode, B_StartDate, B_EndDate, DATEPART(Week, B_StartDate) AS WeekNum, DATEDIFF(Day, B_StartDate, B_EndDate) +1 As NoOfDays, DATENAME(dw, B_StartDate) As DayWeek, B_StartTime, B_EndTime, DATEDIFF(Hour, B_StartTime, B_EndTime) As NoOfHours, T_Name, S_Email, S_FaxNo FROM Bookings INNER JOIN Employees ON T_TID=B_TID INNER JOIN Clients ON S_SID=B_SID WHERE B_TimeSheetCreated = 0 ORDER BY S_Name, B_StartDate
Output with some example data:
What I would like to try and achieve is something like this :
Hope you understand what I mean.... any idea if its possible...?
Edit: looks like he formatting has all been messed up, I've uploaded images instead.......