Have you ever struggled with editing your Xml document while on the go? Well, DocHub has a great solution for that! Access this online editor from any internet-connected device. It enables users to Set clause in Xml files quickly and anytime needed.
DocHub will surprise you with what it offers. It has powerful capabilities to make whatever changes you want to your forms. And its interface is so easy-to-use that the entire process from beginning to end will take you only a few clicks.
When you complete adjusting and sharing, you can save your updated Xml file on your device or to the cloud as it is or with an Audit Trail that contains all adjustments applied. Also, you can save your paperwork in its initial version or transform it into a multi-use template - complete any document management task from anywhere with DocHub. Subscribe today!
hi welcome to this sql tutorial video and today were going to look at for xml and were going to use for xml to create a comma separated list um as a result as an output so on screen here ive 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 lets look at how we can do that ill start a new query um f