Kelly writes "Hi.I wouldn't mind talking with someone on this, because it may prove difficult to explain on a forum.Here is the scenario:I have a very large database that I am pulling data out of. The data is grouped and sorted blah blah blah.Once I have a near-final set of data, it is about 10-20 rows. The data is very inter-related data, and I need to kind of combine rows using some sort of temp table or cursor or for-next statement. I just don't have a clue where to begin.Here is the layout:Year name1 desc1 cms1 excl ID1---------------------------------------------------------2004 141.1 somedesc NULL 0 547772004 141.1 somedesc NULL 1 547772005 141.1 somedesc NULL 0 547772003 733 somedesc2 NULL 0 547772004 733 somedesc2 NULL 1 54777
Anyway, this is a start.The client wants this data to come out looking like this:Year2005 Year2004 Year2003 Name1 Desc1 cms---------------------------------------------------------- x x 141.1 somed NULL x x 733 somed2 NULL
"
Getting Results in the right format 
Posted - 2005-10-06 : 07:55:53
