title: Is there a way to group multiple line items from a result in SQL Server 2005 into a single line item?
body: <p>I'm using SQL Server 2005. I have a series of product and pricing tables from which I draw a view that provides several line items for each product, depending on whether the item's markup is set at item level, category level, or department level. So an example of the output for a single item would be:</p>
  
  <p><img src="https://i.stack.imgur.com/58FLx.jpg" alt="Output for an example item of ID 2739"></p>
  
  <p>What I'd like some help with - if it's at all possible - is grouping the output or performing some additional query on it so that the three line items in my result are combined into a single line item, with all the possible markup levels on one line. I've been unable to think of a way to do this without requiring additional expensive server-side processing to create a temp table and apply some logic to it to combine the 3 lines into 1. The real issue is time, since iterating through a product database of over 30000 items and performing per-line steps on the whole thing strikes me as an extremely cumbersome way to do this.</p>
  
  <p>If anyone might be able to help me out on this, I'd really appreciate it.</p>