query issue

[royalcheese]

I have the statement . . .

select 		 member_key
		,pre97vfm
		,dqsf
		,pre97incind
		,pre97penatnrd

from 		tid

order by 	 member_key

which returns

16.0 NULL 1974-07-01 NULL NULL
20.0 318.798 1983-07-11 NULL NULL
23.0 8304.88 1971-08-26 NULL NULL
30.0 2487.11 1980-09-15 NULL NULL
38.0 NULL NULL NULL NULL
38.0 566.02 2004-08-21 NULL NULL


which is great but on the the number 38 i would like it to be repeated so only one line appears , etc like below .

38.0 NULL NULL NULL NULL 566.02 2004-08-21 NULL NULL

The thing is that some lines are repeated up to 5 times and will need to kept tacked on the end , does any one have any advice / pointers or code ?

Many thanks in advance

 

[mrdenny]

This would need to be done in the client.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com