Thanks, Jose. This looks like what I want to do. Is it available within a BAQ?
Joe
On Mon, Mar 7, 2016 at 7:44 PM, Jose Gomez jose@... [vantage] <vantage@yahoogroups.com> wrote:
Â<div> <p>You can use the stuff/xl functions <span></span>to accomplish this</p><div><br></div><div><br><a rel="nofollow" target="_blank" href="https://www.mssqltips.com/sqlservertip/2914/rolling-up-multiple-rows-into-a-single-row-and-column-for-sql-server-data/">https://www.mssqltips.com/sqlservertip/2914/rolling-up-multiple-rows-into-a-single-row-and-column-for-sql-server-data/</a><span class="ygrps-yiv-1268518795"><br>On Monday, March 7, 2016, <a rel="nofollow" target="_blank" href="mailto:jdtrent@...">jdtrent@...</a> [vantage] <<a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>> wrote:<br><blockquote class="ygrps-yiv-1268518795gmail_quote" style="border-left:1px #ccc solid;">Â<div> <p></p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">For a search routine I'd like to get a list of part numbers for a quote/order/invoice I've generated from a configurator and stuffed into a UD table.</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">If I join the UD table it will generate a large numer of rows. Is there a way to run a subquery I can run that will return a field with the list of part numbers on one row?</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">Thanks,</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">Joe</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">--</p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">Joe D. Trent</p><p><span></span></p><p style="margin-top:12px;margin-bottom:12px;outline:0px;font-family:Arial, Verdana, geneva, sans-serif;vertical-align:baseline;color:rgb(51,51,51);">Bigham Ag Equipment</p><p><span><br></span></p><p></p> </div> <div style="color:#fff;min-height:0;"></div>
--
</div>
<div style="color:#fff;min-height:0;"></div>
