Please,

In SQL SERVER 2000, I am doing a recursive select, which generates a long string that is not tab-delimited. On every recursion, I tried adding '\t', the escape character for tab, but excel ignores '\t', and prints the long string (with multiple '\t') into a single column. Not very convenient.

From maximum 70 rows, I want to convert into maximum 70 columns, with headings at the top of every one.

I am sure that this must look like a silly beginner question, but if anyone would like to take the time to show me how to report like this, I would sure appreciate. It would be helping a school teacher who writes his own student performance database.

If I can't get a simple answer, then I think I'll have to write some script.

Thank you,
Daniel Hutchins
Teacher, Stockton, CA


select
--**** Scores:
@decSumScores = @decSumScores
    + isNull(#NormalizedData_MultiplePK.decScores,0.),
--**** Points Possible:
@decSumPtPossible = @decSumPtPossible
    + isNull(#NormalizedData_MultiplePK.decPtPossible,0. ),
--**** Code:
@strConcatCodes = @strConcatCodes
    + isNull(convert(varchar(6),#NormalizedData_Multiple PK.smDates,7),'?') + ':'
    + cast( isNull( #NormalizedData_MultiplePK.codes, '' ) as varchar(20) ) + ','
    + cast(isNull(#NormalizedData_MultiplePK.decScores,0 .) AS VARCHAR(10))
    + '/' + cast( --as string
            cast( --as decimal
                isNull(#NormalizedData_MultiplePK.decPtPossible,0)
                as decimal(18,0)
            )
            AS VARCHAR(10)
         )
    + '.. '
FROM #NormalizedData_MultiplePK
WHERE #NormalizedData_MultiplePK.ID_Student = @ID_Student

Daniel Hutchins
Stockton, CA
http://www.finehomemadesoap.com

__________________
Daniel Hutchins
Stockton, CA
http://www.finehomemadesoap.com