have to specify the order in Selecing columns.

declare @TableName varchar(max)
set @TableName = 'TableName'
declare @selectstatement varchar(max)

SELECT @selectstatement = ISNULL(@selectstatement, '') +  syscolumns.name +','+syscolumns.name  +','
    FROM sysobjects 
    JOIN syscolumns ON sysobjects.id = syscolumns.id
    JOIN systypes ON syscolumns.xtype=systypes.xtype
   WHERE sysobjects.xtype='U' and sysobjects.name= @TableName
ORDER BY sysobjects.name,syscolumns.colid
set @selectstatement =  'select '+substring(@selectstatement, 1 , LEN(@selectstatement) -1)+' from '+ @TableName

 exec (@selectstatement)

/****** Object:  StoredProcedure [dbo].[FindTableValueByRepeatingColumns]    Script Date: 02/01/2012 12:20:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[FindTableValueByRepeatingColumns]
(
@TableName as NVARCHAR(MAX)
)
AS
BEGIN

DECLARE @Columns as NVARCHAR(MAX)
DECLARE @SQuery as NVARCHAR(MAX)
SET @Columns=''
SET @SQuery =''

SELECT @Columns=@Columns + Name + ','  FROM
(
select SC.name,Colid from syscolumns SC inner join sysobjects SO on SC.id=SO.id
 WHERE SO.name=@TableName
Union all
select SC.name,Colid from syscolumns SC inner join sysobjects SO on SC.id=SO.id
 WHERE SO.name=@TableName
) AS tbl1 Order by colid

SET @SQuery ='SELECT ' + SUBSTRING(@Columns,1,LEN(@Columns)-1)  + ' FROM ' + @TableName

EXEC SP_EXECUTESQL @SQuery 

END