Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.
SELECT HT.[YR], A.[Specialty], A.[Lead ID], A.[Client State] AS ClientState, HT.[HRS] FROM [dbo].[Assignment] A INNER JOIN ( SELECT [Assignment Number], SUM(ISNULL(H.[Hours],0) + ISNULL(H.[On Call Hours],0)) HRS, YEAR(H.[Week Ending Date]) AS [YR] FROM [dbo].[HoursTracking] H GROUP BY [Assignment Number] ,YEAR(H.[Week Ending Date]) ) HT ON A.[Assignment Number] = HT.[Assignment Number] WHERE HT.HRS > 0 AND A.[Lead ID] IS NOT NULL ORDER BY A.[Client State],A.[Specialty], HT.[YR] DESC
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.