Microsoft SQL Server small code of dynamic sql , loop and scheduler

₹600-1500 INR

Completed

Posted

over 1 year ago

₹600-1500 INR

Paid on delivery

Need to read distinct IDs from one table and iterate over Ids through a loop and insert data into another table using the IDs . Need to use dynamic SQL while inserting data into second table. Then need to schedule this code to run every minute. Pseudo code : Select distinct ID from table1 For each ID insert into table2_'ID' values ID Then need to create a scheduler which runs this code every minute. Need a code which represents this code and then will need the same to enhanced with full tables.

Microsoft SQL Server

SQL

Project ID: 35429686

About the project

2 proposals

Remote project

Active 1 yr ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@teekayzitsi

Hi In my current Profession -I perfom the DBA and Developer duties in high traffic OLTP environment -Data Mining ,Data Science,Machine Learning -Python programing -data analysis using python and R -Data Scraping using python, -Database development in (Mysql,Postgres,SQlite and SQl) -Automation -Data warehousing on sql,mysql and postgres database (Star Schemas) and Business Intelligence systems development -Data extractions using Talend Open Studio,Python -Data Intergration using WSO2 ,Talend Open Studio -I have rich experienced in Database Administration, Excel -Data visualisation using Power BI,BIRT ,Jasper ,excel and Tableau -SQL server installations I am looking for the clear final requirements docs of your project so that I can start working immediately. If you need to discuss with me for any kind of suggestions or information, please knock me anytime. I am looking forward to hearing from you I can assure that if you work with me once, you will always work with me on these kind of projects and I can deliver quality and superior work at a price we are both comfortable with and within the agreed timeline. Kindly consider my bid.I will do whatever it takes to complete this project and earn a 5 star rating from you as well Kind Regards Takudzwa

₹1,050 INR in 2 days

4.9

(25 reviews)

4.5

2 freelancers are bidding on average ₹1,050 INR for this job

@brunetcurs

Hello, I am so excited to see that you have a nice opportunity for the right web developer. This is Curtis Troy and I've working as a web developer for around 8 years and had a chance to work for several projects. I have specially rich experiences in Javascript framework such as React, Vue, Angular, EmberJS. I can implement your project with a soft budget within a short time. I can start your project instantly or work full time for you. Thank you.

₹1,050 INR in 1 day