GSquared (6/26/2008)

---

If the hierarchy is relatively static (doesn't change often), you might want to look up "nested sets" online. It does hierarchies MUCH faster than CTEs or other methods....

Steve Jones - Editor (6/26/2008)

---

I think you need to stop looking at design because people are always in a hurry. The developers don't want to do a bad job, but...

The other option was taking each line of the calculation, adding a column to a join table between the two sets, and calculating one column at a time on the...

And, that is precisely why I'd use float instead... but, whatever... it's really hard to convince people even with the ol'...

Matt Miller (6/26/2008)

---

Could daylight savins time be the differentiating factor? This would explain the discrepancy with no timezone factor involved.....

After all - the "-5" on is in the summer...

Ummm... sure... here's the original script that Carl...

Heh.. oh sure... but it's just like a developer who can't program worth a hoot.... "Why Bother?" 🙂

I'm sorry... I don't mean to be so...

Antares686 (6/26/2008)

---

Jeff Moden (6/26/2008)

---

I think you're being very generous... I've found that about half the time it's because they're simply a crappo developer that can't program worth a hoot in...

I think all the times are GMT and it's doing just like I said... it's dipping the operating system to find what the local time offset from GMT is and...

I think you're being very generous... I've found that about half the time it's because they're simply a crappo developer that can't program worth a hoot in any language... it's...

... and now you know why I wanted you to post your function 😉 There's a better way than RBAR... :hehe:

bpbhalerao (6/25/2008)

---

What i exactly wanted is:

If the StartDate is say '7/15/2007', EndDate is '8/20/2009' and the ClientDate is say '9/12/2007' (the day is Wednesday on 12 Sept) then i need...

Jeff Moden (6/26/2008)

---

bpbhalerao (6/25/2008)

---

similarly if the ClientDate is any in the year 2009 say it is 5/25/2009 (Monday), then we need to calculate the total no. of Mondays from 1...

bpbhalerao (6/25/2008)

---

similarly if the ClientDate is any in the year 2009 say it is 5/25/2009 (Monday), then we need to calculate the total no. of Mondays from 1 Jan 2009...

"IT Guy" is just laziness or ignorance on the part of the speaker and you certainly shouldn't get in a huff from being called that by folks who aren't in...