Combination Numbers

• sqlfriends@sql.com

  SSCommitted

  Points: 1504

  More actions

  February 8, 2011 at 11:34 pm

  #244911

  Dear All;

  (For Ex)

  CourseNumbers

  00101, 02, 03,04,05,06,07,08,09,010

  00222, 23,25

  00305, 08

  00411,12,13,14

  00501,02,03,04

  Course To Check

  Course Nmbers

  001(001,002),(001,003),(001,004),(001,005)

  002(002,001),(002,003),(002,004),(002,005)

  003(003,001),(003,002),(003,004),(003,005)

  004(004,001),(004,002),(004,003),(004,005)

  005(005,001),(005,002),(005,003),(005,004)

  To Check the one Course to remaining course, suppose the numbers is exists the another course the course will split separate column , else it will append on the same column .

  Please any ony help me

  The Following Format of Output

  001005003

  002

  004

  Thanks & Regards;

  Faijur

• ColdCoffee

  SSC-Dedicated

  Points: 39972

  More actions

  February 8, 2011 at 11:48 pm

  #1284218

  Am totally confused on the requirement.. can you please elaborate on the requirement pls..