Thanks a lot .. It worked

Basically tblevents has a field name sstatus and I am capturing oldstatus and then in the update statement if the status changes to newstatus and then comparing them

USE [databasename]

GO

/******...

How do I do this? I want to update the status to newstatus and comapre oldstatus and newstatus for a particular eventid and keep rest of the values same as...

Will it be possible to capture instructor's email in the new temp table along with deleted status and inserted status so we know which instructor has got the new status?

Thanks,

Blyzzard

Thank You Lynn.

It worked.

How to script the job as drop create?

Your query is selecting all the students who have selected Math only but the Marker field is empty for all the returned students.

Thus I think that students who have selected...

Actually I need to select all the fields and rows for Math subject and craete a marker so that if any student has selected Science as well then I it...

Could you please explain?

Thanks,

Blyzzard

I was trying to troubleshoot and figured that when I create same stored procedure on a test server and then use it for the report dataset, it executes fine but...