declare @columnlist varchar(max) = stuff((select distinct ',[' + format(doc_date,'yyyyMM') + ']'   from [AOtest].[dbo].[nsk] where shop_code=N'00303НСК' and product_id=13321 order by ',[' + format(doc_date,'yyyyMM') + ']' for xml path('')),1,1,'')

declare @dispcolumnlist varchar(max) = stuff((select distinct ',[' + format(doc_date,'yyyyMM') + '] as docnum_'  + format(doc_date,'yyyyMM') from [AOtest].[dbo].[nsk] where shop_code=N'00303НСК' and product_id=13321 order by ',[' + format(doc_date,'yyyyMM') + '] as docnum_'  + format(doc_date,'yyyyMM') for xml path('')),1,1,'')
declare @dispcolumnlist2 varchar(max) = stuff((select distinct ',[' + format(doc_date,'yyyyMM') + '] as shipcount_'  + format(doc_date,'yyyyMM') from [AOtest].[dbo].[nsk] where shop_code=N'00303НСК' and product_id=13321 order by ',[' + format(doc_date,'yyyyMM') + '] as shipcount_'  + format(doc_date,'yyyyMM')  for xml path('')),1,1,'')

declare @sql varchar(max) = 'select shop_code,
product_id,' + @dispcolumnlist + ' into table1 from (select shop_code,
product_id,format(doc_date,''yyyyMM'') as monthdate,ship_count from [AOtest].[dbo].[nsk] where shop_code=N'00303НСК and product_id=13321)t pivot(sum(ship_count) for monthdate in (' + @columnlist + '))p'

exec(@sql)

select @sql = 'select shop_code,
product_id,' + @dispcolumnlist2 + ' into table2 from (select shop_code,
product_id,format(doc_date,''yyyyMM'') as monthdate,doc_num from [AOtest].[dbo].[nsk] where shop_code=N'0303НСК and product_id=13321)t pivot(count(doc_num) for monthdate in (' + @columnlist + '))p'

exec(@sql)