Try this:

SELECT

dbo.Product.ProductID,

dbo.Product.Category,

dbo.Product.ProductCode,

dbo.Product.Description,

dbo.Product.Price,

dbo.[Order].CustomerID,

dbo.[Order].OrderID,

dbo.[Order].OrderDate

FROM

dbo.[Order]

INNER JOIN dbo.Product ON dbo.[Order].ProductID = dbo.Product.ProductID

WHERE

convert(datetime,convert(varchar(20),dbo.[Order].OrderDate,106)) = convert(datetime,convert(varchar(20),getdate(),106))

Create a batch file and add the below content (Replace all the values e.g. SQL Server name, user Id, Pwd)

----------------------------

setlocal

SET SQLCMD=sqlcmd -S SERVERNAME -U LOGINID -P PASSWORD -d DATABASE NAME

for...