Thanks for your help Peter and posting the stored procedure and function, this has been a great help to me.

Many thanks

Mark

Thanks again Peter,

I've actually got the search feature working using ASP & I just looked back over my original question,

I am actually only returning the rowes from the postcode database...

My ASP Distance function calculates the longitude and latitude between two postcodes and uses mathematical functions, does SQL Server support these functions, any advice would be appreciated. Thanks mark

This is...

Thanks for the advice Peter,

My post code database while still on the same SQL Server is a seperate database from my dealers database, could i still perform the processing on...

And the columns are postcode, latitude and longitude.

Thanks again Mark

I'm just selecting all from the database and working out the calculations on an ASP web page.

I just need to be able to return the amount of rows quicker, I...

Thanks all for advice and comments, i've managed to get the project completed using Stored Procedures. The forums been a great help to me.

Thanks again

Mark

Hi Peter,

I'm now trying to pass a parameter to the Stored Procedure from an ASP page, I've changed the stored procedure to accept parameters but its the actual ASP page...

Many thanks Peter your code has given me the results I need with a very fast return to the webpage.

I should have noticed the variable @cnt never increments, thanks for...

Thanks for your help Peter & excellent advice,

I'm new to SQL Server and not long graduated so i've tried to write the Stored Procedure called upSys_AllCellSites and and a User...

This my function below Ian, any help would be appreciated thanks:

VBScript Function used to calculate number

'of working days between two dates

'----------------------------------

Function WorkingDays(msDate1, msDate2)

Dim msFirstDate

Dim msSecondDate

Dim mlArraySize

Dim dateToCheck()

Dim mlWeekdays

Dim mlCounter

msFirstDate...

Hi,

thanks for the reply and offering to help, any advice would be much appreciated.

Thanks

this is my ASP function:

1 AND Weekday(dateToCheck(mlCounter))

Thanks for the reply Tim and the good advice on arrays, while trying to converting my ASP function to a Stored Procedure I've found that while support for the date...