That is not difficult. Declare a variable, say x, outside the loop. Then on each iteration add one to that variable i.e. x = x + 1. And you will get non random values. Is that what you want?
@@virtual_school no I am asking I have the data points but it is in very large number so it is quite impossible to insert one by one so how I can feed my data points(nonrandom data points) by using loop
@@julishaw516 if you have static data, you dont have to use a loop. You can either upload a file directly into your database table, or you can use insert command. You can use multiple insert commands together. i.e. insert into xyz values (1,2,3); insert into xyz values (4,5,6); and so on. And you can create these insert statements using some automatic formula. Like if you have data in excel, you can create a formula to generate, say one thousand of these insert commands, and then you can paste those in your sql querym and all one thousand rows will be entered at once.
SQL Server Reporting Services, Installing, Configuring, and Creating Reports, for Beginners : th-cam.com/video/o4-Fztiov1E/w-d-xo.html
Worked a treat, excellent, thanks!
Thanks. Glad you liked it.
here we are inserting random values. but i want to insert non random exact value of more than 1000 rows. i cant do it manually. how can i do that?
That is not difficult. Declare a variable, say x, outside the loop. Then on each iteration add one to that variable i.e. x = x + 1. And you will get non random values. Is that what you want?
@@virtual_school no I am asking I have the data points but it is in very large number so it is quite impossible to insert one by one so how I can feed my data points(nonrandom data points) by using loop
@@julishaw516 if you have static data, you dont have to use a loop. You can either upload a file directly into your database table, or you can use insert command. You can use multiple insert commands together. i.e. insert into xyz values (1,2,3); insert into xyz values (4,5,6); and so on. And you can create these insert statements using some automatic formula. Like if you have data in excel, you can create a formula to generate, say one thousand of these insert commands, and then you can paste those in your sql querym and all one thousand rows will be entered at once.