workdays in SQL 7.0

[Romanichine]

Hi,

I need to convert an Access application to a web application
with SQL 7.0 running behind.

Now there is this workdays() function that I am stuck with.
The function receives two dates in arguments, and returns
an integer corresponding to the number of working days within the two dates (i.e. removing the holidays contained in a Holiday table, and removing saturdays and sundays). In Access you can call it within a SQL statement such
as in:

SELECT (myTable.iRatio / workdays(myTable.dateStart, myTable.dateEnd) as "average_by_day",
myTable.dateStart, myTable.dateEnd
FROM myTable

With SQL Server 2000 this function would be easy meat to
convert using an UDF, but unfortunately I'm forced to
use 7.0 on this project and have absolutely no idea how
to make the conversion.

Any help would be really appreciated.

Thank you!
--
Roman.

 

[Rishi146]

Why can you use a stored procedure?

you can pass parameters from ASP to stored procedure

IF you want an example please ask
or search
This forum

http://www.planet-source-code.com

http://www.asp101.com

http://www.google.com

(search for passing parameters to stored procedure in SQl server 7)

or ASK


Rishi (MCSD,MCP,MCDBA)