declare @i int
select @i=(max(datalength(pr_info))+7999)/8000
from pub_info
set rowcount @i
select id=identity(int,0,1) into # from syscolumns a,syscolumns b
set rowcount 0
select a.pub_id,b.id,substring(a.pr_info,b.id*8000+1,8000)
from pub_info a,# b
where (datalength(pr_info)+7999)/8000>b.id
order by a.pub_id,b.id