SQL return Date

[hussein2000]

1- I have select, which is supposed to return appointments that need notified bewteen today and the appointment date. Sounds simple, but, the appointments have a notification date...which depends on how many days in advance the client wants notified


2- and On top of that
holidays and weekends add to the days in advance.


thanks