Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)
Paste
Pasted as SQL by Tokter ( 14 years ago )
update PersPropPools set TTVPercent=20 where AssessmentYear=2011 and FormTypeID like 'ERA%' and LineKey='Line17G' and TTVPercent<>20 and PersPropID=@PersPropID;
update PersPropPools set TTVPercent=15 where AssessmentYear=2011 and FormTypeID like 'ERA%' and LineKey='Line26D' and TTVPercent<>15 and PersPropID=@PersPropID;
update PersPropPools set TTVPercent=12 where AssessmentYear=2011 and FormTypeID like 'ERA%' and LineKey='Line38' and TTVPercent<>12 and PersPropID=@PersPropID;
update PersPropPools set TTVPercent=21 where AssessmentYear=2011 and FormTypeID like 'ERA%' and LineKey='Line51' and TTVPercent<>21 and PersPropID=@PersPropID;
update PersPropPools set TTVPercent=15 where AssessmentYear=2011 and FormTypeID like 'ERA%' and LineKey='Line11' and TTVPercent<>15 and PersPropID=@PersPropID;
update PersPropPools set TTVPercent=3 where AssessmentYear=2011 and FormTypeID like 'ERA%' and LineKey='LineS11' and TTVPercent<>3 and PersPropID=@PersPropID;
Revise this Paste