In Report design it display only col1 col2 field but Col_,... can not display.

Please help to advise for this

Thanks

Hi.

After try your concept it work but for static column the dynamic column does not work.

Let say I modify your query like this.

create procedure test

@colTotal int

as

declare @colList varchar(200)

set @colList=''

declare @colCnt...