Try this udf.

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

sam.marsden (9/1/2009)

---

Hi again,

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

drew.allen (9/1/2009)

---

You DO NOT want to do a CROSS JOIN here. The problem with your original query is that a LEFT outer join will return all records from the...

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.

Interesting. Looks like our PhD Candidate wanna be is here in the states now.

Martin Vrieze (9/1/2009)

---

Words of wisdom Steve.

A couple thoughts I had on why things are done in certain ways. ...

2. Before you ask questions or criticize somebody on their choice...

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

...

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

...

And I have to agree with Jeff as well. Don't shrink the staging database, it just has to grow again.

Jan Van der Eecken (8/31/2009)

---

Forgive the topic jump, but I'm really pissed off right now, not with you guys, but with the way MS forces you to accept updates when...

Jeff Moden (8/31/2009)

---

Heh... careful... there's two folks with the exact same handle on this forum. If he's not touting...

Yes. 😉

Bob Hovious (8/31/2009)

---

Don't do it Lynn!!

Give no quarter!! Take no prisoners!!

Give them a broadside and see if they've got the stomach for...

Having seen a couple others just...