Looking at your code, this:

RIGHT OUTER JOIN dbo.EventDescription ED ON DEP.EventID = ED.EventID

should probably be this:

LEFT OUTER JOIN dbo.EventDescription ED ON DEP.EventID = ED.EventID

As this:

dbo.DefendantEventPros DEP is on the...

Agree, why would you do that on a production server?

Sure,...

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