geoffsweb
asked on
How to get db results to be column headings?
I currently have a SQL statement that gives me the corrert results, but I need the results to be formatted in a different way. For example, I grab 5 records from my database. Within those results, I have 5 dates, all being Friday dates. Instead of having 5 records, I need it to be 1 record and those 5 dates need to be column headings with other fields in the result set being under them. Here is my current Stored Procedure that works, it just gives me a record for every date, instead of making those dates column headings. Hopefully this makes a little bit of sense and somebody can push me in the right direction. Thanks in advance.
CREATE PROCEDURE dbo.ManPower_GetProjectDat aByProject ID
(
@ProjectID int = NULL
)
AS
SELECT Manpower_Employees.FirstNa me + ' ' + Manpower_Employees.LastNam e AS EmployeeName,
Manpower_Employees.Employe eNumber,
Manpower_Departments.Depar tmentName,
Manpower_ProjectDateHours. Hours,
Manpower_Fridays.Fridays
FROM Manpower_Fridays
RIGHT OUTER JOIN Manpower_ProjectDateHours ON Manpower_Fridays.Fridays_I D = Manpower_ProjectDateHours. DateID
LEFT OUTER JOIN Manpower_Projects ON Manpower_ProjectDateHours. ProjectID = Manpower_Projects.Projects _ID
LEFT OUTER JOIN Manpower_Departments
RIGHT OUTER JOIN Manpower_Employees ON Manpower_Departments.Depar tments_ID = Manpower_Employees.Departm entID ON
Manpower_ProjectDateHours. EmployeeID = Manpower_Employees.Employe es_ID
WHERE Manpower_Projects.Projects _ID = @ProjectID
RETURN
GO
CREATE PROCEDURE dbo.ManPower_GetProjectDat
(
@ProjectID int = NULL
)
AS
SELECT Manpower_Employees.FirstNa
Manpower_Employees.Employe
Manpower_Departments.Depar
Manpower_ProjectDateHours.
Manpower_Fridays.Fridays
FROM Manpower_Fridays
RIGHT OUTER JOIN Manpower_ProjectDateHours ON Manpower_Fridays.Fridays_I
LEFT OUTER JOIN Manpower_Projects ON Manpower_ProjectDateHours.
LEFT OUTER JOIN Manpower_Departments
RIGHT OUTER JOIN Manpower_Employees ON Manpower_Departments.Depar
Manpower_ProjectDateHours.
WHERE Manpower_Projects.Projects
RETURN
GO
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.