February 1, 2013 at 7:52 am
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
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
T-SQL
February 5, 2013 at 9:47 am
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