asked
Store procedure
hi i have a table Name var value1 value2 Abc aa 123 10 Bcd bb 32 21 Fgr cc 12 34 Etc ….. I need to (create new/update) following result table. For every aa I should have three entries ie aa, ab and ac. Similarly for every bb I should have 2 entries like bb and ba and cc should have four entries like cc,ca,cb and cd and so on. And these extra entries will remain constant like for aa resulting table will have 3, for bb it will have 2 and for cc it will be 4 etc Rest of the values in table will not change so my resulting table becomes Name var value1 value2 Abc aa 123 10 Abc ab 123 10 Abc ac 123 10 Bcd bb 32 21 Bcd ba 32 21 Fgr cc 12 34 Fgr ca 12 34 Fgr cb 12 34 Fgr cd 12 34 I would be really appreciate if some one could tell me about how should i approach this ... thank you in advance ....
You could do a join between the two tables to get the results, then you can put it in another table or create a view as needed. It would look something like: select a.name, b.actual as var, c.value1, c.value2 from tblTheFirst a join tblTheSecond b on a.var = b.actual
10 People are following this question.
