Hi! I need to write a console app program or stored procedure to grab the office hours from the database table and export to TXT file. I am not so sure which one is the best, C# or stored procedure.
Here are the requirements:
1. Right now the database table has Mon - Sun office hour columns.
Ex. MondayOpening, MondayClosing, TuesdayOpening, TuesClosing..........Sunday
2. Will add 5 new fields to the TXT file
Ex. Operation1, Operation2, Operation3, Operation4, Operation5 (All are varchar data type)
The output should like this:
Ex. If Mon, Tue, Wed office hours are the same then put "Monday - Wednesday: 8:00 am to 8:00 pm
if Mon, Wed, Fri are the same then put "Monday, Wednesday, Friday:...." t Operation 1.....etc
Do you have any suggestion?