The answer was wrong, yes, but the principle behind it was correct.  The rest is up to the user.

Good teachers make themselves unnecessary by helping the student to learn without having to hold thier hand all the time.  I would prefer to have someone show me the way,...

No, he didn't.  But I think he noticed, as his experimenting used 14 instead of 21.  And he did indicate that my solution was slick, and simplier than what he...

Well, He has the logic, and the theory behind it.  Now he has to apply it and adjust it to his environment.  I have asked for help, gotten advice, applied...

From his first post:

If we use today for example (Thursday) we would add 6 days to the 21 days. 

That looks like a totla of adding 27 days to todays...

Based on what he was looking for, 2006-12-06 is the correct answer.  Found the next Wednesday meeting and added 21.  If you wanted the third Wednesday, change the 21 to...

I majored in Computer Science, I minored in Mathematics.  Looking for patterns and solutions to them seems to come easy, especially when math is involved.

Hope this helps with what you...

How the whole thing works:

Based on Sunday as the first day of the week:

Day     Num Days to Add

Sun     1      3

Mon     2      2

Tue     3      1

Wed    ...

I could try to explain how they work, or better yet, I could just have you read BOL first and then if you have any questions, we can can talk. ...

Can't help much on the mass update, but I would suggest doing a search on this site for articles about portable DTS packages.  In developing a prototype data warehouse, I...

Try the following (it assumes the following default: set datefirst 7 (Sunday is the first day of the week)):

select dateadd(d, (7 - ((datepart(dw, getdate()) + 3) % 7) + 21),...

In your data flow where you load the data, you would add a lookup task.  You want the records where the lookup on the unique id fails to flow through...

The domain accounts running our SQL Servers have admin rights.  I would also make sure you have another user with sys admin rights besides your own account, not just in...

It should.  However, I would recommend that you backup to a local drive and then copy the backup file to the network share and then if needed delte the local copy...

Your destination should look something like this:

\\servername\sharename$\dbbackupfile.bak

If you have a space in the file name, you may also need to surround the entire destination string in double quotes.  Personally,...