troubleshooting Question
Export data to TXT file
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..........Sunda
2. Will add 5 new fields to the TXT file
Ex. Operation1, Operation2, Operation3, Operation4, Operation5 (All are varchar data type)
Output:
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
to Operation1.
if Mon, Wed, Fri are the same then put "Monday, Wednesday, Friday:...." t Operation 1.....etc
Do you have any suggestion?
Here are the requirements:
1. Right now the database table has Mon - Sun office hour columns.
Ex. MondayOpening, MondayClosing, TuesdayOpening, TuesClosing..........Sunda
2. Will add 5 new fields to the TXT file
Ex. Operation1, Operation2, Operation3, Operation4, Operation5 (All are varchar data type)
Output:
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
to Operation1.
if Mon, Wed, Fri are the same then put "Monday, Wednesday, Friday:...." t Operation 1.....etc
Do you have any suggestion?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 7 Comments.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.