With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
select EmployeeName,total1, total2 from (SELECT LastName + ', ' + FirstName as EmployeeName , COUNT(Employee.EmployeeId) as total1, 0 as total2 From (blah blah) Group by Employee.EmployeeId, UserProfile.LastName, UserProfile.Firstname UNION ALL SELECT LastName + ', ' + FirstName as EmployeeName, 0 as total1, COUNT(Employee.EmployeeId) as total2 from (blah blah) Group by Employee.EmployeeId, UserProfile.LastName, UserProfile.Firstname ) as table1 order by employeename
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|This differential backup cannot be restored because the database has not been restored to the correct earlier state.||2||41|
|T-SQL: problem comparing datetime||4||76|
|What is needed to become a DBA?||7||50|
|when sa SQL Login becomes locked||6||32|
Join the community of 500,000 technology professionals and ask your questions.