Viewing 15 posts - 18,946 through 18,960 (of 26,490 total)
I'd use two separate queries in different stored procedures and use the stored procedure in your original post to determine which child procedure to call based on the value of...
September 1, 2009 at 11:26 am
sam.marsden (9/1/2009)
I have a field which is a datetime vaule and i would to show it ion a different format....
2009-09-01 00:00:00.000 is how it appears now
010909 is how...
September 1, 2009 at 10:18 am
drew.allen (9/1/2009)
September 1, 2009 at 10:16 am
What may help is dropping the indexes that may exist on the historical table prior to inserting the new data and then recreating the indexes after the insert.
September 1, 2009 at 10:08 am
Interesting. Looks like our PhD Candidate wanna be is here in the states now.
September 1, 2009 at 8:52 am
Martin Vrieze (9/1/2009)
A couple thoughts I had on why things are done in certain ways. ...
2. Before you ask questions or criticize somebody on their choice...
September 1, 2009 at 8:43 am
Much simplier:
declare @ThisDate datetime;
set @ThisDate = getdate();
select
getdate() as CurrentDateTime,
dateadd(mm, datediff(mm, 0, @ThisDate) + 1, 0) as BeginningOfNextMonth, -- Beginning of next month
...
September 1, 2009 at 6:28 am
This may work, but it isn't tested. there may also be a better way to write it as well.
UPDATE dbo.Orders SET
Rate = p.Rate
FROM
...
August 31, 2009 at 3:41 pm
And I have to agree with Jeff as well. Don't shrink the staging database, it just has to grow again.
August 31, 2009 at 3:28 pm
Jan Van der Eecken (8/31/2009)
August 31, 2009 at 3:17 pm
Jeff Moden (8/31/2009)
Bob Hovious (8/31/2009)
Is it just me, or has his grammar improved?
Heh... careful... there's two folks with the exact same handle on this forum. If he's not touting...
August 31, 2009 at 11:55 am
Bob Hovious (8/31/2009)
Is it just me, or has his grammar improved?
Yes. 😉
August 31, 2009 at 10:18 am
Bob Hovious (8/31/2009)
Give no quarter!! Take no prisoners!!
Give them a broadside and see if they've got the stomach for...
August 31, 2009 at 9:54 am
GilaMonster (8/31/2009)
Lynn Pettis (8/31/2009)
And he posts it more than once!!Forums glitching again. There's a whole bunch of repeated posts that I'm going through and redirecting.
Having seen a couple others just...
August 31, 2009 at 9:22 am
Viewing 15 posts - 18,946 through 18,960 (of 26,490 total)