SELECT TOP 10 * FROM dbo.YB_UserResultExt

INSERT INTO dbo.YB_UserResultExt
(
    Id,
    FamilyId,
    UserId,
    Height,
    Weight,
    Sex,
    Birthday,
    Bmi,
    BmiLevel,
    IsGroup,
    CreateTime,
    IsDeleted,
    TenantId
)
SELECT  a.id,b.FamilyId,b.UserId,a.Height,a.Weight,a.Sex,a.Age,a.bmi,'',b.IsGroup,b.CreateTime,b.IsDeleted,b.TenantId FROM dbo.YB_MeasureResult a 
LEFT JOIN dbo.YB_UserResult b
ON a.id=b.Id
WHERE a.WeightUnit=1

INSERT INTO dbo.YB_UserResultExt
(
    Id,
    FamilyId,
    UserId,
    Height,
    Weight,
    Sex,
    Birthday,
    Bmi,
    BmiLevel,
    IsGroup,
    CreateTime,
    IsDeleted,
    TenantId
)
SELECT  a.id,b.FamilyId,b.UserId,a.Height,a.Weight/2.0,a.Sex,a.Age,a.bmi,'',b.IsGroup,b.CreateTime,b.IsDeleted,b.TenantId FROM dbo.YB_MeasureResult a 
LEFT JOIN dbo.YB_UserResult b
ON a.id=b.Id
WHERE a.WeightUnit=2

INSERT INTO dbo.YB_UserResultExt
(
    Id,
    FamilyId,
    UserId,
    Height,
    Weight,
    Sex,
    Birthday,
    Bmi,
    BmiLevel,
    IsGroup,
    CreateTime,
    IsDeleted,
    TenantId
)
SELECT  a.id,b.FamilyId,b.UserId,a.Height,a.Weight/1000.0,a.Sex,a.Age,a.bmi,'',b.IsGroup,b.CreateTime,b.IsDeleted,b.TenantId FROM dbo.YB_MeasureResult a 
LEFT JOIN dbo.YB_UserResult b
ON a.id=b.Id
WHERE a.WeightUnit=3

INSERT INTO dbo.YB_UserResultExt
(
    Id,
    FamilyId,
    UserId,
    Height,
    Weight,
    Sex,
    Birthday,
    Bmi,
    BmiLevel,
    IsGroup,
    CreateTime,
    IsDeleted,
    TenantId
)
SELECT  a.id,b.FamilyId,b.UserId,a.Height,a.Weight*0.4536,a.Sex,a.Age,a.bmi,'',b.IsGroup,b.CreateTime,b.IsDeleted,b.TenantId FROM dbo.YB_MeasureResult a 
LEFT JOIN dbo.YB_UserResult b
ON a.id=b.Id
WHERE a.WeightUnit=4

INSERT INTO dbo.YB_UserResultExt
(
    Id,
    FamilyId,
    UserId,
    Height,
    Weight,
    Sex,
    Birthday,
    Bmi,
    BmiLevel,
    IsGroup,
    CreateTime,
    IsDeleted,
    TenantId
)
SELECT  a.id,b.FamilyId,b.UserId,a.Height,a.Weight*6.35,a.Sex,a.Age,a.bmi,'',b.IsGroup,b.CreateTime,b.IsDeleted,b.TenantId FROM dbo.YB_MeasureResult a 
LEFT JOIN dbo.YB_UserResult b
ON a.id=b.Id
WHERE a.WeightUnit=5

--¸üÐÂbmilevel
UPDATE dbo.YB_UserResultExt SET BmiLevel='1' WHERE Bmi<18.5 AND Bmi>0
UPDATE dbo.YB_UserResultExt SET BmiLevel='2' WHERE Bmi<25 AND Bmi>=18.5
UPDATE dbo.YB_UserResultExt SET BmiLevel='3' WHERE Bmi<30 AND Bmi>=25
UPDATE dbo.YB_UserResultExt SET BmiLevel='4' WHERE Bmi<=50 AND Bmi>=30
UPDATE dbo.YB_UserResultExt SET BmiLevel='0' WHERE Bmi< 0 OR Bmi>50