Linked Server (Build table for attendence from many databases)
Бюджет $10-30 USD
- Freelancer
- Работа
- Управление базами данных
- Linked Server (Build table for attendence from many databases)
Job Description:
I have 4 (Linked Server databases) in 3 servers I need to create table that merge all attendnce time and information to one table from all databases. There is a picture.
Поручен:
Hi, I can create linked server sql query to merge data from all tables in a single table and schedule job in sql agent to automate that process into hourly,daily etc basis. Insert into main_table Select * from linkedse Больше
5 фрилансеров(-а) готовы выполнить эту работу в среднем за $30
HI I am experienced in MySQL Database Administration SSIS (SQL Server Integration Services) etc I can start right now but i have few doubts and questions lets have a quick chat and get it started waiting for your repl Больше
Hi there - Would be happy to help you build this out. I can provide the logic and a mapping diagram of the data and tables along with the underlying sql code for future reference.
I have a good experience in creating multi dimensional systems using SQL. I have over 8 yrs of experience in Datawarehouse designing such solutions