XP batch file loop help

[JackInDaBox]

Hello,
I am trying to run all SQL scripts (with no params) in the same folder as the batch file is. I have not done much with batch files before but I think I have gotten close. It seems to work if I hard code the FILENAME.sql but will of course only work for the file I hard coded. What I need is to get the present file name from the loop and put it in to the FILENAME.sql so it will run that sql script. Hope this makes some sense and here is what i have so far:

@echo off

SET ServerName=
SET /P ServerName= Please enter the Server Name:
SET DatabaseName=
SET /P DatabaseName=Please Enter Database Name:

for /f %%a in ('dir /b *.sql') do call :process
goto :eof

:process
osql -E -S %ServerName% -d %DatabaseName% -n -i FILENAME.sql > Report.txt

Thanks

[Banfa]

Try this

@echo off 
 
SET ServerName= 
SET /P ServerName= Please enter the Server Name: 
SET DatabaseName= 
SET /P DatabaseName=Please Enter Database Name: 
 
for /f %%a in ('dir /b *.sql') do call :process %%a
goto :eof
 
:process
osql -E -S %ServerName% -d %DatabaseName% -n -i %1 > Report.txt
goto :eof
 
 

[JackInDaBox]

Great, thanks works perfect.