I have 2 dates, @date1 and @date2, can someone show me a way to calculate weekdays only between the two dates without using a calendar table using SQL
Here are some conditions:
1. If the start or end date falls on a weekend, skip those days. eg: 9-18-10 (sat) to 9-25-10 (sun) should return 5
2. If both start and end date are on the same weekend, return 0
Thanks in advance.