SELECT a.SchedDate, DATEDIFF(minute, a.SchedEndDateTime, b.SchedStartDateTime) AS AvailTime FROM dbo.Schedules AS a INNER JOIN dbo.Schedules AS b ON a.SchedID = b.SchedID WHERE (a.SchedDate = CONVERT(DATETIME, '2010-09-11 00:00:00', 102))
|Can someone plz fix this..getting an error||3||18|
|SSRS Dynamic Column Names - Last 8 Weeks||3||13|
|MSDN Licensing query||5||0|
|Create formula that divides total amount by 30 or 31 depending on what month of the year it is looking at||5||0|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
23 Experts available now in Live!