Scan table for records > 0

I have an Attendance Grid called tblAttendanceGrid.  I have the following columns

Month
Total
DataPresent

How can I write an SQL statement that scans my table and checks to see if anyone has a Total > 0 each month, it will put a "1" in the DataPresent column for that specific record.
al4629740Asked:
Who is Participating?
 
Paul MacDonaldConnect With a Mentor Director, Information SystemsCommented:
Something like...

UPDATE MyTable SET DataPresent = 1 WHERE (Total > 0)
0
 
Paul MacDonaldDirector, Information SystemsCommented:
Something like...

SELECT Month, Total, CASE WHEN TOTAL > 0 THEN 1 END AS DataPresent FROM MyTable
0
 
al4629740Author Commented:
Yes, however I actually want to put a value of "1" into the actual table
0
All Courses

From novice to tech pro — start learning today.