Windows 7 64bit 
Access 2013 64bit
Hello, I have around 1000 values that I'd like to execute against my SQL code and store the resulting data in a table for further analysis.
Here is an example of my SQL code:
INSERT INTO Summary_Final ( PD_Deadline, stock, sell, [count] )
SELECT x.PD_Deadline, x.stock, x.sell, x.[count]
FROM (
SELECT
-0.15 as PD_Deadline,
a.stock, a.sell, Count(*) AS [count]
FROM (
SELECT Data.Stock, Data.Date, Data.Buy_price*(1+(0.05)) AS Sell
FROM Data ) AS a
WHERE a.[Flag]="Y"
GROUP BY a.stock, a.sell
) as x;
The values represented by -0.15 and 0.05 in the code serve as adjustable parameters. If I were to manually execute the code, I'd modify these parameters individually for approximately 1000 instances and run the code for each specific set of values.It would be more efficient to store these parameters in a table, transform the existing code into a function, and then invoke the function within a loop.
As a new bee, I would appreciate detailed guidance on this matter. Thank you in advance.
Reply With Quote
