Editing xml is fast and simple using DocHub. Skip installing software to your PC and make alterations with our drag and drop document editor in just a few fast steps. DocHub is more than just a PDF editor. Users praise it for its convenience and robust features that you can use on desktop and mobile devices. You can annotate documents, generate fillable forms, use eSignatures, and deliver documents for completion to other people. All of this, combined with a competitive price, makes DocHub the ideal option to omit stuff in xml files effortlessly.
Make your next tasks even easier by converting your documents into reusable web templates. Don't worry about the safety of your information, as we securely store them in the DocHub cloud.
hi welcome to this sql tutorial video and today weamp;#39;re going to look at for xml and weamp;#39;re going to use for xml to create a comma separated list um as a result as an output so on screen here iamp;#39;ve got two selects that look at two different tables within the adventure works database and what i want is as an example um here is a list of the departments for uh this particular company and here is a list of the people who work for the company are their national insurance numbers and what i want is a query that will return me all of the departments and the national insurance numbers of the people who work in those departments so i can write this select here that shows me the departments and those national insurance of the people who work in those departments but actually what i want to see is a single line for department document control and then in the next column a single line of commerce separated national insurance numbers okay so letamp;#39;s look at how we can do