show records horizontally

[jlizardo]

:confused:I have this info Desc1................Desc2 -------------......---------- BudgetControl......RamonDilan DirectorContr......JoseAleman I wanna to show Desc1................Desc2.............Desc1.............Desc2 -------------......----------......-------------...--------- BudgetControl......RamonDilan......DirectorContr...JoseAleman Please help me on that.. Thanks johnny

[Elina Blank]

Try something like this: < Desc1
Sincerely, Elina Life is great!!! Enjoy every moment of it! :-O

[jlizardo]

Hi Thanks for your response. But I using SQL Statements. I'm using SQL 2000 server in Query Analyser. Do you have any idea?. Johnny

[Ennis Ray Lynch Jr]

There are two options, using T-SQL to dynamically generate the query or use a join and eliminate null records. If the join will work it is the best option as it is fast. The T-SQL option is usually ugly.

---

On two occasions I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question. - Charles Babbage