Permutations and combinations of multiple return codes

sp recursive , vb6 , sql India
  • 8 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'
  • 8 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.

“Some people, when confronted with a problem, think "I know, I’ll use regular expressions." Now they have two problems.” - Jamie Zawinski