Here is a query attached in code snippet, output for the query is now like this
but I want the output to be as
1/21/2008 3cpu,2 laptop,1 computer
for that particular date all the products sold are in just one line,instead of displaying separately....
I need to attach this 2 columns Date,Products lo a grid using .NET .
I appreciate if any one can give me some work around for this.
SELECT Convert(Varchar(15),a.DateStarted, 101) DateStarted,b.product
FROM Orders a
INNER JOIN OrdersUserIDs b ON a.OrderID = b.OrderID
WHERE StoreID= 'system'
order by a.DateStarted