Dear All SQL Gurus,
I have most of what I need complete I just need a little help with some alignment of data.
My quesion is.
I have this query
SELECT CONVERT(date, ActualClocked.TimeClockedIn) AS DayClockedIn,ActualClocked.HoursWorked,ActualClocked.MinsWorked,'' as EnteredHours,'' As EnteredMinutes
SELECT CONVERT(date,TimeRecord.TSDate) AS DateIn,'','',SUM(TimeRecord.Hours),SUM(TimeRecord.Minutes)
GROUP BY TSDate
Which gives me this result
2015-05-18 15 25
2015-05-18 9 0 0 0
is it possible to get the 9 and the zero on the same row as 15 and 25. I am really stuck and would appreciate any help. Unfortunately I cannot upload an image of the results as I am new user. So I hope this makes sense.