The definition of the cursor is below and its based on my TBL_PC_AUDIT which has a number of fields

AUDIT_ID, SHUTDOWN_TIME, HIBERNATE_TIME, SLEEP_TIME, STARTUP_TIME, STATUS, PC_PROFILE_ID

2 04/11/2009 14:52:17NULL NULL 04/11/2009 16:02:57...

Sorry about that, this is my code so far, i've created my temp table. In relation to @SHUTDOWN_TIME, @STARTUP_TIME, @HIBERNATE_TIME, @SLEEP_TIME they are just a time stamp so...

Thanks for the reply, Ya maybe your right I should not drop the table, bit of a newbie so just trying to get my head around this, could take...

Thanks for getting back to me, ya sorry your right there shouldn't be an "UPDATE" there but i wasn't too sure on how to write this line of code correctly...

Thanks very much works now, its showing output its not updating the table as it should be but Im sure I can work it out, thanks again

Thanks for the reply, Im now getting an error "invalid Column name 'START_UP AND SHUTDOWN'", apologizes about the persist posting but Im just trying to get my head around this,...

Thanks for the post, Im after changing around my code and Im still getting a small error "incorrect syntax near "END"', bit of newbie to this 🙁

ALTER PROCEDURE dbo.UPDATE_TBL_PC_ON

(

@STARTUP_TIME...