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.

Avatar of oBdA

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