@echo off

: Gerard O'Rourke
: Date 13/09/2016
:

FOR /F "TOKENS=1 eol=/ DELIMS=/ " %%A IN ('DATE/T') DO SET dd=%%A
FOR /F "TOKENS=1,2 eol=/ DELIMS=/ " %%A IN ('DATE/T') DO SET mm=%%B
FOR /F "TOKENS=1,2,3 eol=/ DELIMS=/ " %%A IN ('DATE/T') DO SET yyyy=%%C

SET /P dd=Please enter Day (dd) [%dd%]?
SET /P mm=Please enter Month (mm) [%mm%]?
SET /P yyyy=Please enter Year (yyyy) [%yyyy%]?

echo RUNNING SQL QUERY
echo.
call sqlcmd -v mydate="%yyyy%-%mm%-%dd%" -i SampleProcedure.sql

SET NOCOUNT ON
USE ucce_awdb

SELECT * from Blah
WHERE DateTime Between '$(mydate) 00:00:00' AND '$(mydate) 23:59:56'