Resetting a field to a certain value in SQL Server 2005

[alan6895]

Hi all.
I'm making an app that will record a daily count of song plays. Each night at midnight, I've made a SQL Server 2005 job that runs. This job needs to reset all values in the "PlaysToday" column to 0. How can I do this with a SQL script that goes in the job editor? Thanks!

 

[ArtieChoke]

Add a transact sql job step with an update statement:

update <table name>
set PlaysToday = 0

"I think we're all Bozos on this bus!" - Firesign Theatre

 

[alan6895]

Thanks ArtieChoke. I've put the T-SQL statement into the job and it parsed fine. Once the DB actually starts recording data, I'll make sure it works. Thanks again!