Need one resultset from different sql quries in the stored procedure

See more:

C#

ASP.NET

SQL

SQL-Server

, +

Hi i am making a stored procedure with multiple select statements when i execute them than different resultset are maken for each select statement all i need is to get one resultset from all select statements of sql quries in the stored procedure......HERE is the SP code..
MS SQL Syntax (Toggle Plain Text)

SET NOCOUNT ON;
 
      SELECT COUNT(*) AS totalEmployees FROM dbo.Add_Employees
 
	  SELECT DISTINCT dbo.Add_Employees.gender, COUNT(Add_Employees.employee_uniqueId) AS AccGender
	  FROM dbo.Add_Employees
	  GROUP BY(Add_Employees.gender)
 
	  SELECT DISTINCT dbo.Add_Employees.department, COUNT(Add_Employees.employee_uniqueId) AS Accdepartment
	  FROM dbo.Add_Employees
	  GROUP BY(Add_Employees.department)
 
 
	  SELECT DISTINCT dbo.Add_Employees.designation, COUNT(Add_Employees.employee_uniqueId) AS Accdesignation
	  FROM dbo.Add_Employees
	  GROUP BY(Add_Employees.designation)
 
	  SELECT DISTINCT dbo.Add_Employees.grade, COUNT(Add_Employees.employee_uniqueId) AS AccGrade
	  FROM dbo.Add_Employees
	  GROUP BY(Add_Employees.grade)
 
	  SELECT DISTINCT dbo.Add_Employees.country, COUNT(Add_Employees.employee_uniqueId) AS AccCountry
	  FROM dbo.Add_Employees
	  GROUP BY(Add_Employees.country)
 
	  SELECT DISTINCT dbo.Add_Employees.city, COUNT(Add_Employees.employee_uniqueId) AS AccCity
	  FROM dbo.Add_Employees
	  GROUP BY(Add_Employees.city)
 
 
END