troubleshooting Question

Export data to TXT file

Avatar of phman1275
phman1275 asked on
DatabasesC#
7 Comments1 Solution52 ViewsLast Modified:
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)

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?
ASKER CERTIFIED SOLUTION
gr8gonzo
Consultant

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
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.

-Mike Kapnisakis, Warner Bros