Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql server Stored Procedure Help
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Sql server Stored Procedure Help
Miscellaneous
Thread ID:
00589800
Message ID:
00589800
Views:
56
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
Next
Reply
Map
View

Click here to load this message in the networking platform