Creating a default value for a rich text box

If you save to the database a record with the timestamp of 2000-09-20 06:00:00.000 for that specific InputID, it will populate that rich text box with that value.

Here’s an example.

INSERT INTO tblInput_Data8 (dDate, TemplateID, InputID, DataFormattedText, UserID) VALUES (N'2000-09-20 06:00:00.000', 1, 22, N' <h2>Shift Notes</h2> <p>Operator: </p> <p>Production Tech: </p> <br/> <h3>Process Changes</h3> <table style="border-collapse: collapse; border: 1px solid black; width: 50%;"> <tr style="background-color: #f0f0f0;"> <th style="border: 1px solid black; padding: 8px; text-align: left;">Time</th> <th style="border: 1px solid black; padding: 8px; text-align: left;">Separator Speed</th> <th style="border: 1px solid black; padding: 8px; text-align: left;">Separator Change</th> <th style="border: 1px solid black; padding: 8px; text-align: left;">Feed Rate</th> <th style="border: 1px solid black; padding: 8px; text-align: left;">Feed Change</th> </tr> <tr style="background-color: white;"> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> </tr> <tr style="background-color: #f0f0f0;"> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> </tr> <tr style="background-color: white;"> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> </tr> <tr style="background-color: #f0f0f0;"> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> </tr> <tr style="background-color: white;"> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> </tr> <tr style="background-color: #f0f0f0;"> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> <td style="border: 1px solid black; padding: 15px; text-align: left;"></td> </tr> </table> <br/> <p>00:00 | Plant is running both polys.</p>', -1);