if OBJECT_ID('tempdb..#dir') is not null drop table #dir create table #dir ( dir varchar(1000), depth int, is_file int ) insert into #dir execute master..xp_dirtree 'c:',1,1declare @s varchar(8000) select @s = ISNULL(@s+',','')+dir from #dir where dir like '%.bin' print @s
if OBJECT_ID('tempdb..#dir') is not null
drop table #dir
create table #dir
(
dir varchar(1000),
depth int,
is_file int
)
insert into #dir
execute master..xp_dirtree 'c:',1,1declare @s varchar(8000)
select @s = ISNULL(@s+',','')+dir from #dir
where dir like '%.bin'
print @s