It can be done in dynamic sql but 1st i need to know, is there any limit of there will always be Price1, Price2 & Price3 etc columns, or you can have N number of Price ? and other related columns