Its baaaacccckk. Now it is taking about 3 minutes to run the query. I feel it will creep up to the 15 minute range as it did before. I guess...

Yes, absolutely identicle hardware including same dual CPU setup, same speed and configuration of drives in the 8 disk scsi array, ram, etc.

Thanks for the variations! I will have to remember the negative datediff usage.

-A

A couple of suggestions:

The simplest option might be to formulate a query that builds the HTML that you want to be the body, and then use the SQL mail agent...

It always annoys me when I see a newsgroup thread somewhere about a problem I am having, and the conversation stops before the problem is found or the resolution is...

Since you don't want to overwrite the pkey (presumably letting system generate it) you will probably need to explicitly name the columns to update. Something like...

UPDATE t2 SET (col1 =...

I haven't had a problem using the global variables with actual SQL statements. The stored procs are probably a better way to go anyhow.

-A

We still had 1 SQL 7 box laying around so I checked. I don't see a way to do this in 7 so perhaps it was a new feature in...

I guess that is true. What about this?

WHERE mydate < cast(cast(month(Getdate())as char) + '/01/' + cast(year(getdate())as char) AS SMALLDATETIME)

There might be a better way of doing this.

This is a simple question with a simple answer.

1) Open DTS job in design mode.

2) Package -> Properties -> Global Variables tab

3) Add your variable and a default value

4) Open...

It seems like I remember having this trouble quite a while ago but we are running standard edition now. It would be best to check the MS site for an...

Will this work?

WHERE MONTH(mydate) < MONTH(GETDATE())

Well, after 2 weeks of running on a new server with the same hardware (dual processors enabled) the performance problem has never returned. I still don't know what the problem...

Well, after 2 weeks of running on a new server with the same hardware (dual processors enabled) the performance problem has never returned. I still don't know what the problem...

Well, after 2 weeks of running on a new server with the same hardware (dual processors enabled) the performance problem has never returned. I still don't know what the problem...