Except one thing.

Number of 'DPL_CODE' will vary..So the name..Client may put as many as they want with wotever the names they like..

So we can't hard code it like following

ISNULL([VP-LISO],0) as [VP-LISO],

ISNULL([XP-CMO],0) as [XP-CMO],

ISNULL([MP-COM],0) as [MP-COM]

Otherwise everything is perfect...exactly wot I want..

Thanks,

Santhosh Nair.