Nadrek (11/16/2009)

---

I didn't see it later on, but my solution in the past has been very simple; nest REPLACE() two spaces with one space as deep as required for the...

A while back, Jeff Modem came up with this cute one:

create function workdays_jeff(@p_startdate datetime, @p_enddate datetime) returns integer as

begin

return

(DATEDIFF(dd, @p_startdate, @p_enddate)+1)

-(DATEDIFF(wk, @p_startdate,...

Wow, got it to work!

It's pretty much based on what I wrote.

Had the wrong port in the tnsnames.ora file.

And as usual, when something works, the simplicity of it all stares...

There is also a charge to sign up to MetaLink via an Oracle support identifier. This is starting to get expensive.

I'm now browsing through the Oracle documentation and, for ODBC,...

While we are on Oracle, let's try and solve this.

I was amazed by how easy it was to link SQL Server to Oracle.

But I'm totally flabbergasted by how hard it...

How about putting everyting into a .BAT or .CMD file.

Then you can try it out outside sp_cmdshell in a Windows command window.

As for the way you invoke a jar file,...

Bob Hovious (2/4/2009)

---

I challenge anyone to a benchmark:

1. a million rows of StartDate, BusinessDays, EndDate

2. update thistable set EndDate=YourFunction(StartDate,BusinessDays)

3. a table of holidays consisting of a single column Holiday containing...

Andrew Reilly (2/4/2009)

---

I did this without a loop using a recursive function just take the start date add the number of work days that you want and then count how...

Above Amit Lohia says:

For example, if there is a holiday between the dtEndDate from step 2 and dtEndDate from step 3

This is the correct diagnosis of the flaw. But the...

Prove it!

It's the flaw you mentioned that makes a loop necessary.

And adding weekends to you holiday table is not going to solve that either.

Are you sure?

Show us an example, or at least describe your approach conceptually.

The topic of adding business days to a date was...

Where I live (Italy), it doesn't work that way at all. The first people to be let go are the external consultants. That's because it's pretty hard to fire employees....

Well, this thread has started with a fairly reasonable/serious question and ended up getting a bit fluffy. A lot of the potential comments in a thread like this depend on...

You can use the set of tables below and schedule a stored procedure every minute that takes a snapshot of the currently logged on users. This then captures start and...