Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Pivot with dynamic number of columns

    sorry my English is poor,I'm trying:-D

  • RE: Pivot with dynamic number of columns

    😛 select 'oh! '+ char('115')+char('104')+char('105')+char('116')

    --an exampl

    --?create test table

    create table test(indust varchar(10)

    ,[200301] varchar(10)

    ,[200302] varchar(10)

    ,[200303] varchar(10))

    insert test select 'a','111','222','333'

    union all select 'b','444','555','666'

    union all select 'c','777','888','999'

    union all select 'd','789','910','012'

    go

    --?table information

    select...

Viewing 2 posts - 1 through 2 (of 2 total)