I have a page listing all the addresses for a customer and I want 2
addresses per row. Each address is in a template column so I can add
special formatting and buttons. My problem is that each address is a row of
data made of up many fields (line1, line2, city, state, etc.). So I can
populate the first address in the row's left template, but how do I then go
to the next row of data for the 2nd address while remaining in the 1st row
in the datagrid to populate the right template? And then continue on like
this in the next datagrid row? I know I could write a special stored
procedure that would put 2 addresses on each row of data and call all of the
fields something like this: 1line1, 1line2, 1city, 1state, 2line1, 2line2,
2city, 2state, etc. But to do this I need to create a #temp table in the
stored procedure and use a curser to loop through the data adding 2
addresses to each row of the temp table. This is not a scaleable way of
retrieving data from the server. Surely this must be a common problem with
a more elegant solution?
Any great ideas out there?
--
mo*******@nospam.com