The five run rule simply means that once a team has scored five runs in an innings it is side away, exactly for the reason you mentioned, keep the fun...

ColdCoffee (6/8/2010)

Jan Van , think u probably...

Why make it that complicated?

DECLARE @Fathers TABLE (FatherId VARCHAR(10), age INT)

INSERT INTO @Fathers

SELECT 'Father1', 12

UNION ALL SELECT 'Father1', 17

UNION...

Is this a homework question? We're happy to help, but please first show us what you have tried already. Also show us your table structures and give us some readily...

No problem, that's what we are here for.

Which one of the two umpires is Jim Joyce? The Plate Umpire or First Base Umpire? Shocking decision whoever made it. If I was the base Umpire with my limited...

True Nils, but since the OP's question wasn't exactly clear (and he didn't get any more specific later), both Wayne and I just took a stab at it.

TFS on the current project, SubVersion on the previous and VSS on the one before (my, I hated that one).

Are you saying you want to see all columns from Table2 as well? Then Wayne's example only needs a tiny change:

SELECT t1.*, t2.*

FROM Table1 t1

...

Just guessing here, so correct me if I'm wrong. I'm assuming that you are doing sommething like

SELECT name, street, city, county, postcode, country

FROM customeraddresses

WHERE <some condition>

and that some of these...

Uhm, why don't you try it out?

Glad it helped. And thanks for the feedback.

ColdCoffee, the OP said 60 days, not 2 months, right?

Change

SET @FromLast2Month = substring(convert(varchar,@Last2MonthDate,112),1,6)+'01'

to

SET @FromLast2Month = substring(convert(varchar,@Last2MonthDate,112),1,8)

That should do the trick

Try

USE MyDB1

GO

EXEC MyDB2..sp_rename 'MyTable', 'YourTable'