Hi Kirk,

Can you post VFP code that calls this SP?


>I'm getting the following error when I call the stored procedure:
>
>ERROR:
>

>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 @ttEndTime
>
>

>
>I 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.
>
>Thanks