Guess will just post my version maybe will be of some help to someone else.

CREATE FUNCTION [dbo].[weekday_dateadd] ( @startDate SMALLDATETIME, @Days INT, @SkipHoliday BIT = 1, @DayOnly BIT = 1...

thank you but unfortunately I don't think that will accommodate my need. I need to be able to add days (weekdays only excluding holidays) to a date, my basic...

Anyone... would be a great help... thank you.

thank you very helpful!!!

Wonderful code... could someone assist with a function that uses dim_Date table(s) and works something like http://www.sqlservercentral.com/Forums/Topic207135-23-1.aspx but also accommodates for holidays???

Thinking something like this:

weekday_dateadd(dateTime,<# weekdays>,<0/1>Skip holidays,<0/1>DayOnly -drop time)

Select weekday_dateadd(getdate(),10,1,1)

Thank...

Not sure if this is the best way to do it but managed to figure it out some what :> WOHOO!

UPDATE #TestTable

SET @prev_flag = flag =...

Ok, reading posting now... trying to figure out how to take this to my final step as still trying to understand the SQL :|.

Like to get the first 1 to...

That is just the most awesome thing ever!!!! Works like a champ and fast as can be.

Thank you, Thank you,Thank you and Thank you!

(I will definitely read that...

I don't like it as it's slow as can be looping 11+ Million records but this does what I need... if anyone can give me suggestions how to do this...