Linked Server (Build table for attendence from many databases)

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 [login to view URL] Union Select * from [login to view URL] I will write query in such pattern. This is my routine task as sql server dba. I will also optimize the process. Thanks

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 and Emergency Expert; with 6+ years of professional experience in 5 high performance OLTP (Online Transaction Processing) systems and 10+ freelancer projects. About SQL Server Performance: It's hard to make our server 100x faster - but it's really easy to make our database design and queries suddenly 100x more efficient. Fixing queries and tables and indexes is indeed hard work - but it's totally worth it. Warm regards, Kundan (Your remote consultant)

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 reply

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