It's sometimes difficult getting the Manager to pay for training....especially when based on a client site.

Every individuals career lenght and training path is essentially linked to the duration of the...

glad to be of some help.

Try....

Select * from dbo.DW_T_EC_JOB_TEMP t

where

t.EC_STEP_ID not in

(select j.EC_STEP_ID from DW_T_EC_JOB j

INNER JOIN DW_T_EC_JOB_TEMP t

ON

j.EC_STEP_ID = t.EC_STEP_ID)

--instead of--

--where (dbo.DW_T_EC_JOB.EC_STEP_ID = dbo.DW_T_EC_JOB_TEMP.EC_STEP_ID))

This is my attempt to assist you 😀

DECLARE

@int date,

@idate datetime

SET @int = (SELECT CONVERT(date,getdate()))

SET @iDate = (SELECT CONVERT(datetime, @int))

SELECT @int AS Initial_Conversion, @idate AS Result

--or try CAST & convert

SELECT...

Now that you are on 2k8, use the excellent** new Activity Monitor to see which processes are taking long AND why?

check your SQL logs for any errors or infor messages...

run it 5 times each, and see if there is really a one second difference...each time..

Call me a bit too serious, but I wouldnt take my eyes off the screen if I were you.

The mere fact that you "expect" something to fail, says a lot.

Rather...

I wouldnt say YES, or NO...but....

Depends on youre host (let's say ESX) you will be sharing resources with other...

NP, glad it helped.

I'm also a bit confused Paul, just took a shot and hoped he meant, SQL notifications, to an outlook/exhange mailbox.

If not: this question doesnt make...

I dont specifically for success/failure, but a log is kept.

There is a History tab on each Operator in SSMS 2005, which indicates most recent notification attempts.

select @@version

youre first post

youre second post

So how can i get this...

My first question is: Why are you using date as string/varchar?

SELECT LEN('HOW LONG IS THIS DATA?')

RESULT = 22...

what you looking for?