I have a basic query that I would like to display orders that have been ameneded. I do however need it to display results from today only, so in the software we user it will show a real time result of the query (clicking refresh in the software would do this)
The column is in a date time format e.g 2013-05-24 00:00:00 - I don;t seem to be able to get the desired results - below is the script minus the part in the where clause that I require.
Can anyone assist
select OH.OrderID, OH.Deleted, C.Name as 'Customer Name', OH.OrderNumber, OH.DateTimeLastModified from OrderHeader OH inner join Customer C with (NOLOCK) on C.CustomerID=OH.CustomerID where OH.DateTimeLastModified = ???? and OrderType=1 order by DateTimeLastModified asc