I think it's time for trip to the desert. Anyone care to join me? I'll put the hippo on a leash. 😛

arun.prakash (3/9/2010)

---

I am only interested in 2 columns here :

_Addwhen - format is 20100303 9:41:3000

Normalized_Add_When - format should be format is 20100303 9:45 (after I run my stored procedure)

The other...

Well, your insert statement isn't working on my server.

Also, what column should be updated and what should it look like when completed?

Did you test the code you posted on your system. Things don't look right once I reformat the code.

arun.prakash (3/9/2010)

---

Thanks Lynn,your code works perfectly but how do I use it in my current code:

here is my set statement :

declare @ sql nvarchar(500)

set @sql='update XXNkk_Fact_PnLSummary1 set [' + @colname...

GilaMonster (3/9/2010)

---

Yes. Say there's a single drive failure, or database corruption, or someone stops SQL and deletes one of the files belonging to a system DB. Restoring from backup is...

Does the following code help you?

declare @TestTime datetime;

set @TestTime = convert(datetime, '0:14:00', 108);

select @TestTime, dateadd(ss,((datediff(ss, dateadd(dd, datediff(dd, 0, @TestTime), 0), @TestTime) + 450) / 900) * 900, dateadd(dd,datediff(dd, 0, @TestTime),...

Could you please define your rounding rulles? When to round up and when to round down.

Can't answer your question about sp_send_cdosysmail, but I would suggest looking at Database Mail.

I'd need to review the code again to be sure, but if the query is returning the appropriate data, then you should have it right.

Simple answer, yes. The only system database you can't backup is tempdb, which makes sense as it is recreated every time you restart SQL Server.

As to frequency, that would...

sturner (3/9/2010)

---

Not...

lmu92 (3/9/2010)

---

Lynn Pettis (3/9/2010)

---

I think you want a RIGHT OUTER JOIN the way the query is...

Can you tell us the versions of both the server and SQL? Is one 64-bit and the other 32-bit?