Viewing 15 posts - 376 through 390 (of 667 total)
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...
June 8, 2010 at 7:08 am
ColdCoffee (6/8/2010)
Jan Van der Eecken (6/8/2010)
Why make it that complicated?
SELECT FatherId, MAX ( age ) AS 'age'
FROM @Fathers
GROUP BY FatherId
Or am I missing something?
Jan Van , think u probably...
June 8, 2010 at 5:43 am
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...
June 8, 2010 at 4:07 am
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...
June 8, 2010 at 3:32 am
No problem, that's what we are here for.
June 8, 2010 at 1:11 am
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...
June 7, 2010 at 3:19 pm
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.
June 7, 2010 at 5:40 am
CirquedeSQLeil (6/5/2010)
TFS for us currently.
TFS on the current project, SubVersion on the previous and VSS on the one before (my, I hated that one).
June 7, 2010 at 2:34 am
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
...
June 4, 2010 at 8:41 am
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...
June 4, 2010 at 8:36 am
ColdCoffee, the OP said 60 days, not 2 months, right?
June 4, 2010 at 2:33 am
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
June 4, 2010 at 2:20 am
Try
USE MyDB1
GO
EXEC MyDB2..sp_rename 'MyTable', 'YourTable'
June 3, 2010 at 5:07 am
Viewing 15 posts - 376 through 390 (of 667 total)