How to change order of variable that contains array of dat

Question

Iam writing stored procedure in that iam using pivot for columns and assign columns to variable @sqlquery1 = jan2015feb2015march2015 @sqlquery2 = jan-Transferdatefeb-transferdatemar-transferdate Iam calling this two variable in select statement like '+@sqlquery1+''+@sqlquery2+' but out came like jan2015feb2015march2015jan-Transferdatefeb-transferdatemar-transferdate but i need out put like jan2015jan-Transferdatefeb2015feb-transferdatemarch2015mar-transferdate

Rajeev Punhani · Answer

Hi Prabhu Declare @sqlquery1 varchar(max); Declare @sqlquery2 varchar(max); set @sqlquery1='jan2015feb2015march2015'; set @sqlquery1=Replace(@sqlquery1'''.'); set @sqlquery2='jan-Transferdatefeb-transferdatemar-transferdate'; set @sqlquery2=Replace(@sqlquery2'''.'); Select ParseName(@sqlquery13)+''+ ParseName(@sqlquery23)+''+ ParseName(@sqlquery12)+''+ ParseName(@sqlquery22)+''+ ParseName(@sqlquery11)+''+ ParseName(@sqlquery21); If the above solution is helpful then accept the answer.