Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query.The Stored Procedure is:
CREATE PROCEDURE sp_DisplaySchedule @ttStartTime datetime, @ttEndTime datetime, @tiDeptID int AS select * from meetings where deptid=@tiDeptid and blockmember=0 and iscancelled = 0 and begintime between @ttstartTime and @ttEndTimeI haven't been able to find an example of how to write it with the convert. The @ttStartTime and ttEnd time are vfp DateTime fields. The BeginTime is a datetime field in SQL Server.