Dynamic query to create a temp table with X columns being length of a string / number. Then create ( dynamically) a multiple while loop for each column to insert a digit that hasn’t been used in previous columns. Iterate from 1-4 each loop. Simple.
it looked a good concept until i saw you hard coding ALL of the stages. not much use in the real, dynamic world. Despite a few ppl asking for the script, Yesit would be good to attach it to EVERY video you do
Sorry!! I do not agree. Why would you like to have a script? It's just a number as an input. The question was to first find out all the permutations with the required input number and then remove permutations where there are consecutive numbers.
Dynamic query to create a temp table with X columns being length of a string / number. Then create ( dynamically) a multiple while loop for each column to insert a digit that hasn’t been used in previous columns. Iterate from 1-4 each loop. Simple.
Nice video and concept sir.
Thanks 🙏
Please add create insert script
Script for?
@@datasculptor2895 insert data script
Script Please
Is script required?
@@datasculptor2895 Insert statements for them to try out.
it looked a good concept until i saw you hard coding ALL of the stages. not much use in the real, dynamic world. Despite a few ppl asking for the script, Yesit would be good to attach it to EVERY video you do
Sorry!! I do not agree. Why would you like to have a script? It's just a number as an input. The question was to first find out all the permutations with the required input number and then remove permutations where there are consecutive numbers.
@@datasculptor2895 Hey buddy, They are asking insert statements for them to try out. nevertheless you are doing good job. DML is what they asking for.