Any chance you could post your run book code too?  I have been trying to set up our retention policy and this sounds like a perfect fit.

Guess I am going to necro this post but did you ever find a solution to this?  I just started having this issue with outlook.

This is really cool and I can't wait to play around with this for different reporting needs. However, I attempted to run this and received this error:

Failed to initialize...

Try putting the path in double quotes:

del "D:\Program File\backup\FileA.bak"

Wayne,

Thanks for pointing out the triangular join I had going on. I never see them until someone points them out. I can definitely see the benefits you show...

I haven't checked performance on this but it should work:

CREATE TABLE #temp

(

faultID INT,

storeID VARCHAR(6),

calloutDate DATETIME

)

INSERT INTO #temp

SELECT 627917, '014222', '04/26/10'

UNION ALL

SELECT 641874, '014222','06/28/10'

UNION ALL

SELECT 1000278, '014222', '06/28/10 16:35'

UNION ALL

SELECT 1000307,...

It looks like this is part of a template. In SSMS if you hit CTRL+ALT+T it will display the templates. Expand the index section and double click on...

Don't insert values but use a select statement:

Untested but this should work:

INSERT INTO database2..table1 (Date, Emails1, Emails2, Emails3)

SELECT GETDATE()-1,

(SELECT count(*) FROM database1..table1 WITH (NOLOCK) WHERE datediff( d,INSERT_DATE,getdate()) = 1),

(SELECT...

The depends on what you mean by the "first" record. I have ordered by the total column but if that isn't what you need then you can change it.

create...

Yeah, the update statement above won't work and would actually change the addresses you just gave to be 1105 and 2450 respectively. If you are sure those are the...

The only way to guarantee the order is by using an order by clause. That might have something to do with your current problem. If you would post...

I would try this on a copy of your table first as I haven't tested this fully with all variations of addresses but couldn't you just update your table in...

This solution assumes that the first "word" (the left characters up to the first space in the address) do not repeat in the actual address. See if this helps.

CREATE...

Try this:

SELECT DATEPART(hh,GETDATE())

The normal syntax would be: [linkedserver].[database].[schema].

However, I don't have an oracle instance to test this with and since the linked server is probably pointing directly at the database I...