Another alternative is to remove all the alerts from your jobs, then create a new job to run every 15 minutes to check for jobs that failed the last time...

Anand

Is there a question there?

Like I said, no cursor is necessary. Try it the way I suggested, or use the link that Dave posted, and get back to us...

Anand

No need to use a cursor. Create a Numbers (or Tally) table - search this site if you don't know what that is. Then join your table...

Joe

I really don't care that it doesn't port. This is a SQL Server forum and if the original poster had wanted something that works on Oracle as well, he...

UPDATE t2

SET column1 = t1.column1, column2 = t1.column2,...

FROM table1 t1 JOIN table2 t2

ON t1.ID = t2.ID

John

Use the appropriate function for the data type you have. Your code is doing a conversion and then applying a function - this will probably be a performance nightmare...

Shatrughna

Please can we see your SELECT and UPDATE queries? What does "500 something" mean?

It sounds as if you're doing SELECT * from a large table, and this is taking...

I see. This is why you should always provide table DDL as well as sample data. It also explains why your code didn't return an error. I...

You have to cast a date data type to a character data type before you can use SUBSTRING on it. I took the liberty of using DATEPART instead:

; WITH...

(1) It looks correct. But check it against the syntax in Books Online.

(2) Shrinking a file will not remove any data from it.

John

CREATE TABLE and INSERT statements, please - for each of the three tables. If you want people to help you, you need to make it easy for them.

Thanks

John

I think we've come to the point where we need some sample data. Please provide table DDL in the form of CREATE TABLE statements, data in the form of...

Whichever way you do it, this line:

and b.event_type = 'open'

needs to come out of the WHERE block and go into the join predicate. Otherwise, your left outer join...

Yes. First use ROW_NUMBER in a common table expression to get a row number for each of the top four rows in your table ordered by ColumnA. Then...

So just add a WHERE clause on the end of tertiusdp's code so that only the results for the user you want are returned.

John