Home Forums SQL Server 2008 T-SQL (SS2K8) query help RE: query help

  • December 12, 2017 at 5:49 am

    #1971722

    Thom A - Tuesday, December 12, 2017 5:21 AM

    etirem - Tuesday, December 12, 2017 5:13 AM

    yes and yes for above questions.

    It can't be both... If I have the delimited list 'E1, E3, E2', you're stating it must be supplied in the order of the list and in the order of the numeric part. E3 appears in the list prior to E2, but 2 is less than 3.

    Sorry for the confusion. Only the order of the list and it will be always 3 values for Code cols. 
    For each StudentID, StudentName, there are 3 cols with Code1,Code2 and Code3. The values may differ in these columns but it will be always 2 Commas seperated repectivel. For Ex: 'E1,E2,E3'           'R1,R2, '             'Y1,Y2,Y3'. Here for  'R1,R2, '  it will be R1 ..R2 ..BlankValue