About what, Jeff?

My routine handles a variable end-date, but not a variable range. To do that you will need to use Dynamic SQL. Use my routine as the starting point,...

Oops, sorry. I missed that I was in the SQL2000 forum. You just need to change the CTE to be a derived table:

Alter Proc spPerfProduct( @DT as datetime...

Or:

Right('000000000' + Cast(num as varchar(10)), 9)

Thanks, Bruce

OK, I got my transducer written, ... and it's slow as heck. I'm pretty sure that it's either the "Managed Code" safety overhead or else some problem with VB.net's...

Good to know. Thanks for the follow-up Bevan!

IMHO: To insure the best interests of the shareholders with respect to the corporation.

Steve Jones - Editor (3/16/2009)

---

I think having code, emails, contacts, etc. at home is not necessarily theft. If you use it to somehow harm the company, compete with them, then...

doohickeyjones (3/16/2009)

---

At my current job, two weeks wouldn't even be enough notice, really. Likely, I will give them more along the lines of 2 months notice, to give them time...

doohickeyjones (3/16/2009)

---

I always have my email (and therefor my contacts) backup up at home, especially now that I can just connect my Outlook at home to my Exchange here at...

Roy Ernest (3/16/2009)

---

lmu92 (3/16/2009)

---

Did you notice, foxjazz didn't have to say anything within the last 70 (or so) posts? So he missed about 50% of the replies.

Maybe he's not...

Jeff, do you have a test set for this?

C'mon, I'm tying! But the dang thing keeps jumping out of the way!

If common sense were gasoline, some...

That's something...