Thread: stored procedure with two result sets
View Single Post
  #2 (permalink)  
Old May 26th, 2006, 09:04 AM
David_the_DBA David_the_DBA is offline
Friend of Wrox
  
Join Date: Dec 2005
Location: , AZ, .
Posts: 146
Thanks: 0
Thanked 0 Times in 0 Posts
Default
CREATE TABLE #FileList (Files varchar(8000))
INSERT #FileList (Files)
EXEC master.dbo.xp_cmdshell 'dir c:\'

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com
Reply With Quote