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.

Навыки: Управление базами данных, SSIS (SQL Server Integration Services), SQL, MySQL

О клиенте:
( 1 отзыв ) Jeddah, Saudi Arabia

ID проекта: #29513669



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 Больше

$20 USD за 1 день
(9 отзывов(-а))

5 фрилансеров(-а) готовы выполнить эту работу в среднем за $30


Namaste! Are you looking for a SQL Server Expert for your project? I would like to know more about the project so that I can identify how my skill-set will work best for you. About me: I'm SQL Server's Performance a Больше

$60 USD за 1 день
(20 отзывов(-а))

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 Больше

$20 USD за 7 дней(-я)
(0 отзывов(-а))

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.

$20 USD за 2 дней(-я)
(0 отзывов(-а))

I have a good experience in creating multi dimensional systems using SQL. I have over 8 yrs of experience in Datawarehouse designing such solutions

$30 USD за 7 дней(-я)
(0 отзывов(-а))