how to order columns dynamically

Question

--=============
Declare @list varchar(100)
SET @list='A.[2001],A.[2002],A.[2003],B.[2001],B.[2002],B.[2003]'

Select @list

This is a sample, and my aim is to fetch columns as mentioned below :

-- Please help to get the below result by modifying the @list

Select 'A.[2001],B.[2001],A.[2002],B.[2002],A.[2003],B.[2003]'
--===============

Answer 1

0

It would be possible to use a tally table to split your string into a table and then re-order it so that it could be recompiled into a sorted string and then, from your question, I gather you want this to be used in a piece of dynamic TSQL. I am not sure this is the best way of handling what you want. Can you offer a bit of information about the rest of your project so that we can advise you better? Using TSQL to do complex string manipulation is never an efficient solution.

answered Apr 27 '11 at 03:15 AM

Fatherjack ♦♦
38.8k ● 55 ● 69 ● 104

(comments are locked)

how to order columns dynamically

Follow this question

Related Questions