Microsoft SQL Server small code of dynamic sql , loop and scheduler
Budget: ₹600 – ₹1,500 INR
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.
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.