Wow, you guys are pretty good.  The three line solution didn't show up yet, and it looks like no one's solved the prime number riddle (T-SQL would probably be a...

Reminds me of another old joke, but I can't post it to a family-oriented website

OK, here are three more moldy oldies:

1.  Are there three 2-digit primes that have the following properties:

• The average of the sum of all three is a prime number
• The average of the...

Computer people always make things so complicated...  I think that's why I love the job   Someone already posted the generally accepted answer, but in...

You'd be surprised.  This was an actual question I got on a job interview...  they used it to try to gauge your thought processes.  I gave a pretty aggressive answer: ...

It can be done, but just because you can do something doesn't mean you should

I agree - I think a lot of what's been lost is in low-level troubleshooting and low-level optimizations, since most of that has been abstracted away.  A lot of the...

Don't forget RANK(), DENSE_RANK() and NTILE().  See http://www.sqlservercentral.com/columnists/mcoles/sequentialordering.asp for more info.  Also discusses other reasons IDENTITY column and other options are not optimal solutions.

Thanks.

No waste of time   We all hit little snags and brain freezes every now and then.  Best of luck!

Hmmm.  Are you adding Parameters to the DataAdapter's SelectCommand Parameters collection?  Sounds like you're re-adding them twice.  If that's the case, clear out the parameters collection before adding them or...

Good deal   Enjoy

Then you need to set up a scheduled job to run every two hours.  A good place to start is to go into Enterprise Manager, right click on "Management" and...

Good to hear   You can use INSERT INTO to insert the results into a temporary or other table.  The exact format and datatypes...

Would I have to have this job running all the time? New records are being created constantly and I dont think that have the job running only every 2 hours...

hehe Excellente!