update DY2020.dbo.property set mobilekey = 3977 where propertykey=15899
update DY2020.dbo.property set mobilekey = 4713 where propertykey=16635
update DY2019.dbo.property set mobilekey = 4472 where propertykey=16216
update DY2018.dbo.property set mobilekey = 4262 where propertykey=16001
update DY2018.dbo.property set mobilekey = 3217 where propertykey=14956
update DY2017.dbo.property set mobilekey = 2640 where propertykey=13386
update DY2017.dbo.property set mobilekey = 3331 where propertykey=14077
update DY2017.dbo.property set mobilekey = 2645 where propertykey=13391
update DY2017.dbo.property set mobilekey = 3982 where propertykey=14729
update DY2017.dbo.property set mobilekey = 4674 where propertykey=15420
update DY2017.dbo.property set mobilekey = 3375 where propertykey=14121
update DY2017.dbo.property set mobilekey = 4573 where propertykey=15319
update DY2017.dbo.property set mobilekey = 3545 where propertykey=14291
update DY2017.dbo.property set mobilekey = 2801 where propertykey=13547
update DY2016.dbo.property set mobilekey = 300 where propertykey=14234
update DY2016.dbo.property set mobilekey = 300 where propertykey=14236
update DY2015.dbo.property set mobilekey = 300 where propertykey=13726
update DY2015.dbo.property set mobilekey = 300 where propertykey=13728
update DY2015.dbo.property set mobilekey = 4608 where propertykey=15756
update DY2015.dbo.property set mobilekey = 4606 where propertykey=15758
update DY2014.dbo.property set mobilekey = 293 where propertykey=13689
update DY2014.dbo.property set mobilekey = 301 where propertykey=14116
update DY2014.dbo.property set mobilekey = 3772 where propertykey=14988
update DY2014.dbo.property set mobilekey = 3773 where propertykey=14999
update DY2014.dbo.property set mobilekey = 4307 where propertykey=15519
update DY2014.dbo.property set mobilekey = 3028 where propertykey=14240
update DY2014.dbo.property set mobilekey = 3681 where propertykey=14893
update DY2014.dbo.property set mobilekey = 3295 where propertykey=14507


update MM set mobilekey = 3977 FROM DY2020.DBO.M_MOBILE MM INNER JOIN DY2020.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 15899
update MM set mobilekey = 4713 FROM DY2020.DBO.M_MOBILE MM INNER JOIN DY2020.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 16635
update MM set mobilekey = 4472 FROM DY2019.DBO.M_MOBILE MM INNER JOIN DY2019.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 16216
update MM set mobilekey = 4262 FROM DY2018.DBO.M_MOBILE MM INNER JOIN DY2018.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 16001
update MM set mobilekey = 3217 FROM DY2018.DBO.M_MOBILE MM INNER JOIN DY2018.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 14956
update MM set mobilekey = 2640 FROM DY2017.DBO.M_MOBILE MM INNER JOIN DY2017.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 13386
update MM set mobilekey = 3331 FROM DY2017.DBO.M_MOBILE MM INNER JOIN DY2017.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 14077
update MM set mobilekey = 2645 FROM DY2017.DBO.M_MOBILE MM INNER JOIN DY2017.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 13391
update MM set mobilekey = 3982 FROM DY2017.DBO.M_MOBILE MM INNER JOIN DY2017.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 14729
update MM set mobilekey = 4674 FROM DY2017.DBO.M_MOBILE MM INNER JOIN DY2017.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 15420
update MM set mobilekey = 3375 FROM DY2017.DBO.M_MOBILE MM INNER JOIN DY2017.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 14121
update MM set mobilekey = 4573 FROM DY2017.DBO.M_MOBILE MM INNER JOIN DY2017.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 15319
update MM set mobilekey = 3545 FROM DY2017.DBO.M_MOBILE MM INNER JOIN DY2017.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 14291
update MM set mobilekey = 2801 FROM DY2017.DBO.M_MOBILE MM INNER JOIN DY2017.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 13547
update MM set mobilekey = 300 FROM DY2016.DBO.M_MOBILE MM INNER JOIN DY2016.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 14234
update MM set mobilekey = 300 FROM DY2016.DBO.M_MOBILE MM INNER JOIN DY2016.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 14236
update MM set mobilekey = 300 FROM DY2015.DBO.M_MOBILE MM INNER JOIN DY2015.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 13726
update MM set mobilekey = 300 FROM DY2015.DBO.M_MOBILE MM INNER JOIN DY2015.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 13728
update MM set mobilekey = 4608 FROM DY2015.DBO.M_MOBILE MM INNER JOIN DY2015.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 15756
update MM set mobilekey = 4606 FROM DY2015.DBO.M_MOBILE MM INNER JOIN DY2015.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 15758
update MM set mobilekey = 293 FROM DY2014.DBO.M_MOBILE MM INNER JOIN DY2014.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 13689
update MM set mobilekey = 301 FROM DY2014.DBO.M_MOBILE MM INNER JOIN DY2014.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 14116
update MM set mobilekey = 3772 FROM DY2014.DBO.M_MOBILE MM INNER JOIN DY2014.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 14988
update MM set mobilekey = 3773 FROM DY2014.DBO.M_MOBILE MM INNER JOIN DY2014.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 14999
update MM set mobilekey = 4307 FROM DY2014.DBO.M_MOBILE MM INNER JOIN DY2014.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 15519
update MM set mobilekey = 3028 FROM DY2014.DBO.M_MOBILE MM INNER JOIN DY2014.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 14240
update MM set mobilekey = 3681 FROM DY2014.DBO.M_MOBILE MM INNER JOIN DY2014.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 14893
update MM set mobilekey = 3295 FROM DY2014.DBO.M_MOBILE MM INNER JOIN DY2014.DBO.PROPERTY P ON P.MOBILEKEY=MM.MOBILEKEY WHERE P.PROPERTYKEY= 14507
