• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 38
  • Last Modified:

Put six individual SQL queries into one to product a table


Please can you help to put together the following six SQL queries into one table
1 Solution
/* 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now