I create a tblTemp table based on crosstab (from tblDelivery) . When I change some data on this tmpTable, how to move data from this tblTemp to original table tblDelivery.
Since tblTemp was created from a crosstab it will not be one for one with tblDelivery. How will you determine which rows in tblDelivery will be updated?
tblDelivery have only one value for row. I mean Customer in some date have only one value for some products. crosstab didn't do any summarize, only present data in excel like form
