I have found that both queries are sematically equivalent, and perhaps the better answer could have been C (both) (FYI, I choose B and got it right). However, the...

If you look in my signature block below, you will see several references to articles. Look at the fifth line, talks about cross tabs and pivots, there are two...

Lynn Pettis (1/27/2010)

---

GilaMonster (1/27/2010)

---

If you feel that way, add your comments on...

GilaMonster (1/27/2010)

---

If you feel that way, add your comments on the Connect...

Also, if the explanations you have gotten here aren't enough, or you'd like more information, I highly suggest that you read about the SELECT statement in BOL (Books Online, the...

Thank you. Lutz. That was a case of not holding the shift key as...

Greg Edwards-268690 (1/27/2010)

---

Paul White (1/26/2010)

---

Really? Wow. I thought it was reasonably recent - and also that you had been...

First, don't call me dear. It isn't appropriate.

Second, you are getting just what you are asking for in your select.

SELECT -- Have SQL return something to me

...

Ray K (1/26/2010)

---

Our OP sent me a message to say my understanding of his problem is dead-on.

Alas, I don't have as much SQL experience as many of you here. ...

The force is strong today between us, Jack. 😉

Grasshopper,

Does the following sample code help you?

declare @table1 table (

TradeDate datetime

);

declare @table2 table(

FXDate datetime,

FXRate decimal(6,2)

);

insert into @table1

select '20100112' union all

select '20100115';

insert into @table2

select '20100111', 1.40 union all

select '20100115', 1.42;

with MatchedDates...

Alvin Ramard (1/26/2010)

---

Alvin Ramard (1/26/2010)

---

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

We got that, we would like to see what you have tried so far to solve your problem.

Felt a little crowed even in my Hogwarts' supplied tent. 😉

rwturner (1/26/2010)

---

I am unable to access the database from QA. Does this command 'restore database [dbname] with recovery' have to be run from the database I am having problems with?

If...