values into columns

[prodadmin]

thanks for looking into

when i use the case stmt i get lot of blanks

CASE WHEN  fNAME='Units' then p.value else null END AS unit_name,
CASE WHEN  fNAME='Date' then p.value else null END AS date_name

like this ..

Order_ID	UNIT_NAME	DATE_NAME
30766600	1	
30766600		090909
30766600	1	
30766600		090909
30766600	2	
30766600	13

but i am looking for

Order_ID	UNIT_NAME	DATE_NAME
30766600	1	090909
30766600	2	090909
30766600	1	
30766600	13

hope this helps

thanks