Link to home
Start Free TrialLog in
Avatar of sherbug1015
sherbug1015Flag for United States of America

asked on

Windows Batch File using SQLCMD

I need to set the current date in a windows batch file and pass that date in a query using SQLCMD.

What I have so far is:

For /f "tokens=2-4 delims=/ " %%a in ('date /t') do (set mydate=%%c-%%a-%%b)  -  This does not return the correct date.  Any ideas on what is wrong?

SQLCMD -s "myserver" -E -Q  "SET NOCOUNT ON;Declare @varoutput varchar(20);SELECT @varoutput = Select WorkDate from BusinessDayCalendar where WorkDate =mydate and nthBusinessDayMonth = 5 and Holiday is Null;SELECT Case when @varoutput is Null then '0' else @varoutput end;"

in the SQLCMD how do I return the value from the query.  For example  if today is the 5th business day then it should return a date, if not then it will return a 0.  I need to test whether it returned a date or not so I can execute a SQL Server Agent Job.

Any help would be appreciated.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of oBdA
oBdA

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial