Put six individual SQL queries into one to product a table

adznon used Ask the Experts™

Please can you help to put together the following six SQL queries into one table
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
/* Gives Auditor Names and Auditor FPP Scheduled and Completed */
SELECT [Auditor_Allocated_2017] AS [Auditor],count(DISTINCT [Store_Number]) as [FPP_Scheduled],count(DISTINCT [Retail_Outlet_Number]) As [FPP_Completed] FROM [dbo].[UK_Store_Details] GROUP BY [Auditor_Allocated_2017] ORDER BY Auditor ASC

Open in new window

try something like that. the above combines 3 first queries into one

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial