Store procedure

Question

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 ....

Answer 1

0

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

answered Sep 24 '12 at 08:48 PM

TimothyAWiseman
14.4k ● 17 ● 21 ● 29

Beat me to it. ;-)

Sep 24 '12 at 08:54 PM JohnM

I looked after he answered your questions ;-)

Sep 24 '12 at 09:34 PM TimothyAWiseman

@timothy n @johnM

it worked .... thank you guys for the help ...

Sep 24 '12 at 09:37 PM abhi2702

(comments are locked)

Store procedure

Follow this question

Related Questions