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.
This is a SQL project without any websites or web skills required. It is expected that you should have experience with SQL Server and database development.
57 freelancers are bidding on average $413 for this job
Hello, I have more than 14 years experience in MS SQL. I am using 2012 version. I did the same projects. Extracting of the data can be manage by the MS SQL Server profiler. Regards.