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...

You probably told EM to not recover the database after the last t-log backup was restored. In QA execute the following:

restore database [dbname] with recovery; -- dbname is the...

Faye Fouladi (1/26/2010)

---

Suppose:

Declare @mynumber int

Set @mynumber = 10299

How can I return 102.99 from this or if the variable will be given at runtime, how can I process...

I'm thinking you meant to type this:

select * from tablename

Looks to me like you forgot to hold the shift key when you press the 8.