Post reply

Converting Mstrix into table

  • February 1, 2013 at 7:52 am

    #273659

    Matrix

    B1_LL to B1_UL is Range of score

    -------

    TestSubGradeB1_LLB1_ULB2_LLB2_UL

    TestName-Math4240335336354

    TestName-Math5240357358374

    TestName-Math6361362378379

    TestName-Read3240341342364

    TestName-Read8240372373389

    another Matrix is Score

    Current Year

    B1B2B3

    B191113

    B281012

    B37911

    First i need to create table out of first matrix but the condition is

    if the student is in range of 240-335(B1_LL to B1_UL ) then he should assign Score 9 from another Matrix

    Please help me

  • February 5, 2013 at 7:09 am

    #1584366

    Is this an SSIS question or a T-SQL question?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • February 5, 2013 at 9:28 am

    #1584475

    T-SQL

  • February 5, 2013 at 9:47 am

    #1584489

    OK, good. You posted in an SSIS forum but that's fine, now we know what you need.

    I am happy to help but it's a little hard to determine from your original post what you're after because of the formatting. Can you please provide DDL to create your test table (e.g. a CREATE TABLE statement), DML to create test data (e.g. INSERT statements), your expected results based on that test data and the queries you have tried so far.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply