--/*导入文本文件到临时表中
select * into #tb from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Text;FMT=Delimited;HDR=yes;IMEX=2;CharacterSet=936;DATABASE=C:\'
,aa#txt)
--/*数据处理
--创建数据处理临时表
select top 8000 id=identity(int,1,1)
into #tb1 from
(select top 100 id from syscolumns) a,
(select top 100 id from syscolumns) b,
(select top 100 id from syscolumns) c
--方式1
select substring(a.aa,b.id,3)
from #tb a,#tb1 b
where b.id<len(a.aa) and (b.id-1)%3=0
--方式2
select aa=substring(a.aa,b.id,1),bb=(b.id-1)%3
,up=cast('' as varchar(8000))
into #aa from #tb a,#tb1 b
where b.id<=len(a.aa)
order by bb,aa
declare @a varchar(8000),@b int
update #aa set @a=case @b when bb then @a+aa else aa end
,up=@a,@b=bb
select max(up),bb from #aa group by bb