I am working on a program that calculates the business days excluding the weekends and holidays. There is a SQL statement that counts the number of holidays between the start date and the end date that excludes weekends. But this SQL statement is very slow. I mean it takes more than 80% of the time to execute the businessday function. The table it is accessing is a foxpro table.

Also, I am working on another prj that needs me to insert new records to a MS SQL server from FoxPro. I have the same problem with the insert to. It works but it is very slow takes more than 90% of the time to execute the function. If anyone has any suggestions or explantion on why it takes such a long time for a sql statement to execute that is connected to a SQL server please let me know. I have written the same thing where it connects to a FoxPro dbf table and the inserts and the select queries run faster than when i try to use them with a sql server.
I am using SQLSTRCONNECT to connect with the SQL server and SQLEXEC to excecute stored procedures and Inserts.