Okay -- for anyone trying to work on this, I've put together a quick 'n dirty test scenario.

Here's the sample data:create table #test1 (tdate date)

go

create table #test2 (fdate date)

go

insert into...

I understand what he wants. I'm just not entirely sure how to resolve it. I'm messing around with some ideas.

Lynn Pettis (1/26/2010)

---

Alvin Ramard (1/26/2010)

---

Alvin Ramard (1/26/2010)

---

Edit: Oops, I missed the "Pl...

I think I understand what you're looking for. Let me see if I understand this correctly . . .

Suppose you have a table, t1, that contains:2010-01-15

2010-01-13

2010-01-01

2010-01-11

And you have a...

Who are you, and what have you done with Jeff Moden? 😀

(Sorry, couldn't resist!)

. . . hence the reason why I said places, not ballparks! ...

This thread seems too quiet, so let me throw out some fodder . . .

Your opinion: what are the best and worst places to watch a game?

Note that I didn't...

Had a rehearsal last night with my community concert/symphonic band. (I'm the principal clarinetist and section leader.)

Any other symphonic musicians here?

briogene (1/21/2010)

---

I will tell u that just get any book out there that shows you how to do it then Practice , practice practice

Thirty minutes a day will do...

Add me to the angry chorus.

This is not a fair question. More detail is needed before we can give an honest answer.

I want my points back.

BOL comes with SQL Server.

A lot of people on these forums (myself included) will probably suggest that you get yourself acquainted with the documentation that comes with SQL (referred to as "Books Online," or...

So would I, but hey, I don't play big-league ball! 🙂

I'd be concerned about offering a...

roundel1900 (1/20/2010)

---

I am assuming I would use the dateadd function but how would I retrieve the date from two weeks ago from today's date. I basically need to retrieve records...

I heard King Felix signed a five-year extension with Seattle. And a number of others avoided arbitration by signing contracts.

Speaking of arbitration, I understand Tim Lincecum submitted a figure...