Why speculate Do a test Run the following code several times and tell your team mate "Sorry,...

That certainly doesn't help the rest of us... Please post the "e-mail w/ example" here

Just like anywhere else... build a calendar table and a separate holiday table... include holidays for every country and make sure the holiday table has the ISO country code in...

Dinendra,

We need to know why you want to do this so we can give you the most correct answer.

(Thats' why, Ben )

You might be able to use some form of recursive CTE in SQL Server 2005, but your request is in an SQL Server 2000 forum. 

The UDF that David suggested...

...and, if there hasn't been too much activity, you may be able to recover the MDF and LDF files if they were, in fact, deleted.

Add an Identity column and delete the dupes when the import is done... much faster than trying to build an "UPSERT" (merge) in SQL Server 2000.

Here, here and well said.  Thanks, Matt.

Steve, thanks for taking the time to remember veterans and for paralleling the "give" and perils of good people in the world of IT.  A...

Ah hah!!!  THAT's why my checkbook is a mess!  I used Kerchoff's law of voltage dividers as applied to a WheatStone Bridge instead of the good ol' Boltzmann factor k

Yep... I agree... sorry I missed that...

Nice job again. Looking for work?

Nah... Scott would think I'm looking for a cure for cancer

You mean this query???

Declare @Counter int

Set @Counter = 1

While @Counter <= 1000000

  Begin

     Print Case When @Counter % 15 = 0 Then 'BizzBuzz'

           When...

Heh... relax, Scott... we're all having a bit of fun here.  Grant's post was great for stirring the pot... haven't seen this much going on in a long time.  It's...