A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.
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.
ALTER PROCEDURE [dbo].[spResumeXMLGeneration] @username varchar(50), @profile varchar(50) AS Declare @xml nvarchar(max) Declare @filepath nvarchar(max) Set @filepath = 'C:\"' + @username + '".xml' Set @xml = ( Select employee.ProjectName, employee.Employeeno, employee.EmployeeName, employee.Work_Summary, employee.Accreditation_Affliation, employee.PE_Certification, employee.LEED_Certification, employee.CPD_Certification, employee.RoleonProject, --subquery for Projects (SELECT ProjectName, Location FROM Profiles_Employee_Projects_XML as project WHERE Username = employee.Username and Profile = employee.Profile and EmployeeID = employee.EmployeeID and project.IncludeonResume = 1 order by project.Sort_Order FOR XML PATH ('Projects'),TYPE -- Column is typed so it nests as XML, not text. ) , --subquery for Education (SELECT School_Facility, Degree_Completed, Completion_Year FROM Profiles_Employee_Education as education WHERE Username = employee.Username and Profile = employee.Profile and EmployeeID = employee.EmployeeID order by education.Completion_Year FOR XML PATH ('Education'),TYPE -- Column is typed so it nests as XML, not text. ) , --subquery for Education (SELECT ReferenceTitle, ReferenceName, ReferenceCompany, ReferenceEmail, ReferencePhone FROM Profiles_Employee_References as reference WHERE Username = employee.Username and Profile = employee.Profile and EmployeeID = employee.EmployeeID FOR XML PATH ('References'),TYPE -- Column is typed so it nests as XML, not text. ) from Profiles_Employee_Info as employee where Username = @username and Profile = @profile FOR XML PATH('Employee'),Elements, Root('Resumes') -- The element name for each row. ) exec dbo.writetofile @xml, @filepath
|Not selecting duplicate data||6||59|
|SQL Query Syntax: Why is the CTE Pulling in More Data Than Asked For?||5||69|
|Bubble user-defined Sql RAISERROR(...) to c# exception||14||189|
|get most recent and second most recent date in SQL Server||24||97|