troubleshooting Question

Export data to TXT file

Avatar of phman1275
phman1275 asked on
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)

   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?

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