Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
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
|Insert statement is inserting duplicate records||15||51|
|SSIS how to COMPARE a data column from different servers?||6||77|
|display data in text field from data base for updating||6||26|
|How to place a condition in a filter criteria in t-sql?||12||31|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
15 Experts available now in Live!