mptwoadmin
Programmer
Hi,
I have a question regarding duplicate data entries. I would like to zero out all duplicate entries of '62945' but machine2 on Nov 18 2009. Is this possible? And how would you go about this?
date_id machine1 machine2 machine3
Nov 18 2009 12:00AM 62945 62945 53214
Nov 19 2009 12:00AM 62945 62945 62945
Nov 20 2009 12:00AM 62945 62945 62945
Nov 21 2009 12:00AM 62945 62945 62945
Nov 22 2009 12:00AM 62945 62945 62945
Nov 23 2009 12:00AM 62945 62945 62945
Nov 24 2009 12:00AM 62945 62945 62945
Thank You
I have a question regarding duplicate data entries. I would like to zero out all duplicate entries of '62945' but machine2 on Nov 18 2009. Is this possible? And how would you go about this?
date_id machine1 machine2 machine3
Nov 18 2009 12:00AM 62945 62945 53214
Nov 19 2009 12:00AM 62945 62945 62945
Nov 20 2009 12:00AM 62945 62945 62945
Nov 21 2009 12:00AM 62945 62945 62945
Nov 22 2009 12:00AM 62945 62945 62945
Nov 23 2009 12:00AM 62945 62945 62945
Nov 24 2009 12:00AM 62945 62945 62945
Thank You