One of the helpful features of Team Foundation Server (TFS) is the ability to associate work items with the code that was changed or created for them during the check in process.  In the event that you forget to make this association during code check in, TFS allows you to link a code changeset to a work item after the fact.

After opening the work item you want to associate with a changeset, select the Links tab and click on the Add button.

Changeset is one of the options you can select in the Link type drop down box.

After you select Changeset, click on the Browse button to the right of Changeset text box inside Link details.  

TFS gives you a few different ways to locate the changeset you want to associate with a work item, including a specific file contained within the changeset, the user who checked the code in, the changeset number, and a date/time range.  

After you click Find, TFS presents you with a list of changesets meeting your criteria.  If you would like to review the files in a changeset before clicking OK, there is a Details button at the bottom left of the dialog box that will retrieve a list of the files in the changeset.

When you find yourself in a situation where you would like to concatenate the data items for a data object into one line, where the object can be related to many data items that are stored in a separate table, here is a quick way to accomplish that in SQL without expressly using a loop:

• Lines 2-3: declare and initialize variable that will be used to hold the concatenated string
• Line 5: select variable to equal itself plus the string you are interested in and a delimiter such as a comma, if desired
• Lines 6-9: the query that returns the data items for the object you are interested in
• Line 11: trim off the excess delimiter from the concatenated string

The resulting concatenated string:

An example application is to place this type of concatenation in a function where you can submit the ID for the object you are concatenating data items for to the function, and have it return the concatenated string.