Permutations and combinations of multiple return codes

sp recursive , vb6 , sql India
  • 10 years ago
    hi guys, can anyone help me with this, i have 6 columns with the "return codes" for SEO in each column i want to do all possible permutations and combinations of each return code in one with other return codes in other column's and want to pass it in a Store procedure in the recursive function Any help would be greatful....... Eg:-Return code1 -'IEK2EK53' rETURN CODE2-'2EKR531' Return code3-'3M4RT15U' etc... so it has to be 1EK2EK53',2EKR531',3M4RT15U' 'IEK2EK53',2EKR531' 'IEK2EK53','3M4RT15U' 2EKR531','3M4RT15U'
  • 10 years ago
    hi guys, can anyone help me with this, i have 6 columns with the "return codes" for SEO in each column i want to do all possible permutations and combinations of each return code in one with other return codes in other column's and want to pass it in a Store procedure in the recursive function Any help would be greatful....... Eg:-Return code1 -'IEK2EK53' rETURN CODE2-'2EKR531' Return code3-'3M4RT15U' etc... so it has to be 1EK2EK53',2EKR531',3M4RT15U' 'IEK2EK53',2EKR531' 'IEK2EK53','3M4RT15U' 2EKR531','3M4RT15U'

Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away.” - Antoine de Saint Exupéry