Difference between two dates (Excluding weekends)

Hi ALL,


This may not be correct place to rise this question. Even i'm making here..


My requirement  is to get the number of days from from date to end date (for Eg. I have to text boxes from date and to date i will send datetime value to my Stored porcedure i need to calculate no of days between these dates (i.e. no of wroking days) Is there any function to achieve this in SQL SERVER 2005)


Any Information regarding this will be help full..


Thank You..

...