hi i have a table
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
I would be really appreciate if some one could tell me about how should i approach this ... thank you in advance ....
asked Sep 24, 2012 at 07:01 PM in Default
The question has been closed Oct 10, 2012 at 02:04 PM by ThomasRushton for the following reason:
Duplicate Question - http://ask.sqlservercentral.com/questions/93710/store-procedure-1.html
This as been answered here: http://ask.sqlservercentral.com/questions/93710/store-procedure-1.html
answered Oct 10, 2012 at 01:37 PM