On Thursday, October 28, 2004 11:00 AM [GMT+1=CET], Mansur Esmann [OM] <[EMAIL PROTECTED]> wrote:
Mach's Dir doch nicht so schwer :-) Als Tipp CREATE TABLE #dir(datei_dir varchar(255), tiefe int, ist_datei int) INSERT INTO #dir EXEC master.dbo.xp_dirtree 'C:\temp', 1, 1 SELECT datei_dir As Exe_Datei FROM #dir WHERE ist_datei = 1 AND RIGHT(datei_dir, 3) = 'zip' ORDER BY datei_dir DROP TABLE #dir gruss frank _______________________________________________ Coffeehouse Mailingliste, Postings senden an: [EMAIL PROTECTED] An-/Abmeldung und Suchfunktion unter: http://www.glengamoi.com/mailman/listinfo/coffeehouse
