I have to read m by n matrix and update each row column?

I have to read m by n matrix and update each row column? Which loop should I refer?

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey ♦♦ commented · Feb 19, 2013 at 07:42 PM

Can you edit the question and put T-SQL in that defines the tables. Since this sounds like homework, can you also show what you've tried? In general, most of us won't just do the homework for you (after all, we don't get the grade), but we'll help out. If you show what you tried that didn't work, we can set you right.

3 ·

JohnM commented · Feb 19, 2013 at 05:45 PM

Um, forgive me, but can you clarify a little? Do you have any DDL statements that you could provide and maybe some sample data? This would help to let us know exactly what you are attempting to do. Also, if you have any code that you are currently working with, please post that as well.

1 ·

pratappatil commented · Feb 19, 2013 at 05:54 PM

Thanks for quick reply. Table 1 have all data of information Now Table 2 looks like below. Now check for Student1 and 1 Student1 and 2 .... Student1 till 6 same for all and update the record. columns are headers column1 column2 column3 column4 column5 column6 column7 row1 row2 row3 row4 row5 row6 .. do you need any more details..

0 ·