Hello everyone !
I have a task where I need to create a sample table which as 40 random rows in it from an existing tab and I have already this script using Sample() but sample doesn't return a fix value and I would like to know if it is possible to have it return only 40 values (for now it returns between 30 and 60 rows).
ID_APL as ID,
LB_APL as Name,
SQL SELECT *
LET vTotalRows = NoOfRows('App_Name');
LET vPercent = (100 * 40 / $(vTotalRows)) / 100 ;
Sample $(vPercent) LOAD * Resident App_Name;