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.