We use a commercial product to manage properties and currently have to manually extract information on a monthly basis to do a mail out. This is extremely time consuming so are looking to use a query to do this for us.
The back-end to the product is a SQL Server database. As it is a commercial product we do not have access to the schema nor can it be modified. It is anticipated the query will be initially run in Microsoft Query or Excel but a more elegant solution maybe produced later.
You will need to understand the schema of the database and write to a query to extract the information we require. The deliverable is expected to be a simple SELECT statement.
For this task, you will be given a login to our network with Remote Desktop Gateway and access to a workstation running Windows 8.1 and access to SQL Server Management Studio 2012 with rights over a database on a remote SQL Server.
59 freelancers are bidding on average $418 for this job
I am a database developer in the Philadelphia, PA suburbs with over 20 years of experience. Do you have a layout of what information you want to extract from this database?
I work with SQL 2012 on a daily basis and have written MANY SQL statements. I am confident I can write your needed SQL SELECT Statement in one day to your complete satisfaction.
I can follow below steps for the job done... 1- Proper access to the remote DB, 2- Understand the DB schema, 3- Simple query for the DB, 4- Query for the exact result.