• After taking Jeff's advice...

    maybe this works?

    SELECT Country

    , AccountNum

    , PolicyNum As CurrentPolicy

    , LAG(PolicyNum,1) OVER (PARTITION BY Country, AccountNum ORDER BY PolicyEffDt) AS PrevPolicy

    FROM @PolicyRelationship

    ORDER BY Country

    ,AccountNum;