How to convert column to row in sql server : I would like to convert following data
CLAIMID	CODENUMBER
2	       465.9
2	       238.8
2	       461.9
2	       786.2

Would like to see as
CLAIMID	ICD1	ICD2	ICD3	ICD4
2	    465.9	238.8	461.9	786.2
 Your help will be appreciated..

