4 Replies Latest reply on Mar 17, 2014 12:08 AM by Christian Vinter

    Comparing tables

    Christian Vinter

      Hi,

       

      I cannot believe this has not been asked before, but on the other hand I cannot find it anywhere.

       

      I have to versions of the same table, which are extracts of different month's data. I would like to set up some analysis of what has changed between the two data sets. This could be things like number of customers in different segments, exposure in different segments (in both percent of total in that segment and in absolute numbers). Something like:

       

      Number of cust. in T1 split per segment; Number of cust. in T2 per segment; Change between those two numbers in units of the first number.

       

      The two tables have the same columns, but different number of rows. The tables are placed on Microsoft's SQL Server.

       

      Thanks in advance!