Archives
The Select … for XML can be useful. Let say that you want to list out Job Order information, one job per line, and one of the field will be WC, and you want to show all WCs for the job, in the format like WC1, WC2, WC3, … Here is the select statement will […]
May 23rd, 2012 | Filed under Development, SQL