Viewing 15 posts - 40,606 through 40,620 (of 49,571 total)
Mangal9i (3/4/2009)
My topic was, Answered Posts. Nobody is talking about that.
If you stick around here, get used to this. Threads drift off topic fairly often and, as I mentioned, Steve...
March 4, 2009 at 9:29 am
Derek Dongray (3/4/2009)
They must be giving out MVPs with breakfast cereal these days!:D
Hey! Be nice!
😉
I thought an MVP needed to do more than simply post a lot on MSDN?
Who knows....
March 4, 2009 at 9:27 am
Chris, judging by your posts here, you shouldn't have much trouble with the exam.
It's implementing and maintaining, so yes, more admin than dev. Beware the sims, that's where most...
March 4, 2009 at 9:21 am
Grant Fritchey (3/4/2009)
Holy smokes, a moderator and an MVP and he's that much of a jerk? I thought you had to be... you know... helpful... to make MVP?
In theory.
It's interesting,...
March 4, 2009 at 9:13 am
mail2payan (3/4/2009)
Which columns determine the matching row in DestinationTable?
Sorry, I did not get this question.
When rows are inserted into MyTable, the matching rows in DestinationTable are updated with cumulative totoals....
March 4, 2009 at 9:07 am
Mangal Pardeshi (3/4/2009)
Ahh, thank very much Gila for asking this question.
If I suggested that a number of the top posters there were useless, would I really get those same top...
March 4, 2009 at 8:56 am
Roy Ernest (3/4/2009)
March 4, 2009 at 8:51 am
Grant Fritchey (3/4/2009)
March 4, 2009 at 8:42 am
Ok, so on insert, a row must be inserted into Destination table if it doesn't exist and updated if it does? Which columns determine the matching row in DestinationTable?
What must...
March 4, 2009 at 8:40 am
Mangal Pardeshi (3/4/2009)
Those were my general comments about forums offenders
Tell me, if I were to drop into the MSDN forums (which seems to be your primary haunt) as a...
March 4, 2009 at 8:31 am
mail2payan (3/4/2009)
Hope, I can make you understand where is my problem??
Not quite. What should happen when a row is inserted into MyTable? What should happen when that row is updated?
March 4, 2009 at 8:17 am
Is this SQL Express?
Have a look at this discussion:
March 4, 2009 at 7:50 am
Kit G (3/4/2009)
Looks like Mangal deleted some of his posts as they are only now recorded in the quotes other posters used.
I hate it when people do that.
March 4, 2009 at 7:42 am
Same as any complex code. Deconstruct (or build it) piece by piece.
Broken down for explanation only:
DECLARE @dt datetime
SET@dt = '2009/03/04'
DECLARE @TwoMonthsFromNow DATETIME
DECLARE @StartOfMonthAfterNext DATETIME
DECLARE @EndOfNextMonth DATETIME
SET @TwoMonthsFromNow = DATEADD(mm,2,@dt)
SET @StartOfMonthAfterNext...
March 4, 2009 at 7:36 am
There's not much written about it anywhere that I've found, (other than in BoL) and I've been told that it can change between versions.
If you want to control which is...
March 4, 2009 at 7:31 am
Viewing 15 posts - 40,606 through 40,620 (of 49,571 total)