I have a one table with following data
I want to convert it into this format in another table like this
I am trying using Execute SQL , Sample file is attached .
Any help will be appreciated ...
Execute SQL in Versions table is returning '?'
The result is grouped by Section,Article, and Item, but ItemID are differenct in same Item. Did you make wrong example?
And, Stage shouldn't be in result, is it? Since 3 stages make one record in result, that include all 3 stages. If you need Stage in result, which should be get into result? Are there always 3 stages, and get "One" in result?
Sorry If I am not clear ... Please look at this modified sample file . I just want all three stages in one record for earch item in Stages Table
ItemIDs are just primary keys in each table ... they are not much relevant in think . The z_Reference identifies the record
Finally Working !
Retrieving data ...