MS SQL Server New Users - view and data organizing help?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

view and data organizing help?

_adrian

2006-04-08, 1:25 pm

I have a View on SQL server retrieving a series of records to be put into a
webpage using ASP, and my recordset shows all of those records, but I need
help in organizing them. Say that the recordset when returned shows the
following:

Tbl1Col1 - Tbl2Col1
-----------------------
Cold - Blue
Cold - Green
Cold - Brown
Hot - Yellow
Hot - Orange
Hot - Red

.... so from table one, I'm retrieving Cold, and Hot.. from table 2 (where
records match appropriately), I'm retrieving all of the color names. I need
to either handle the recordset, or write the ASP to display this way:

Tbl1Col1
---------
Tbl2Col1 (repeating)

So the example will display this way:

Cold
-----
Blue
Green
Brown

Hot
-----
Yellow
Orange
Red

....help?

Sponsored Links