Matt Miller (10/18/2007)

---

Greg -

I think you need to try the solution I posted. The reverse engineering you did has some logic flaws. In particular - you're going to...

Jeff Moden (10/18/2007)

---

I've found that date tables are fine for RBAR... but, how would you use the date table in this instance of batch code and still have...

Kenneth, I probably should refer to it as weekdays, but as far as my production is concerned no weekends are work days. I may end up having to...

False alarm. There is still something wrong with saturdays.

Ok, I think I fixed it. I forgot one thing from Jeffs function, then I just fiddled with the numbers until it seemed to work.

IF OBJECT_ID('dbo.fnAddWorkdays','fn') IS NOT NULL

DROP...

Well...it seems to have some problems. If I start on a week day I should always end on a week day, but my function does not seem to do...

Ok, I figured it out. I knew it had to be a reverse of Jeff's code, which can be found at

http://www.sqlservercentral.com/articles/Advanced+Querying/calculatingworkdays/1660/.

And it was. I had to...

I am so...

Thanks Daryl. I want to do it without having to make a days table. I know there is a way, I just can't get my head around it

This ought to work. Jeff Moden helped me with a couple of these, and I think this is one of them, but I can not remember exactly, but it...

[/quote]

Every time record is created trigger copies required data to EmailOut and set "delivery date" to 5 days from now.

Every time record has got updated with proper customer response trigger...

Still not much to go on. Maybe you could post your table structure and some sample data to work with. Are you tracking which object the data came...

You can also open Enterprise Manager, expand the console root to your database, then expand the objects in your database. If you expand the tables, for example, then right...

Chris, If you search in the above search box for 'audit table' you will see more solutions than you can shake a stick at. I can tell you one...

Roberto, I am unclear on what you are trying to do. How are you calling the procedure? Your procedure selects, but not from another table. Are you...