Hi Prabhu,

Declare @sqlquery1 varchar(max);

Declare @sqlquery2 varchar(max);

set @sqlquery1='jan2015,feb2015,march2015';

set @sqlquery1=Replace(@sqlquery1,',','.');

set @sqlquery2='jan-Transferdate,feb-transferdate,mar-transferdate';

set @sqlquery2=Replace(@sqlquery2,',','.');

Select ParseName(@sqlquery1,3)+','+ ParseName(@sqlquery2,3)+','+ ParseName(@sqlquery1,2)+','+ ParseName(@sqlquery2,2)+','+ ParseName(@sqlquery1,1)+','+ ParseName(@sqlquery2,1);

If the above solution is helpful then,accept the answer.

How to change order of variable that contains array of dat

1 Reply

If the above solution is helpful then,accept the answer.