A client requested a SQL job that would run in the background of their system to retire Billing and Settlement rates within the TMWSuite rate tables. The job would retire rates after a dormant period of inactive use, ranging from a 6 to 12 month time frame. A SQL job was desired to automate the…
We recently ran into a challenge on a project for a current client, and found this solution that we would like to share. We feel it could be useful to others experiencing a similar concern. CHALLENGE We needed to create a SSRS Report that would export a fixed text file format for uploading to a…