Nice. Now how about if I have two columns

InvoiceNumber, BillName, BillDate

1, Amit , 1/1/1900

2,Amit, 1/2/1901

and looking for output as

1 2

Amit Amit

1/1/1900 1/2/1901

Also, is there a way to get all invoices without using dynamic query?