DECLARE @length int          --长度
            DECLARE @next int            --标量
            DECLARE @did int             --地区id
            DECLARE @sId1 int
            
            SET @stId=@@IDENTITY
            SET @next=0  
            SELECT @length=COUNT(*) FROM Subject
            WHILE(@next<@length)
            BEGIN
                
                SELECT TOP 1 @did=ccId FROM CityCountry 
                WHERE ccId NOT IN (SELECT TOP @next ccId FROM CityCountry)
                INSERT INTO IP_District_Sub_Relation(dId,sId,usrCustomID,usrState,usrRebate)
                VALUES(@dId,@sId1,0,0,0)
 
                SET @next=@next+1
            END