Print 'Doing pre run Checks to ensure script not already run'; Select * from Script_History where Script_Name='LockDuplicateUsers21Dec2023'; if @@ROWCOUNT!=0 BEGIN RAISERROR('THIS SCRIPT HAS ALREADY BEEN RUN ON THIS SERVER, CANNOT CONTINUE, PLEASE CONTACT DEV',11,1); RETURN; END GO declare @StoreId int set @StoreId = (Select default_value from system_default where default_name='main_store_id') update [system_user] set Locked = 1 where System_User_ID =209 and @StoreId =281; update [system_user] set Locked = 1 where System_User_ID =196 and @StoreId =281; update [system_user] set Locked = 1 where System_User_ID =158 and @StoreId =281; update [system_user] set Locked = 1 where System_User_ID =167 and @StoreId =281; update [system_user] set Locked = 1 where System_User_ID =162 and @StoreId =281; update [system_user] set Locked = 1 where System_User_ID =30233 and @StoreId =281; update [system_user] set Locked = 1 where System_User_ID =166 and @StoreId =281; update [system_user] set Locked = 1 where System_User_ID =208 and @StoreId =281; update [system_user] set Locked = 1 where System_User_ID =176 and @StoreId =281; update [system_user] set Locked = 1 where System_User_ID =160 and @StoreId =281; update [system_user] set Locked = 1 where System_User_ID =159 and @StoreId =281; update [system_user] set Locked = 1 where System_User_ID =188 and @StoreId =287; update [system_user] set Locked = 1 where System_User_ID =458920 and @StoreId =287; update [system_user] set Locked = 1 where System_User_ID =10188 and @StoreId =287; update [system_user] set Locked = 1 where System_User_ID =190 and @StoreId =287; update [system_user] set Locked = 1 where System_User_ID =10189 and @StoreId =287; update [system_user] set Locked = 1 where System_User_ID =185 and @StoreId =287; update [system_user] set Locked = 1 where System_User_ID =10190 and @StoreId =287; update [system_user] set Locked = 1 where System_User_ID =186 and @StoreId =287; update [system_user] set Locked = 1 where System_User_ID =187 and @StoreId =287; update [system_user] set Locked = 1 where System_User_ID =238 and @StoreId =198; update [system_user] set Locked = 1 where System_User_ID =239 and @StoreId =198; update [system_user] set Locked = 1 where System_User_ID =301 and @StoreId =198; update [system_user] set Locked = 1 where System_User_ID =276 and @StoreId =198; update [system_user] set Locked = 1 where System_User_ID =227 and @StoreId =198; update [system_user] set Locked = 1 where System_User_ID =58 and @StoreId =198; update [system_user] set Locked = 1 where System_User_ID =164 and @StoreId =198; update [system_user] set Locked = 1 where System_User_ID =24 and @StoreId =198; update [system_user] set Locked = 1 where System_User_ID =48 and @StoreId =198; update [system_user] set Locked = 1 where System_User_ID =82 and @StoreId =198; update [system_user] set Locked = 1 where System_User_ID =208 and @StoreId =198; update [system_user] set Locked = 1 where System_User_ID =135 and @StoreId =198; update [system_user] set Locked = 1 where System_User_ID =569074 and @StoreId =198; update [system_user] set Locked = 1 where System_User_ID =281 and @StoreId =232; update [system_user] set Locked = 1 where System_User_ID =188 and @StoreId =232; update [system_user] set Locked = 1 where System_User_ID =295 and @StoreId =232; update [system_user] set Locked = 1 where System_User_ID =269 and @StoreId =232; update [system_user] set Locked = 1 where System_User_ID =283 and @StoreId =232; update [system_user] set Locked = 1 where System_User_ID =260 and @StoreId =232; update [system_user] set Locked = 1 where System_User_ID =134 and @StoreId =232; update [system_user] set Locked = 1 where System_User_ID =175 and @StoreId =232; update [system_user] set Locked = 1 where System_User_ID =282 and @StoreId =232; update [system_user] set Locked = 1 where System_User_ID =284 and @StoreId =232; update [system_user] set Locked = 1 where System_User_ID =189 and @StoreId =232; update [system_user] set Locked = 1 where System_User_ID =10238 and @StoreId =255; update [system_user] set Locked = 1 where System_User_ID =10255 and @StoreId =255; update [system_user] set Locked = 1 where System_User_ID =10248 and @StoreId =255; update [system_user] set Locked = 1 where System_User_ID =196 and @StoreId =255; update [system_user] set Locked = 1 where System_User_ID =10256 and @StoreId =255; update [system_user] set Locked = 1 where System_User_ID =10257 and @StoreId =255; update [system_user] set Locked = 1 where System_User_ID =184 and @StoreId =255; update [system_user] set Locked = 1 where System_User_ID =202 and @StoreId =255; update [system_user] set Locked = 1 where System_User_ID =175 and @StoreId =255; update [system_user] set Locked = 1 where System_User_ID =458993 and @StoreId =255; update [system_user] set Locked = 1 where System_User_ID =10236 and @StoreId =255; update [system_user] set Locked = 1 where System_User_ID =458978 and @StoreId =98; update [system_user] set Locked = 1 where System_User_ID =479009 and @StoreId =98; update [system_user] set Locked = 1 where System_User_ID =459048 and @StoreId =98; update [system_user] set Locked = 1 where System_User_ID =459029 and @StoreId =98; update [system_user] set Locked = 1 where System_User_ID =459013 and @StoreId =98; update [system_user] set Locked = 1 where System_User_ID =459071 and @StoreId =98; update [system_user] set Locked = 1 where System_User_ID =459081 and @StoreId =98; update [system_user] set Locked = 1 where System_User_ID =458958 and @StoreId =98; update [system_user] set Locked = 1 where System_User_ID =459014 and @StoreId =98; update [system_user] set Locked = 1 where System_User_ID =459040 and @StoreId =98; update [system_user] set Locked = 1 where System_User_ID =459072 and @StoreId =98; update [system_user] set Locked = 1 where System_User_ID =458981 and @StoreId =98; update [system_user] set Locked = 1 where System_User_ID =199 and @StoreId =286; update [system_user] set Locked = 1 where System_User_ID =199 and @StoreId =286; update [system_user] set Locked = 1 where System_User_ID =194 and @StoreId =286; update [system_user] set Locked = 1 where System_User_ID =192 and @StoreId =286; update [system_user] set Locked = 1 where System_User_ID =202 and @StoreId =286; update [system_user] set Locked = 1 where System_User_ID =233 and @StoreId =286; update [system_user] set Locked = 1 where System_User_ID =220 and @StoreId =286; update [system_user] set Locked = 1 where System_User_ID =200 and @StoreId =286; update [system_user] set Locked = 1 where System_User_ID =198 and @StoreId =286; update [system_user] set Locked = 1 where System_User_ID =201 and @StoreId =286; update [system_user] set Locked = 1 where System_User_ID =195 and @StoreId =286; update [system_user] set Locked = 1 where System_User_ID =489213 and @StoreId =99; update [system_user] set Locked = 1 where System_User_ID =5 and @StoreId =99; update [system_user] set Locked = 1 where System_User_ID =458827 and @StoreId =99; update [system_user] set Locked = 1 where System_User_ID =459057 and @StoreId =99; update [system_user] set Locked = 1 where System_User_ID =459066 and @StoreId =99; update [system_user] set Locked = 1 where System_User_ID =479128 and @StoreId =99; update [system_user] set Locked = 1 where System_User_ID =10248 and @StoreId =99; update [system_user] set Locked = 1 where System_User_ID =489210 and @StoreId =99; update [system_user] set Locked = 1 where System_User_ID =489218 and @StoreId =99; update [system_user] set Locked = 1 where System_User_ID =489196 and @StoreId =99; update [system_user] set Locked = 1 where System_User_ID =60205 and @StoreId =290; update [system_user] set Locked = 1 where System_User_ID =60202 and @StoreId =290; update [system_user] set Locked = 1 where System_User_ID =60208 and @StoreId =290; update [system_user] set Locked = 1 where System_User_ID =10256 and @StoreId =290; update [system_user] set Locked = 1 where System_User_ID =60206 and @StoreId =290; update [system_user] set Locked = 1 where System_User_ID =60225 and @StoreId =290; update [system_user] set Locked = 1 where System_User_ID =60213 and @StoreId =290; update [system_user] set Locked = 1 where System_User_ID =10251 and @StoreId =290; update [system_user] set Locked = 1 where System_User_ID =60209 and @StoreId =290; update [system_user] set Locked = 1 where System_User_ID =231 and @StoreId =285; update [system_user] set Locked = 1 where System_User_ID =219 and @StoreId =285; update [system_user] set Locked = 1 where System_User_ID =244 and @StoreId =285; update [system_user] set Locked = 1 where System_User_ID =223 and @StoreId =285; update [system_user] set Locked = 1 where System_User_ID =206 and @StoreId =285; update [system_user] set Locked = 1 where System_User_ID =176 and @StoreId =285; update [system_user] set Locked = 1 where System_User_ID =172 and @StoreId =285; update [system_user] set Locked = 1 where System_User_ID =458976 and @StoreId =285; update [system_user] set Locked = 1 where System_User_ID =237 and @StoreId =285; update [system_user] set Locked = 1 where System_User_ID =173 and @StoreId =285; update [system_user] set Locked = 1 where System_User_ID =227 and @StoreId =285; update [system_user] set Locked = 1 where System_User_ID =167 and @StoreId =285; update [system_user] set Locked = 1 where System_User_ID =186 and @StoreId =285; update [system_user] set Locked = 1 where System_User_ID =174 and @StoreId =285; update [system_user] set Locked = 1 where System_User_ID =509145 and @StoreId =51; update [system_user] set Locked = 1 where System_User_ID =489081 and @StoreId =51; update [system_user] set Locked = 1 where System_User_ID =479067 and @StoreId =51; update [system_user] set Locked = 1 where System_User_ID =489100 and @StoreId =51; update [system_user] set Locked = 1 where System_User_ID =469039 and @StoreId =51; update [system_user] set Locked = 1 where System_User_ID =458976 and @StoreId =51; update [system_user] set Locked = 1 where System_User_ID =187 and @StoreId =51; update [system_user] set Locked = 1 where System_User_ID =458871 and @StoreId =51; update [system_user] set Locked = 1 where System_User_ID =489083 and @StoreId =51; update [system_user] set Locked = 1 where System_User_ID =509144 and @StoreId =51; update [system_user] set Locked = 1 where System_User_ID =489075 and @StoreId =103; update [system_user] set Locked = 1 where System_User_ID =479061 and @StoreId =103; update [system_user] set Locked = 1 where System_User_ID =458871 and @StoreId =103; update [system_user] set Locked = 1 where System_User_ID =458872 and @StoreId =103; update [system_user] set Locked = 1 where System_User_ID =469033 and @StoreId =103; update [system_user] set Locked = 1 where System_User_ID =458849 and @StoreId =103; update [system_user] set Locked = 1 where System_User_ID =458826 and @StoreId =103; update [system_user] set Locked = 1 where System_User_ID =458931 and @StoreId =103; update [system_user] set Locked = 1 where System_User_ID =458867 and @StoreId =103; update [system_user] set Locked = 1 where System_User_ID =458949 and @StoreId =103; update [system_user] set Locked = 1 where System_User_ID =458988 and @StoreId =103; update [system_user] set Locked = 1 where System_User_ID =90312 and @StoreId =211; update [system_user] set Locked = 1 where System_User_ID =5 and @StoreId =211; update [system_user] set Locked = 1 where System_User_ID =8 and @StoreId =211; update [system_user] set Locked = 1 where System_User_ID =459053 and @StoreId =211; update [system_user] set Locked = 1 where System_User_ID =140327 and @StoreId =211; update [system_user] set Locked = 1 where System_User_ID =130319 and @StoreId =211; update [system_user] set Locked = 1 where System_User_ID =90307 and @StoreId =211; update [system_user] set Locked = 1 where System_User_ID =202 and @StoreId =211; update [system_user] set Locked = 1 where System_User_ID =140328 and @StoreId =211; update [system_user] set Locked = 1 where System_User_ID =194 and @StoreId =211; update [system_user] set Locked = 1 where System_User_ID =204 and @StoreId =211; update [system_user] set Locked = 1 where System_User_ID =141 and @StoreId =211; update [system_user] set Locked = 1 where System_User_ID =28 and @StoreId =211; update [system_user] set Locked = 1 where System_User_ID =10244 and @StoreId =211; update [system_user] set Locked = 1 where System_User_ID =140321 and @StoreId =211; update [system_user] set Locked = 1 where System_User_ID =99 and @StoreId =211; update [system_user] set Locked = 1 where System_User_ID =459173 and @StoreId =105; update [system_user] set Locked = 1 where System_User_ID =114 and @StoreId =105; update [system_user] set Locked = 1 where System_User_ID =458960 and @StoreId =105; update [system_user] set Locked = 1 where System_User_ID =459187 and @StoreId =105; update [system_user] set Locked = 1 where System_User_ID =239 and @StoreId =105; update [system_user] set Locked = 1 where System_User_ID =10225 and @StoreId =105; update [system_user] set Locked = 1 where System_User_ID =459079 and @StoreId =105; update [system_user] set Locked = 1 where System_User_ID =459047 and @StoreId =105; update [system_user] set Locked = 1 where System_User_ID =459233 and @StoreId =105; update [system_user] set Locked = 1 where System_User_ID =128 and @StoreId =105; update [system_user] set Locked = 1 where System_User_ID =459149 and @StoreId =105; update [system_user] set Locked = 1 where System_User_ID =459195 and @StoreId =105; update [system_user] set Locked = 1 where System_User_ID =459043 and @StoreId =137; update [system_user] set Locked = 1 where System_User_ID =270 and @StoreId =137; update [system_user] set Locked = 1 where System_User_ID =459030 and @StoreId =137; update [system_user] set Locked = 1 where System_User_ID =459034 and @StoreId =137; update [system_user] set Locked = 1 where System_User_ID =237 and @StoreId =137; update [system_user] set Locked = 1 where System_User_ID =459099 and @StoreId =137; update [system_user] set Locked = 1 where System_User_ID =459097 and @StoreId =137; update [system_user] set Locked = 1 where System_User_ID =458841 and @StoreId =137; update [system_user] set Locked = 1 where System_User_ID =459100 and @StoreId =137; update [system_user] set Locked = 1 where System_User_ID =140 and @StoreId =137; update [system_user] set Locked = 1 where System_User_ID =458960 and @StoreId =159; update [system_user] set Locked = 1 where System_User_ID =479089 and @StoreId =159; update [system_user] set Locked = 1 where System_User_ID =458838 and @StoreId =159; update [system_user] set Locked = 1 where System_User_ID =479064 and @StoreId =159; update [system_user] set Locked = 1 where System_User_ID =479009 and @StoreId =159; update [system_user] set Locked = 1 where System_User_ID =458872 and @StoreId =159; update [system_user] set Locked = 1 where System_User_ID =479082 and @StoreId =159; update [system_user] set Locked = 1 where System_User_ID =479074 and @StoreId =159; update [system_user] set Locked = 1 where System_User_ID =489096 and @StoreId =159; update [system_user] set Locked = 1 where System_User_ID =489095 and @StoreId =159; update [system_user] set Locked = 1 where System_User_ID =10160 and @StoreId =248; update [system_user] set Locked = 1 where System_User_ID =60256 and @StoreId =248; update [system_user] set Locked = 1 where System_User_ID =30240 and @StoreId =248; update [system_user] set Locked = 1 where System_User_ID =60263 and @StoreId =248; update [system_user] set Locked = 1 where System_User_ID =30188 and @StoreId =248; update [system_user] set Locked = 1 where System_User_ID =87 and @StoreId =248; update [system_user] set Locked = 1 where System_User_ID =479113 and @StoreId =248; update [system_user] set Locked = 1 where System_User_ID =40244 and @StoreId =248; update [system_user] set Locked = 1 where System_User_ID =132 and @StoreId =248; update [system_user] set Locked = 1 where System_User_ID =60264 and @StoreId =248; update [system_user] set Locked = 1 where System_User_ID =30235 and @StoreId =248; update [system_user] set Locked = 1 where System_User_ID =30239 and @StoreId =248; update [system_user] set Locked = 1 where System_User_ID =479088 and @StoreId =52; update [system_user] set Locked = 1 where System_User_ID =549139 and @StoreId =52; update [system_user] set Locked = 1 where System_User_ID =479069 and @StoreId =52; update [system_user] set Locked = 1 where System_User_ID =458957 and @StoreId =52; update [system_user] set Locked = 1 where System_User_ID =287 and @StoreId =52; update [system_user] set Locked = 1 where System_User_ID =120306 and @StoreId =52; update [system_user] set Locked = 1 where System_User_ID =458955 and @StoreId =52; update [system_user] set Locked = 1 where System_User_ID =479079 and @StoreId =52; update [system_user] set Locked = 1 where System_User_ID =479087 and @StoreId =52; update [system_user] set Locked = 1 where System_User_ID =459033 and @StoreId =52; update [system_user] set Locked = 1 where System_User_ID =20386 and @StoreId =187; update [system_user] set Locked = 1 where System_User_ID =10290 and @StoreId =187; update [system_user] set Locked = 1 where System_User_ID =10253 and @StoreId =187; update [system_user] set Locked = 1 where System_User_ID =10227 and @StoreId =282; update [system_user] set Locked = 1 where System_User_ID =162 and @StoreId =282; update [system_user] set Locked = 1 where System_User_ID =10218 and @StoreId =282; update [system_user] set Locked = 1 where System_User_ID =161 and @StoreId =282; update [system_user] set Locked = 1 where System_User_ID =172 and @StoreId =282; update [system_user] set Locked = 1 where System_User_ID =202 and @StoreId =282; update [system_user] set Locked = 1 where System_User_ID =40240 and @StoreId =282; update [system_user] set Locked = 1 where System_User_ID =185 and @StoreId =282; update [system_user] set Locked = 1 where System_User_ID =206 and @StoreId =282; update [system_user] set Locked = 1 where System_User_ID =10196 and @StoreId =226; update [system_user] set Locked = 1 where System_User_ID =138 and @StoreId =226; update [system_user] set Locked = 1 where System_User_ID =92 and @StoreId =226; update [system_user] set Locked = 1 where System_User_ID =119 and @StoreId =226; update [system_user] set Locked = 1 where System_User_ID =172 and @StoreId =226; update [system_user] set Locked = 1 where System_User_ID =10188 and @StoreId =226; update [system_user] set Locked = 1 where System_User_ID =10255 and @StoreId =226; update [system_user] set Locked = 1 where System_User_ID =220 and @StoreId =226; update [system_user] set Locked = 1 where System_User_ID =30278 and @StoreId =226; update [system_user] set Locked = 1 where System_User_ID =10246 and @StoreId =226; update [system_user] set Locked = 1 where System_User_ID =192 and @StoreId =264; update [system_user] set Locked = 1 where System_User_ID =250 and @StoreId =264; update [system_user] set Locked = 1 where System_User_ID =235 and @StoreId =264; update [system_user] set Locked = 1 where System_User_ID =459171 and @StoreId =264; update [system_user] set Locked = 1 where System_User_ID =458827 and @StoreId =264; update [system_user] set Locked = 1 where System_User_ID =139 and @StoreId =264; update [system_user] set Locked = 1 where System_User_ID =459029 and @StoreId =264; update [system_user] set Locked = 1 where System_User_ID =157 and @StoreId =264; update [system_user] set Locked = 1 where System_User_ID =249 and @StoreId =264; update [system_user] set Locked = 1 where System_User_ID =479110 and @StoreId =264; update [system_user] set Locked = 1 where System_User_ID =142 and @StoreId =264; update [system_user] set Locked = 1 where System_User_ID =10188 and @StoreId =257; update [system_user] set Locked = 1 where System_User_ID =20234 and @StoreId =257; update [system_user] set Locked = 1 where System_User_ID =20240 and @StoreId =257; update [system_user] set Locked = 1 where System_User_ID =459253 and @StoreId =257; update [system_user] set Locked = 1 where System_User_ID =458950 and @StoreId =257; update [system_user] set Locked = 1 where System_User_ID =10182 and @StoreId =257; update [system_user] set Locked = 1 where System_User_ID =127 and @StoreId =257; update [system_user] set Locked = 1 where System_User_ID =40266 and @StoreId =257; update [system_user] set Locked = 1 where System_User_ID =10200 and @StoreId =257; update [system_user] set Locked = 1 where System_User_ID =458806 and @StoreId =34; update [system_user] set Locked = 1 where System_User_ID =459039 and @StoreId =34; update [system_user] set Locked = 1 where System_User_ID =458988 and @StoreId =34; update [system_user] set Locked = 1 where System_User_ID =458914 and @StoreId =34; update [system_user] set Locked = 1 where System_User_ID =458995 and @StoreId =34; update [system_user] set Locked = 1 where System_User_ID =469100 and @StoreId =34; update [system_user] set Locked = 1 where System_User_ID =468998 and @StoreId =34; update [system_user] set Locked = 1 where System_User_ID =469145 and @StoreId =34; update [system_user] set Locked = 1 where System_User_ID =469068 and @StoreId =34; update [system_user] set Locked = 1 where System_User_ID =197 and @StoreId =34; update [system_user] set Locked = 1 where System_User_ID =459046 and @StoreId =34; update [system_user] set Locked = 1 where System_User_ID =459073 and @StoreId =73; update [system_user] set Locked = 1 where System_User_ID =458811 and @StoreId =73; update [system_user] set Locked = 1 where System_User_ID =469103 and @StoreId =73; update [system_user] set Locked = 1 where System_User_ID =458820 and @StoreId =73; update [system_user] set Locked = 1 where System_User_ID =458941 and @StoreId =73; update [system_user] set Locked = 1 where System_User_ID =458851 and @StoreId =73; update [system_user] set Locked = 1 where System_User_ID =458955 and @StoreId =73; update [system_user] set Locked = 1 where System_User_ID =469105 and @StoreId =73; update [system_user] set Locked = 1 where System_User_ID =50300 and @StoreId =73; update [system_user] set Locked = 1 where System_User_ID =459078 and @StoreId =73; update [system_user] set Locked = 1 where System_User_ID =469129 and @StoreId =73; update [system_user] set Locked = 1 where System_User_ID =459077 and @StoreId =73; update [system_user] set Locked = 1 where System_User_ID =459055 and @StoreId =73; update [system_user] set Locked = 1 where System_User_ID =10263 and @StoreId =235; update [system_user] set Locked = 1 where System_User_ID =10264 and @StoreId =235; update [system_user] set Locked = 1 where System_User_ID =10256 and @StoreId =235; update [system_user] set Locked = 1 where System_User_ID =10266 and @StoreId =235; update [system_user] set Locked = 1 where System_User_ID =458964 and @StoreId =235; update [system_user] set Locked = 1 where System_User_ID =10255 and @StoreId =235; update [system_user] set Locked = 1 where System_User_ID =489086 and @StoreId =235; update [system_user] set Locked = 1 where System_User_ID =458919 and @StoreId =235; update [system_user] set Locked = 1 where System_User_ID =10262 and @StoreId =235; update [system_user] set Locked = 1 where System_User_ID =499108 and @StoreId =112; update [system_user] set Locked = 1 where System_User_ID =458828 and @StoreId =112; update [system_user] set Locked = 1 where System_User_ID =459005 and @StoreId =112; update [system_user] set Locked = 1 where System_User_ID =458939 and @StoreId =112; update [system_user] set Locked = 1 where System_User_ID =499111 and @StoreId =112; update [system_user] set Locked = 1 where System_User_ID =275 and @StoreId =112; update [system_user] set Locked = 1 where System_User_ID =499110 and @StoreId =112; update [system_user] set Locked = 1 where System_User_ID =529138 and @StoreId =112; update [system_user] set Locked = 1 where System_User_ID =285 and @StoreId =112; update [system_user] set Locked = 1 where System_User_ID =459159 and @StoreId =95; update [system_user] set Locked = 1 where System_User_ID =458820 and @StoreId =95; update [system_user] set Locked = 1 where System_User_ID =459167 and @StoreId =95; update [system_user] set Locked = 1 where System_User_ID =458856 and @StoreId =95; update [system_user] set Locked = 1 where System_User_ID =459132 and @StoreId =95; update [system_user] set Locked = 1 where System_User_ID =458804 and @StoreId =95; update [system_user] set Locked = 1 where System_User_ID =458809 and @StoreId =95; update [system_user] set Locked = 1 where System_User_ID =459106 and @StoreId =95; update [system_user] set Locked = 1 where System_User_ID =459031 and @StoreId =95; update [system_user] set Locked = 1 where System_User_ID =458868 and @StoreId =95; update [system_user] set Locked = 1 where System_User_ID =459170 and @StoreId =95; update [system_user] set Locked = 1 where System_User_ID =489081 and @StoreId =114; update [system_user] set Locked = 1 where System_User_ID =499093 and @StoreId =114; update [system_user] set Locked = 1 where System_User_ID =509113 and @StoreId =114; update [system_user] set Locked = 1 where System_User_ID =509095 and @StoreId =114; update [system_user] set Locked = 1 where System_User_ID =459051 and @StoreId =114; update [system_user] set Locked = 1 where System_User_ID =489082 and @StoreId =114; update [system_user] set Locked = 1 where System_User_ID =458847 and @StoreId =114; update [system_user] set Locked = 1 where System_User_ID =458909 and @StoreId =114; update [system_user] set Locked = 1 where System_User_ID =10237 and @StoreId =244; update [system_user] set Locked = 1 where System_User_ID =211 and @StoreId =244; update [system_user] set Locked = 1 where System_User_ID =30238 and @StoreId =244; update [system_user] set Locked = 1 where System_User_ID =50255 and @StoreId =244; update [system_user] set Locked = 1 where System_User_ID =196 and @StoreId =244; update [system_user] set Locked = 1 where System_User_ID =459091 and @StoreId =244; update [system_user] set Locked = 1 where System_User_ID =125 and @StoreId =244; update [system_user] set Locked = 1 where System_User_ID =40246 and @StoreId =244; update [system_user] set Locked = 1 where System_User_ID =215 and @StoreId =244; update [system_user] set Locked = 1 where System_User_ID =177 and @StoreId =244; update [system_user] set Locked = 1 where System_User_ID =213 and @StoreId =244; update [system_user] set Locked = 1 where System_User_ID =164 and @StoreId =283; update [system_user] set Locked = 1 where System_User_ID =10227 and @StoreId =283; update [system_user] set Locked = 1 where System_User_ID =10194 and @StoreId =283; update [system_user] set Locked = 1 where System_User_ID =10197 and @StoreId =283; update [system_user] set Locked = 1 where System_User_ID =10219 and @StoreId =283; update [system_user] set Locked = 1 where System_User_ID =160 and @StoreId =283; update [system_user] set Locked = 1 where System_User_ID =10218 and @StoreId =283; update [system_user] set Locked = 1 where System_User_ID =161 and @StoreId =283; update [system_user] set Locked = 1 where System_User_ID =162 and @StoreId =283; update [system_user] set Locked = 1 where System_User_ID =247 and @StoreId =241; update [system_user] set Locked = 1 where System_User_ID =10218 and @StoreId =241; update [system_user] set Locked = 1 where System_User_ID =20288 and @StoreId =241; update [system_user] set Locked = 1 where System_User_ID =499080 and @StoreId =241; update [system_user] set Locked = 1 where System_User_ID =10233 and @StoreId =241; update [system_user] set Locked = 1 where System_User_ID =10199 and @StoreId =241; update [system_user] set Locked = 1 where System_User_ID =10223 and @StoreId =241; update [system_user] set Locked = 1 where System_User_ID =20285 and @StoreId =241; update [system_user] set Locked = 1 where System_User_ID =10249 and @StoreId =241; update [system_user] set Locked = 1 where System_User_ID =99 and @StoreId =241; update [system_user] set Locked = 1 where System_User_ID =10219 and @StoreId =241; update [system_user] set Locked = 1 where System_User_ID =255 and @StoreId =241; update [system_user] set Locked = 1 where System_User_ID =10228 and @StoreId =241; update [system_user] set Locked = 1 where System_User_ID =459003 and @StoreId =201; update [system_user] set Locked = 1 where System_User_ID =469113 and @StoreId =201; update [system_user] set Locked = 1 where System_User_ID =459061 and @StoreId =201; update [system_user] set Locked = 1 where System_User_ID =459030 and @StoreId =201; update [system_user] set Locked = 1 where System_User_ID =459046 and @StoreId =201; update [system_user] set Locked = 1 where System_User_ID =459055 and @StoreId =201; update [system_user] set Locked = 1 where System_User_ID =458970 and @StoreId =201; update [system_user] set Locked = 1 where System_User_ID =254 and @StoreId =201; update [system_user] set Locked = 1 where System_User_ID =459033 and @StoreId =201; update [system_user] set Locked = 1 where System_User_ID =459071 and @StoreId =201; update [system_user] set Locked = 1 where System_User_ID =458805 and @StoreId =201; update [system_user] set Locked = 1 where System_User_ID =149 and @StoreId =268; update [system_user] set Locked = 1 where System_User_ID =458966 and @StoreId =66; update [system_user] set Locked = 1 where System_User_ID =458884 and @StoreId =66; update [system_user] set Locked = 1 where System_User_ID =87 and @StoreId =66; update [system_user] set Locked = 1 where System_User_ID =479096 and @StoreId =66; update [system_user] set Locked = 1 where System_User_ID =499132 and @StoreId =66; update [system_user] set Locked = 1 where System_User_ID =479097 and @StoreId =66; update [system_user] set Locked = 1 where System_User_ID =479098 and @StoreId =66; update [system_user] set Locked = 1 where System_User_ID =30204 and @StoreId =66; update [system_user] set Locked = 1 where System_User_ID =458850 and @StoreId =66; update [system_user] set Locked = 1 where System_User_ID =173 and @StoreId =206; update [system_user] set Locked = 1 where System_User_ID =252 and @StoreId =206; update [system_user] set Locked = 1 where System_User_ID =264 and @StoreId =206; update [system_user] set Locked = 1 where System_User_ID =459016 and @StoreId =206; update [system_user] set Locked = 1 where System_User_ID =228 and @StoreId =206; update [system_user] set Locked = 1 where System_User_ID =459036 and @StoreId =206; update [system_user] set Locked = 1 where System_User_ID =469091 and @StoreId =206; update [system_user] set Locked = 1 where System_User_ID =266 and @StoreId =206; update [system_user] set Locked = 1 where System_User_ID =229 and @StoreId =206; update [system_user] set Locked = 1 where System_User_ID =230 and @StoreId =206; update [system_user] set Locked = 1 where System_User_ID =210 and @StoreId =233; update [system_user] set Locked = 1 where System_User_ID =459076 and @StoreId =233; update [system_user] set Locked = 1 where System_User_ID =100 and @StoreId =233; update [system_user] set Locked = 1 where System_User_ID =80 and @StoreId =233; update [system_user] set Locked = 1 where System_User_ID =81 and @StoreId =233; update [system_user] set Locked = 1 where System_User_ID =82 and @StoreId =233; update [system_user] set Locked = 1 where System_User_ID =179 and @StoreId =233; update [system_user] set Locked = 1 where System_User_ID =20252 and @StoreId =233; update [system_user] set Locked = 1 where System_User_ID =122 and @StoreId =233; update [system_user] set Locked = 1 where System_User_ID =203 and @StoreId =233; update [system_user] set Locked = 1 where System_User_ID =177 and @StoreId =233; update [system_user] set Locked = 1 where System_User_ID =459082 and @StoreId =53; update [system_user] set Locked = 1 where System_User_ID =459079 and @StoreId =53; update [system_user] set Locked = 1 where System_User_ID =459073 and @StoreId =53; update [system_user] set Locked = 1 where System_User_ID =459088 and @StoreId =53; update [system_user] set Locked = 1 where System_User_ID =459089 and @StoreId =53; update [system_user] set Locked = 1 where System_User_ID =459083 and @StoreId =53; update [system_user] set Locked = 1 where System_User_ID =459004 and @StoreId =53; update [system_user] set Locked = 1 where System_User_ID =459072 and @StoreId =53; update [system_user] set Locked = 1 where System_User_ID =458936 and @StoreId =53; update [system_user] set Locked = 1 where System_User_ID =459080 and @StoreId =53; update [system_user] set Locked = 1 where System_User_ID =218 and @StoreId =91; update [system_user] set Locked = 1 where System_User_ID =10248 and @StoreId =91; update [system_user] set Locked = 1 where System_User_ID =40280 and @StoreId =91; update [system_user] set Locked = 1 where System_User_ID =86 and @StoreId =91; update [system_user] set Locked = 1 where System_User_ID =202 and @StoreId =91; update [system_user] set Locked = 1 where System_User_ID =151 and @StoreId =91; update [system_user] set Locked = 1 where System_User_ID =219 and @StoreId =91; update [system_user] set Locked = 1 where System_User_ID =10249 and @StoreId =91; update [system_user] set Locked = 1 where System_User_ID =40267 and @StoreId =91; update [system_user] set Locked = 1 where System_User_ID =207 and @StoreId =270; update [system_user] set Locked = 1 where System_User_ID =152 and @StoreId =270; update [system_user] set Locked = 1 where System_User_ID =153 and @StoreId =270; update [system_user] set Locked = 1 where System_User_ID =154 and @StoreId =270; update [system_user] set Locked = 1 where System_User_ID =150 and @StoreId =270; update [system_user] set Locked = 1 where System_User_ID =458977 and @StoreId =270; update [system_user] set Locked = 1 where System_User_ID =170 and @StoreId =270; update [system_user] set Locked = 1 where System_User_ID =151 and @StoreId =270; update [system_user] set Locked = 1 where System_User_ID =198 and @StoreId =270; update [system_user] set Locked = 1 where System_User_ID =169 and @StoreId =270; update [system_user] set Locked = 1 where System_User_ID =198 and @StoreId =236; update [system_user] set Locked = 1 where System_User_ID =222 and @StoreId =236; update [system_user] set Locked = 1 where System_User_ID =204 and @StoreId =236; update [system_user] set Locked = 1 where System_User_ID =458922 and @StoreId =236; update [system_user] set Locked = 1 where System_User_ID =131 and @StoreId =236; update [system_user] set Locked = 1 where System_User_ID =10261 and @StoreId =236; update [system_user] set Locked = 1 where System_User_ID =221 and @StoreId =236; update [system_user] set Locked = 1 where System_User_ID =109 and @StoreId =236; update [system_user] set Locked = 1 where System_User_ID =459113 and @StoreId =13; update [system_user] set Locked = 1 where System_User_ID =458973 and @StoreId =13; update [system_user] set Locked = 1 where System_User_ID =458883 and @StoreId =13; update [system_user] set Locked = 1 where System_User_ID =459136 and @StoreId =13; update [system_user] set Locked = 1 where System_User_ID =458872 and @StoreId =13; update [system_user] set Locked = 1 where System_User_ID =499095 and @StoreId =13; update [system_user] set Locked = 1 where System_User_ID =459013 and @StoreId =13; update [system_user] set Locked = 1 where System_User_ID =458966 and @StoreId =13; update [system_user] set Locked = 1 where System_User_ID =459105 and @StoreId =13; update [system_user] set Locked = 1 where System_User_ID =459155 and @StoreId =292; update [system_user] set Locked = 1 where System_User_ID =80215 and @StoreId =292; update [system_user] set Locked = 1 where System_User_ID =80210 and @StoreId =292; update [system_user] set Locked = 1 where System_User_ID =80212 and @StoreId =292; update [system_user] set Locked = 1 where System_User_ID =167 and @StoreId =292; update [system_user] set Locked = 1 where System_User_ID =80211 and @StoreId =292; update [system_user] set Locked = 1 where System_User_ID =70209 and @StoreId =292; update [system_user] set Locked = 1 where System_User_ID =70208 and @StoreId =292; update [system_user] set Locked = 1 where System_User_ID =80214 and @StoreId =292; update [system_user] set Locked = 1 where System_User_ID =115 and @StoreId =247; update [system_user] set Locked = 1 where System_User_ID =139 and @StoreId =247; update [system_user] set Locked = 1 where System_User_ID =107 and @StoreId =247; update [system_user] set Locked = 1 where System_User_ID =197 and @StoreId =247; update [system_user] set Locked = 1 where System_User_ID =196 and @StoreId =247; update [system_user] set Locked = 1 where System_User_ID =10216 and @StoreId =247; update [system_user] set Locked = 1 where System_User_ID =155 and @StoreId =247; update [system_user] set Locked = 1 where System_User_ID =106 and @StoreId =247; update [system_user] set Locked = 1 where System_User_ID =10217 and @StoreId =247; update [system_user] set Locked = 1 where System_User_ID =119 and @StoreId =247; update [system_user] set Locked = 1 where System_User_ID =90354 and @StoreId =247; update [system_user] set Locked = 1 where System_User_ID =134 and @StoreId =223; update [system_user] set Locked = 1 where System_User_ID =197 and @StoreId =223; update [system_user] set Locked = 1 where System_User_ID =258 and @StoreId =223; update [system_user] set Locked = 1 where System_User_ID =273 and @StoreId =223; update [system_user] set Locked = 1 where System_User_ID =459154 and @StoreId =223; update [system_user] set Locked = 1 where System_User_ID =81 and @StoreId =223; update [system_user] set Locked = 1 where System_User_ID =264 and @StoreId =223; update [system_user] set Locked = 1 where System_User_ID =129 and @StoreId =223; update [system_user] set Locked = 1 where System_User_ID =241 and @StoreId =223; update [system_user] set Locked = 1 where System_User_ID =240 and @StoreId =223; update [system_user] set Locked = 1 where System_User_ID =263 and @StoreId =223; update [system_user] set Locked = 1 where System_User_ID =132 and @StoreId =223; update [system_user] set Locked = 1 where System_User_ID =459251 and @StoreId =224; update [system_user] set Locked = 1 where System_User_ID =479072 and @StoreId =224; update [system_user] set Locked = 1 where System_User_ID =243 and @StoreId =224; update [system_user] set Locked = 1 where System_User_ID =250 and @StoreId =224; update [system_user] set Locked = 1 where System_User_ID =125 and @StoreId =224; update [system_user] set Locked = 1 where System_User_ID =459258 and @StoreId =224; update [system_user] set Locked = 1 where System_User_ID =459252 and @StoreId =224; update [system_user] set Locked = 1 where System_User_ID =459255 and @StoreId =224; update [system_user] set Locked = 1 where System_User_ID =363 and @StoreId =224; update [system_user] set Locked = 1 where System_User_ID =273 and @StoreId =224; update [system_user] set Locked = 1 where System_User_ID =459257 and @StoreId =224; update [system_user] set Locked = 1 where System_User_ID =40261 and @StoreId =224; update [system_user] set Locked = 1 where System_User_ID =459254 and @StoreId =224; update [system_user] set Locked = 1 where System_User_ID =10230 and @StoreId =249; update [system_user] set Locked = 1 where System_User_ID =110 and @StoreId =249; update [system_user] set Locked = 1 where System_User_ID =10200 and @StoreId =249; update [system_user] set Locked = 1 where System_User_ID =176 and @StoreId =249; update [system_user] set Locked = 1 where System_User_ID =10163 and @StoreId =249; update [system_user] set Locked = 1 where System_User_ID =40255 and @StoreId =249; update [system_user] set Locked = 1 where System_User_ID =10197 and @StoreId =249; update [system_user] set Locked = 1 where System_User_ID =10165 and @StoreId =249; update [system_user] set Locked = 1 where System_User_ID =105 and @StoreId =249; update [system_user] set Locked = 1 where System_User_ID =167 and @StoreId =249; update [system_user] set Locked = 1 where System_User_ID =10167 and @StoreId =249; update [system_user] set Locked = 1 where System_User_ID =136 and @StoreId =260; update [system_user] set Locked = 1 where System_User_ID =134 and @StoreId =260; update [system_user] set Locked = 1 where System_User_ID =131 and @StoreId =260; update [system_user] set Locked = 1 where System_User_ID =30216 and @StoreId =260; update [system_user] set Locked = 1 where System_User_ID =195 and @StoreId =260; update [system_user] set Locked = 1 where System_User_ID =197 and @StoreId =260; update [system_user] set Locked = 1 where System_User_ID =458857 and @StoreId =260; update [system_user] set Locked = 1 where System_User_ID =10220 and @StoreId =260; update [system_user] set Locked = 1 where System_User_ID =458971 and @StoreId =260; update [system_user] set Locked = 1 where System_User_ID =70216 and @StoreId =260; update [system_user] set Locked = 1 where System_User_ID =219 and @StoreId =260; update [system_user] set Locked = 1 where System_User_ID =479040 and @StoreId =260; update [system_user] set Locked = 1 where System_User_ID =206 and @StoreId =260; update [system_user] set Locked = 1 where System_User_ID =199 and @StoreId =217; update [system_user] set Locked = 1 where System_User_ID =180 and @StoreId =217; update [system_user] set Locked = 1 where System_User_ID =140 and @StoreId =217; update [system_user] set Locked = 1 where System_User_ID =50268 and @StoreId =217; update [system_user] set Locked = 1 where System_User_ID =479112 and @StoreId =217; update [system_user] set Locked = 1 where System_User_ID =469064 and @StoreId =217; update [system_user] set Locked = 1 where System_User_ID =469088 and @StoreId =217; update [system_user] set Locked = 1 where System_User_ID =149 and @StoreId =217; update [system_user] set Locked = 1 where System_User_ID =142 and @StoreId =217; update [system_user] set Locked = 1 where System_User_ID =174 and @StoreId =217; update [system_user] set Locked = 1 where System_User_ID =458806 and @StoreId =55; update [system_user] set Locked = 1 where System_User_ID =459101 and @StoreId =55; update [system_user] set Locked = 1 where System_User_ID =23 and @StoreId =55; update [system_user] set Locked = 1 where System_User_ID =459049 and @StoreId =55; update [system_user] set Locked = 1 where System_User_ID =178 and @StoreId =55; update [system_user] set Locked = 1 where System_User_ID =459011 and @StoreId =55; update [system_user] set Locked = 1 where System_User_ID =459057 and @StoreId =55; update [system_user] set Locked = 1 where System_User_ID =459056 and @StoreId =55; update [system_user] set Locked = 1 where System_User_ID =459013 and @StoreId =55; update [system_user] set Locked = 1 where System_User_ID =549068 and @StoreId =166; update [system_user] set Locked = 1 where System_User_ID =539061 and @StoreId =166; update [system_user] set Locked = 1 where System_User_ID =20313 and @StoreId =166; update [system_user] set Locked = 1 where System_User_ID =479063 and @StoreId =39; update [system_user] set Locked = 1 where System_User_ID =10363 and @StoreId =39; update [system_user] set Locked = 1 where System_User_ID =479057 and @StoreId =39; update [system_user] set Locked = 1 where System_User_ID =499083 and @StoreId =39; update [system_user] set Locked = 1 where System_User_ID =509118 and @StoreId =39; update [system_user] set Locked = 1 where System_User_ID =459000 and @StoreId =39; update [system_user] set Locked = 1 where System_User_ID =134 and @StoreId =39; update [system_user] set Locked = 1 where System_User_ID =509120 and @StoreId =39; update [system_user] set Locked = 1 where System_User_ID =459010 and @StoreId =39; update [system_user] set Locked = 1 where System_User_ID =509124 and @StoreId =39; update [system_user] set Locked = 1 where System_User_ID =499073 and @StoreId =39; update [system_user] set Locked = 1 where System_User_ID =499072 and @StoreId =39; update [system_user] set Locked = 1 where System_User_ID =10229 and @StoreId =39; update [system_user] set Locked = 1 where System_User_ID =499085 and @StoreId =39; update [system_user] set Locked = 1 where System_User_ID =458909 and @StoreId =39; update [system_user] set Locked = 1 where System_User_ID =479060 and @StoreId =39; update [system_user] set Locked = 1 where System_User_ID =30199 and @StoreId =258; update [system_user] set Locked = 1 where System_User_ID =291 and @StoreId =258; update [system_user] set Locked = 1 where System_User_ID =458856 and @StoreId =258; update [system_user] set Locked = 1 where System_User_ID =70222 and @StoreId =258; update [system_user] set Locked = 1 where System_User_ID =70220 and @StoreId =258; update [system_user] set Locked = 1 where System_User_ID =125 and @StoreId =258; update [system_user] set Locked = 1 where System_User_ID =180 and @StoreId =258; update [system_user] set Locked = 1 where System_User_ID =174 and @StoreId =261; update [system_user] set Locked = 1 where System_User_ID =134 and @StoreId =261; update [system_user] set Locked = 1 where System_User_ID =133 and @StoreId =261; update [system_user] set Locked = 1 where System_User_ID =459144 and @StoreId =261; update [system_user] set Locked = 1 where System_User_ID =132 and @StoreId =261; update [system_user] set Locked = 1 where System_User_ID =145 and @StoreId =261; update [system_user] set Locked = 1 where System_User_ID =28 and @StoreId =261; update [system_user] set Locked = 1 where System_User_ID =183 and @StoreId =261; update [system_user] set Locked = 1 where System_User_ID =147 and @StoreId =261; update [system_user] set Locked = 1 where System_User_ID =212 and @StoreId =261; update [system_user] set Locked = 1 where System_User_ID =203 and @StoreId =261; update [system_user] set Locked = 1 where System_User_ID =144 and @StoreId =261; update [system_user] set Locked = 1 where System_User_ID =185 and @StoreId =273; update [system_user] set Locked = 1 where System_User_ID =159 and @StoreId =273; update [system_user] set Locked = 1 where System_User_ID =211 and @StoreId =273; update [system_user] set Locked = 1 where System_User_ID =168 and @StoreId =273; update [system_user] set Locked = 1 where System_User_ID =175 and @StoreId =273; update [system_user] set Locked = 1 where System_User_ID =458873 and @StoreId =273; update [system_user] set Locked = 1 where System_User_ID =154 and @StoreId =273; update [system_user] set Locked = 1 where System_User_ID =221 and @StoreId =273; update [system_user] set Locked = 1 where System_User_ID =152 and @StoreId =273; update [system_user] set Locked = 1 where System_User_ID =219 and @StoreId =273; update [system_user] set Locked = 1 where System_User_ID =458960 and @StoreId =42; update [system_user] set Locked = 1 where System_User_ID =459045 and @StoreId =42; update [system_user] set Locked = 1 where System_User_ID =458965 and @StoreId =42; update [system_user] set Locked = 1 where System_User_ID =458861 and @StoreId =42; update [system_user] set Locked = 1 where System_User_ID =459069 and @StoreId =42; update [system_user] set Locked = 1 where System_User_ID =459071 and @StoreId =42; update [system_user] set Locked = 1 where System_User_ID =458984 and @StoreId =42; update [system_user] set Locked = 1 where System_User_ID =459072 and @StoreId =42; update [system_user] set Locked = 1 where System_User_ID =165 and @StoreId =42; update [system_user] set Locked = 1 where System_User_ID =459061 and @StoreId =42; update [system_user] set Locked = 1 where System_User_ID =458962 and @StoreId =42; update [system_user] set Locked = 1 where System_User_ID =202 and @StoreId =269; update [system_user] set Locked = 1 where System_User_ID =195 and @StoreId =269; update [system_user] set Locked = 1 where System_User_ID =229 and @StoreId =269; update [system_user] set Locked = 1 where System_User_ID =201 and @StoreId =269; update [system_user] set Locked = 1 where System_User_ID =152 and @StoreId =269; update [system_user] set Locked = 1 where System_User_ID =549051 and @StoreId =269; update [system_user] set Locked = 1 where System_User_ID =153 and @StoreId =269; update [system_user] set Locked = 1 where System_User_ID =150 and @StoreId =269; update [system_user] set Locked = 1 where System_User_ID =228 and @StoreId =269; update [system_user] set Locked = 1 where System_User_ID =70211 and @StoreId =291; update [system_user] set Locked = 1 where System_User_ID =70210 and @StoreId =291; update [system_user] set Locked = 1 where System_User_ID =70201 and @StoreId =291; update [system_user] set Locked = 1 where System_User_ID =70203 and @StoreId =291; update [system_user] set Locked = 1 where System_User_ID =70209 and @StoreId =291; update [system_user] set Locked = 1 where System_User_ID =70204 and @StoreId =291; update [system_user] set Locked = 1 where System_User_ID =100312 and @StoreId =108; update [system_user] set Locked = 1 where System_User_ID =143 and @StoreId =108; update [system_user] set Locked = 1 where System_User_ID =458973 and @StoreId =108; update [system_user] set Locked = 1 where System_User_ID =20254 and @StoreId =108; update [system_user] set Locked = 1 where System_User_ID =203 and @StoreId =108; update [system_user] set Locked = 1 where System_User_ID =187 and @StoreId =108; update [system_user] set Locked = 1 where System_User_ID =479061 and @StoreId =108; update [system_user] set Locked = 1 where System_User_ID =180 and @StoreId =108; update [system_user] set Locked = 1 where System_User_ID =50324 and @StoreId =108; update [system_user] set Locked = 1 where System_User_ID =20249 and @StoreId =108; update [system_user] set Locked = 1 where System_User_ID =137 and @StoreId =108; update [system_user] set Locked = 1 where System_User_ID =459167 and @StoreId =130; update [system_user] set Locked = 1 where System_User_ID =459149 and @StoreId =130; update [system_user] set Locked = 1 where System_User_ID =458836 and @StoreId =130; update [system_user] set Locked = 1 where System_User_ID =232 and @StoreId =130; update [system_user] set Locked = 1 where System_User_ID =458910 and @StoreId =130; update [system_user] set Locked = 1 where System_User_ID =458870 and @StoreId =130; update [system_user] set Locked = 1 where System_User_ID =342 and @StoreId =130; update [system_user] set Locked = 1 where System_User_ID =459158 and @StoreId =130; update [system_user] set Locked = 1 where System_User_ID =459185 and @StoreId =130; update [system_user] set Locked = 1 where System_User_ID =459038 and @StoreId =130; update [system_user] set Locked = 1 where System_User_ID =76 and @StoreId =213; update [system_user] set Locked = 1 where System_User_ID =459047 and @StoreId =213; update [system_user] set Locked = 1 where System_User_ID =110 and @StoreId =213; update [system_user] set Locked = 1 where System_User_ID =14 and @StoreId =213; update [system_user] set Locked = 1 where System_User_ID =96 and @StoreId =213; update [system_user] set Locked = 1 where System_User_ID =70219 and @StoreId =213; update [system_user] set Locked = 1 where System_User_ID =459046 and @StoreId =213; update [system_user] set Locked = 1 where System_User_ID =70216 and @StoreId =213; update [system_user] set Locked = 1 where System_User_ID =70191 and @StoreId =213; update [system_user] set Locked = 1 where System_User_ID =70217 and @StoreId =213; update [system_user] set Locked = 1 where System_User_ID =75 and @StoreId =213; update [system_user] set Locked = 1 where System_User_ID =70218 and @StoreId =213; update [system_user] set Locked = 1 where System_User_ID =30226 and @StoreId =280; update [system_user] set Locked = 1 where System_User_ID =159 and @StoreId =280; update [system_user] set Locked = 1 where System_User_ID =177 and @StoreId =280; update [system_user] set Locked = 1 where System_User_ID =168 and @StoreId =280; update [system_user] set Locked = 1 where System_User_ID =458974 and @StoreId =280; update [system_user] set Locked = 1 where System_User_ID =30234 and @StoreId =280; update [system_user] set Locked = 1 where System_User_ID =170 and @StoreId =280; update [system_user] set Locked = 1 where System_User_ID =30225 and @StoreId =280; update [system_user] set Locked = 1 where System_User_ID =519115 and @StoreId =81; update [system_user] set Locked = 1 where System_User_ID =489091 and @StoreId =81; update [system_user] set Locked = 1 where System_User_ID =519113 and @StoreId =81; update [system_user] set Locked = 1 where System_User_ID =458867 and @StoreId =81; update [system_user] set Locked = 1 where System_User_ID =458975 and @StoreId =81; update [system_user] set Locked = 1 where System_User_ID =469051 and @StoreId =81; update [system_user] set Locked = 1 where System_User_ID =469062 and @StoreId =81; update [system_user] set Locked = 1 where System_User_ID =458865 and @StoreId =81; update [system_user] set Locked = 1 where System_User_ID =489077 and @StoreId =81; update [system_user] set Locked = 1 where System_User_ID =489106 and @StoreId =81; update [system_user] set Locked = 1 where System_User_ID =489093 and @StoreId =81; update [system_user] set Locked = 1 where System_User_ID =228 and @StoreId =36; update [system_user] set Locked = 1 where System_User_ID =20302 and @StoreId =36; update [system_user] set Locked = 1 where System_User_ID =10253 and @StoreId =36; update [system_user] set Locked = 1 where System_User_ID =10251 and @StoreId =36; update [system_user] set Locked = 1 where System_User_ID =167 and @StoreId =36; update [system_user] set Locked = 1 where System_User_ID =162 and @StoreId =36; update [system_user] set Locked = 1 where System_User_ID =159 and @StoreId =36; update [system_user] set Locked = 1 where System_User_ID =190 and @StoreId =36; update [system_user] set Locked = 1 where System_User_ID =220 and @StoreId =36; update [system_user] set Locked = 1 where System_User_ID =559137 and @StoreId =161; update [system_user] set Locked = 1 where System_User_ID =559136 and @StoreId =161; update [system_user] set Locked = 1 where System_User_ID =459015 and @StoreId =161; update [system_user] set Locked = 1 where System_User_ID =458995 and @StoreId =161; update [system_user] set Locked = 1 where System_User_ID =459165 and @StoreId =161; update [system_user] set Locked = 1 where System_User_ID =458874 and @StoreId =161; update [system_user] set Locked = 1 where System_User_ID =116 and @StoreId =161; update [system_user] set Locked = 1 where System_User_ID =559107 and @StoreId =161; update [system_user] set Locked = 1 where System_User_ID =559116 and @StoreId =161; update [system_user] set Locked = 1 where System_User_ID =539086 and @StoreId =161; update [system_user] set Locked = 1 where System_User_ID =559111 and @StoreId =161; update [system_user] set Locked = 1 where System_User_ID =469095 and @StoreId =57; update [system_user] set Locked = 1 where System_User_ID =458810 and @StoreId =57; update [system_user] set Locked = 1 where System_User_ID =458975 and @StoreId =57; update [system_user] set Locked = 1 where System_User_ID =469094 and @StoreId =57; update [system_user] set Locked = 1 where System_User_ID =469024 and @StoreId =57; update [system_user] set Locked = 1 where System_User_ID =458968 and @StoreId =57; update [system_user] set Locked = 1 where System_User_ID =469083 and @StoreId =57; update [system_user] set Locked = 1 where System_User_ID =184 and @StoreId =57; update [system_user] set Locked = 1 where System_User_ID =459127 and @StoreId =176; update [system_user] set Locked = 1 where System_User_ID =459044 and @StoreId =176; update [system_user] set Locked = 1 where System_User_ID =458899 and @StoreId =176; update [system_user] set Locked = 1 where System_User_ID =71 and @StoreId =176; update [system_user] set Locked = 1 where System_User_ID =362 and @StoreId =176; update [system_user] set Locked = 1 where System_User_ID =10426 and @StoreId =176; update [system_user] set Locked = 1 where System_User_ID =173 and @StoreId =176; update [system_user] set Locked = 1 where System_User_ID =50327 and @StoreId =176; update [system_user] set Locked = 1 where System_User_ID =10427 and @StoreId =176; update [system_user] set Locked = 1 where System_User_ID =152 and @StoreId =176; update [system_user] set Locked = 1 where System_User_ID =347 and @StoreId =176; update [system_user] set Locked = 1 where System_User_ID =10404 and @StoreId =176; update [system_user] set Locked = 1 where System_User_ID =184 and @StoreId =176; update [system_user] set Locked = 1 where System_User_ID =351 and @StoreId =176; update [system_user] set Locked = 1 where System_User_ID =10410 and @StoreId =176; update [system_user] set Locked = 1 where System_User_ID =339 and @StoreId =176; update [system_user] set Locked = 1 where System_User_ID =330 and @StoreId =180; update [system_user] set Locked = 1 where System_User_ID =293 and @StoreId =180; update [system_user] set Locked = 1 where System_User_ID =362 and @StoreId =180; update [system_user] set Locked = 1 where System_User_ID =214 and @StoreId =180; update [system_user] set Locked = 1 where System_User_ID =459032 and @StoreId =180; update [system_user] set Locked = 1 where System_User_ID =458842 and @StoreId =180; update [system_user] set Locked = 1 where System_User_ID =458908 and @StoreId =180; update [system_user] set Locked = 1 where System_User_ID =302 and @StoreId =180; update [system_user] set Locked = 1 where System_User_ID =213 and @StoreId =180; update [system_user] set Locked = 1 where System_User_ID =222 and @StoreId =180; update [system_user] set Locked = 1 where System_User_ID =106 and @StoreId =180; update [system_user] set Locked = 1 where System_User_ID =288 and @StoreId =180; update [system_user] set Locked = 1 where System_User_ID =234 and @StoreId =180; update [system_user] set Locked = 1 where System_User_ID =459062 and @StoreId =140; update [system_user] set Locked = 1 where System_User_ID =459103 and @StoreId =140; update [system_user] set Locked = 1 where System_User_ID =458862 and @StoreId =140; update [system_user] set Locked = 1 where System_User_ID =459061 and @StoreId =140; update [system_user] set Locked = 1 where System_User_ID =459072 and @StoreId =140; update [system_user] set Locked = 1 where System_User_ID =459131 and @StoreId =140; update [system_user] set Locked = 1 where System_User_ID =459056 and @StoreId =140; update [system_user] set Locked = 1 where System_User_ID =240 and @StoreId =140; update [system_user] set Locked = 1 where System_User_ID =459048 and @StoreId =140; update [system_user] set Locked = 1 where System_User_ID =10230 and @StoreId =218; update [system_user] set Locked = 1 where System_User_ID =10220 and @StoreId =218; update [system_user] set Locked = 1 where System_User_ID =130276 and @StoreId =218; update [system_user] set Locked = 1 where System_User_ID =10209 and @StoreId =218; update [system_user] set Locked = 1 where System_User_ID =174 and @StoreId =218; update [system_user] set Locked = 1 where System_User_ID =70263 and @StoreId =218; update [system_user] set Locked = 1 where System_User_ID =167 and @StoreId =218; update [system_user] set Locked = 1 where System_User_ID =70265 and @StoreId =218; update [system_user] set Locked = 1 where System_User_ID =130269 and @StoreId =218; update [system_user] set Locked = 1 where System_User_ID =469086 and @StoreId =141; update [system_user] set Locked = 1 where System_User_ID =459073 and @StoreId =141; update [system_user] set Locked = 1 where System_User_ID =458807 and @StoreId =141; update [system_user] set Locked = 1 where System_User_ID =148 and @StoreId =141; update [system_user] set Locked = 1 where System_User_ID =469110 and @StoreId =141; update [system_user] set Locked = 1 where System_User_ID =469088 and @StoreId =141; update [system_user] set Locked = 1 where System_User_ID =469087 and @StoreId =141; update [system_user] set Locked = 1 where System_User_ID =489096 and @StoreId =141; update [system_user] set Locked = 1 where System_User_ID =188 and @StoreId =141; update [system_user] set Locked = 1 where System_User_ID =458946 and @StoreId =141; update [system_user] set Locked = 1 where System_User_ID =196 and @StoreId =141; update [system_user] set Locked = 1 where System_User_ID =479095 and @StoreId =141; update [system_user] set Locked = 1 where System_User_ID =20258 and @StoreId =250; update [system_user] set Locked = 1 where System_User_ID =10234 and @StoreId =250; update [system_user] set Locked = 1 where System_User_ID =10206 and @StoreId =250; update [system_user] set Locked = 1 where System_User_ID =259 and @StoreId =250; update [system_user] set Locked = 1 where System_User_ID =459080 and @StoreId =250; update [system_user] set Locked = 1 where System_User_ID =20253 and @StoreId =250; update [system_user] set Locked = 1 where System_User_ID =151 and @StoreId =250; update [system_user] set Locked = 1 where System_User_ID =72 and @StoreId =250; update [system_user] set Locked = 1 where System_User_ID =479176 and @StoreId =74; update [system_user] set Locked = 1 where System_User_ID =458889 and @StoreId =74; update [system_user] set Locked = 1 where System_User_ID =479177 and @StoreId =74; update [system_user] set Locked = 1 where System_User_ID =251 and @StoreId =74; update [system_user] set Locked = 1 where System_User_ID =459151 and @StoreId =74; update [system_user] set Locked = 1 where System_User_ID =499091 and @StoreId =74; update [system_user] set Locked = 1 where System_User_ID =458941 and @StoreId =74; update [system_user] set Locked = 1 where System_User_ID =569201 and @StoreId =74; update [system_user] set Locked = 1 where System_User_ID =352 and @StoreId =74; update [system_user] set Locked = 1 where System_User_ID =227 and @StoreId =74; update [system_user] set Locked = 1 where System_User_ID =10428 and @StoreId =74; update [system_user] set Locked = 1 where System_User_ID =459095 and @StoreId =74; update [system_user] set Locked = 1 where System_User_ID =499098 and @StoreId =74; update [system_user] set Locked = 1 where System_User_ID =10224 and @StoreId =267; update [system_user] set Locked = 1 where System_User_ID =168 and @StoreId =267; update [system_user] set Locked = 1 where System_User_ID =150 and @StoreId =267; update [system_user] set Locked = 1 where System_User_ID =161 and @StoreId =267; update [system_user] set Locked = 1 where System_User_ID =10192 and @StoreId =267; update [system_user] set Locked = 1 where System_User_ID =107 and @StoreId =267; update [system_user] set Locked = 1 where System_User_ID =10197 and @StoreId =267; update [system_user] set Locked = 1 where System_User_ID =10229 and @StoreId =267; update [system_user] set Locked = 1 where System_User_ID =180 and @StoreId =267; update [system_user] set Locked = 1 where System_User_ID =458905 and @StoreId =45; update [system_user] set Locked = 1 where System_User_ID =458857 and @StoreId =45; update [system_user] set Locked = 1 where System_User_ID =458937 and @StoreId =45; update [system_user] set Locked = 1 where System_User_ID =539062 and @StoreId =45; update [system_user] set Locked = 1 where System_User_ID =489156 and @StoreId =45; update [system_user] set Locked = 1 where System_User_ID =458884 and @StoreId =45; update [system_user] set Locked = 1 where System_User_ID =459073 and @StoreId =45; update [system_user] set Locked = 1 where System_User_ID =469092 and @StoreId =45; update [system_user] set Locked = 1 where System_User_ID =489157 and @StoreId =45; update [system_user] set Locked = 1 where System_User_ID =489164 and @StoreId =144; update [system_user] set Locked = 1 where System_User_ID =459101 and @StoreId =144; update [system_user] set Locked = 1 where System_User_ID =479128 and @StoreId =144; update [system_user] set Locked = 1 where System_User_ID =489142 and @StoreId =144; update [system_user] set Locked = 1 where System_User_ID =479127 and @StoreId =144; update [system_user] set Locked = 1 where System_User_ID =489163 and @StoreId =144; update [system_user] set Locked = 1 where System_User_ID =10353 and @StoreId =144; update [system_user] set Locked = 1 where System_User_ID =458965 and @StoreId =144; update [system_user] set Locked = 1 where System_User_ID =459041 and @StoreId =144; update [system_user] set Locked = 1 where System_User_ID =458989 and @StoreId =144; update [system_user] set Locked = 1 where System_User_ID =459083 and @StoreId =144; update [system_user] set Locked = 1 where System_User_ID =459084 and @StoreId =144; update [system_user] set Locked = 1 where System_User_ID =489136 and @StoreId =144; update [system_user] set Locked = 1 where System_User_ID =459015 and @StoreId =144; update [system_user] set Locked = 1 where System_User_ID =489153 and @StoreId =144; update [system_user] set Locked = 1 where System_User_ID =549076 and @StoreId =145; update [system_user] set Locked = 1 where System_User_ID =458865 and @StoreId =145; update [system_user] set Locked = 1 where System_User_ID =458807 and @StoreId =145; update [system_user] set Locked = 1 where System_User_ID =458870 and @StoreId =145; update [system_user] set Locked = 1 where System_User_ID =459084 and @StoreId =145; update [system_user] set Locked = 1 where System_User_ID =459081 and @StoreId =145; update [system_user] set Locked = 1 where System_User_ID =459079 and @StoreId =145; update [system_user] set Locked = 1 where System_User_ID =458841 and @StoreId =145; update [system_user] set Locked = 1 where System_User_ID =459037 and @StoreId =145; update [system_user] set Locked = 1 where System_User_ID =459080 and @StoreId =145; update [system_user] set Locked = 1 where System_User_ID =559100 and @StoreId =79; update [system_user] set Locked = 1 where System_User_ID =519125 and @StoreId =79; update [system_user] set Locked = 1 where System_User_ID =459158 and @StoreId =79; update [system_user] set Locked = 1 where System_User_ID =559133 and @StoreId =79; update [system_user] set Locked = 1 where System_User_ID =459161 and @StoreId =79; update [system_user] set Locked = 1 where System_User_ID =559130 and @StoreId =79; update [system_user] set Locked = 1 where System_User_ID =499060 and @StoreId =79; update [system_user] set Locked = 1 where System_User_ID =459077 and @StoreId =79; update [system_user] set Locked = 1 where System_User_ID =559131 and @StoreId =79; update [system_user] set Locked = 1 where System_User_ID =559132 and @StoreId =79; update [system_user] set Locked = 1 where System_User_ID =489084 and @StoreId =79; update [system_user] set Locked = 1 where System_User_ID =489106 and @StoreId =79; update [system_user] set Locked = 1 where System_User_ID =519126 and @StoreId =79; update [system_user] set Locked = 1 where System_User_ID =143 and @StoreId =256; update [system_user] set Locked = 1 where System_User_ID =10239 and @StoreId =256; update [system_user] set Locked = 1 where System_User_ID =10184 and @StoreId =256; update [system_user] set Locked = 1 where System_User_ID =10356 and @StoreId =256; update [system_user] set Locked = 1 where System_User_ID =20265 and @StoreId =256; update [system_user] set Locked = 1 where System_User_ID =10173 and @StoreId =256; update [system_user] set Locked = 1 where System_User_ID =10185 and @StoreId =256; update [system_user] set Locked = 1 where System_User_ID =10177 and @StoreId =256; update [system_user] set Locked = 1 where System_User_ID =10168 and @StoreId =256; update [system_user] set Locked = 1 where System_User_ID =479092 and @StoreId =59; update [system_user] set Locked = 1 where System_User_ID =479120 and @StoreId =59; update [system_user] set Locked = 1 where System_User_ID =458845 and @StoreId =59; update [system_user] set Locked = 1 where System_User_ID =479116 and @StoreId =59; update [system_user] set Locked = 1 where System_User_ID =458812 and @StoreId =59; update [system_user] set Locked = 1 where System_User_ID =174 and @StoreId =59; update [system_user] set Locked = 1 where System_User_ID =479045 and @StoreId =59; update [system_user] set Locked = 1 where System_User_ID =458926 and @StoreId =59; update [system_user] set Locked = 1 where System_User_ID =479117 and @StoreId =59; update [system_user] set Locked = 1 where System_User_ID =479118 and @StoreId =59; update [system_user] set Locked = 1 where System_User_ID =479053 and @StoreId =59; update [system_user] set Locked = 1 where System_User_ID =479089 and @StoreId =59; update [system_user] set Locked = 1 where System_User_ID =539103 and @StoreId =60; update [system_user] set Locked = 1 where System_User_ID =539098 and @StoreId =60; update [system_user] set Locked = 1 where System_User_ID =539108 and @StoreId =60; update [system_user] set Locked = 1 where System_User_ID =458849 and @StoreId =60; update [system_user] set Locked = 1 where System_User_ID =519092 and @StoreId =60; update [system_user] set Locked = 1 where System_User_ID =539102 and @StoreId =60; update [system_user] set Locked = 1 where System_User_ID =458953 and @StoreId =60; update [system_user] set Locked = 1 where System_User_ID =458952 and @StoreId =60; update [system_user] set Locked = 1 where System_User_ID =539099 and @StoreId =60; update [system_user] set Locked = 1 where System_User_ID =458968 and @StoreId =60; update [system_user] set Locked = 1 where System_User_ID =489099 and @StoreId =259; update [system_user] set Locked = 1 where System_User_ID =40244 and @StoreId =259; update [system_user] set Locked = 1 where System_User_ID =509127 and @StoreId =259; update [system_user] set Locked = 1 where System_User_ID =135 and @StoreId =259; update [system_user] set Locked = 1 where System_User_ID =10134 and @StoreId =259; update [system_user] set Locked = 1 where System_User_ID =20184 and @StoreId =259; update [system_user] set Locked = 1 where System_User_ID =40231 and @StoreId =259; update [system_user] set Locked = 1 where System_User_ID =156 and @StoreId =259; update [system_user] set Locked = 1 where System_User_ID =469036 and @StoreId =259; update [system_user] set Locked = 1 where System_User_ID =559164 and @StoreId =295; update [system_user] set Locked = 1 where System_User_ID =70212 and @StoreId =295; update [system_user] set Locked = 1 where System_User_ID =70208 and @StoreId =295; update [system_user] set Locked = 1 where System_User_ID =196 and @StoreId =295; update [system_user] set Locked = 1 where System_User_ID =70214 and @StoreId =295; update [system_user] set Locked = 1 where System_User_ID =70217 and @StoreId =295; update [system_user] set Locked = 1 where System_User_ID =559163 and @StoreId =295; update [system_user] set Locked = 1 where System_User_ID =40290 and @StoreId =230; update [system_user] set Locked = 1 where System_User_ID =20372 and @StoreId =230; update [system_user] set Locked = 1 where System_User_ID =469080 and @StoreId =230; update [system_user] set Locked = 1 where System_User_ID =249 and @StoreId =230; update [system_user] set Locked = 1 where System_User_ID =217 and @StoreId =230; update [system_user] set Locked = 1 where System_User_ID =158 and @StoreId =230; update [system_user] set Locked = 1 where System_User_ID =163 and @StoreId =230; update [system_user] set Locked = 1 where System_User_ID =241 and @StoreId =230; update [system_user] set Locked = 1 where System_User_ID =10210 and @StoreId =230; update [system_user] set Locked = 1 where System_User_ID =269 and @StoreId =207; update [system_user] set Locked = 1 where System_User_ID =458837 and @StoreId =207; update [system_user] set Locked = 1 where System_User_ID =115 and @StoreId =207; update [system_user] set Locked = 1 where System_User_ID =159 and @StoreId =207; update [system_user] set Locked = 1 where System_User_ID =147 and @StoreId =207; update [system_user] set Locked = 1 where System_User_ID =301 and @StoreId =207; update [system_user] set Locked = 1 where System_User_ID =143 and @StoreId =207; update [system_user] set Locked = 1 where System_User_ID =225 and @StoreId =207; update [system_user] set Locked = 1 where System_User_ID =94 and @StoreId =207; update [system_user] set Locked = 1 where System_User_ID =129 and @StoreId =207; update [system_user] set Locked = 1 where System_User_ID =229 and @StoreId =207; update [system_user] set Locked = 1 where System_User_ID =277 and @StoreId =207; update [system_user] set Locked = 1 where System_User_ID =100 and @StoreId =207; update [system_user] set Locked = 1 where System_User_ID =458959 and @StoreId =207; update [system_user] set Locked = 1 where System_User_ID =236 and @StoreId =47; update [system_user] set Locked = 1 where System_User_ID =237 and @StoreId =47; update [system_user] set Locked = 1 where System_User_ID =110294 and @StoreId =47; update [system_user] set Locked = 1 where System_User_ID =164 and @StoreId =47; update [system_user] set Locked = 1 where System_User_ID =120305 and @StoreId =47; update [system_user] set Locked = 1 where System_User_ID =458899 and @StoreId =47; update [system_user] set Locked = 1 where System_User_ID =458824 and @StoreId =47; update [system_user] set Locked = 1 where System_User_ID =120306 and @StoreId =47; update [system_user] set Locked = 1 where System_User_ID =171 and @StoreId =47; update [system_user] set Locked = 1 where System_User_ID =167 and @StoreId =47; update [system_user] set Locked = 1 where System_User_ID =110295 and @StoreId =47; update [system_user] set Locked = 1 where System_User_ID =239 and @StoreId =47; update [system_user] set Locked = 1 where System_User_ID =10 and @StoreId =47; update [system_user] set Locked = 1 where System_User_ID =251 and @StoreId =47; update [system_user] set Locked = 1 where System_User_ID =225 and @StoreId =238; update [system_user] set Locked = 1 where System_User_ID =86 and @StoreId =238; update [system_user] set Locked = 1 where System_User_ID =163 and @StoreId =238; update [system_user] set Locked = 1 where System_User_ID =10263 and @StoreId =238; update [system_user] set Locked = 1 where System_User_ID =10262 and @StoreId =238; update [system_user] set Locked = 1 where System_User_ID =229 and @StoreId =238; update [system_user] set Locked = 1 where System_User_ID =152 and @StoreId =238; update [system_user] set Locked = 1 where System_User_ID =153 and @StoreId =238; update [system_user] set Locked = 1 where System_User_ID =90 and @StoreId =238; update [system_user] set Locked = 1 where System_User_ID =188 and @StoreId =238; update [system_user] set Locked = 1 where System_User_ID =10249 and @StoreId =274; update [system_user] set Locked = 1 where System_User_ID =10195 and @StoreId =274; update [system_user] set Locked = 1 where System_User_ID =10240 and @StoreId =274; update [system_user] set Locked = 1 where System_User_ID =150 and @StoreId =274; update [system_user] set Locked = 1 where System_User_ID =10246 and @StoreId =274; update [system_user] set Locked = 1 where System_User_ID =10170 and @StoreId =274; update [system_user] set Locked = 1 where System_User_ID =20265 and @StoreId =274; update [system_user] set Locked = 1 where System_User_ID =10177 and @StoreId =274; update [system_user] set Locked = 1 where System_User_ID =10238 and @StoreId =274; update [system_user] set Locked = 1 where System_User_ID =215 and @StoreId =274; update [system_user] set Locked = 1 where System_User_ID =20264 and @StoreId =274; update [system_user] set Locked = 1 where System_User_ID =10242 and @StoreId =274; update [system_user] set Locked = 1 where System_User_ID =20268 and @StoreId =274; update [system_user] set Locked = 1 where System_User_ID =458852 and @StoreId =63; update [system_user] set Locked = 1 where System_User_ID =5 and @StoreId =63; update [system_user] set Locked = 1 where System_User_ID =469050 and @StoreId =63; update [system_user] set Locked = 1 where System_User_ID =539054 and @StoreId =63; update [system_user] set Locked = 1 where System_User_ID =458985 and @StoreId =63; update [system_user] set Locked = 1 where System_User_ID =459002 and @StoreId =63; update [system_user] set Locked = 1 where System_User_ID =459115 and @StoreId =63; update [system_user] set Locked = 1 where System_User_ID =458873 and @StoreId =63; update [system_user] set Locked = 1 where System_User_ID =126 and @StoreId =63; update [system_user] set Locked = 1 where System_User_ID =459116 and @StoreId =63; update [system_user] set Locked = 1 where System_User_ID =479114 and @StoreId =63; update [system_user] set Locked = 1 where System_User_ID =479116 and @StoreId =63; update [system_user] set Locked = 1 where System_User_ID =171 and @StoreId =210; update [system_user] set Locked = 1 where System_User_ID =147 and @StoreId =210; update [system_user] set Locked = 1 where System_User_ID =529189 and @StoreId =210; update [system_user] set Locked = 1 where System_User_ID =458907 and @StoreId =210; update [system_user] set Locked = 1 where System_User_ID =40298 and @StoreId =210; update [system_user] set Locked = 1 where System_User_ID =169 and @StoreId =210; update [system_user] set Locked = 1 where System_User_ID =70338 and @StoreId =210; update [system_user] set Locked = 1 where System_User_ID =245 and @StoreId =210; update [system_user] set Locked = 1 where System_User_ID =200 and @StoreId =254; update [system_user] set Locked = 1 where System_User_ID =459094 and @StoreId =254; update [system_user] set Locked = 1 where System_User_ID =219 and @StoreId =254; update [system_user] set Locked = 1 where System_User_ID =136 and @StoreId =254; update [system_user] set Locked = 1 where System_User_ID =131 and @StoreId =254; update [system_user] set Locked = 1 where System_User_ID =141 and @StoreId =254; update [system_user] set Locked = 1 where System_User_ID =162 and @StoreId =254; update [system_user] set Locked = 1 where System_User_ID =174 and @StoreId =254; update [system_user] set Locked = 1 where System_User_ID =164 and @StoreId =254; update [system_user] set Locked = 1 where System_User_ID =136 and @StoreId =254; update [system_user] set Locked = 1 where System_User_ID =215 and @StoreId =212; update [system_user] set Locked = 1 where System_User_ID =167 and @StoreId =212; update [system_user] set Locked = 1 where System_User_ID =23 and @StoreId =212; update [system_user] set Locked = 1 where System_User_ID =50279 and @StoreId =212; update [system_user] set Locked = 1 where System_User_ID =166 and @StoreId =212; update [system_user] set Locked = 1 where System_User_ID =210 and @StoreId =212; update [system_user] set Locked = 1 where System_User_ID =76 and @StoreId =212; update [system_user] set Locked = 1 where System_User_ID =458869 and @StoreId =212; update [system_user] set Locked = 1 where System_User_ID =164 and @StoreId =212; update [system_user] set Locked = 1 where System_User_ID =196 and @StoreId =212; update [system_user] set Locked = 1 where System_User_ID =146 and @StoreId =212; update [system_user] set Locked = 1 where System_User_ID =20 and @StoreId =212; update [system_user] set Locked = 1 where System_User_ID =152 and @StoreId =272; update [system_user] set Locked = 1 where System_User_ID =200 and @StoreId =272; update [system_user] set Locked = 1 where System_User_ID =173 and @StoreId =272; update [system_user] set Locked = 1 where System_User_ID =150 and @StoreId =272; update [system_user] set Locked = 1 where System_User_ID =164 and @StoreId =272; update [system_user] set Locked = 1 where System_User_ID =153 and @StoreId =272; update [system_user] set Locked = 1 where System_User_ID =157 and @StoreId =272; update [system_user] set Locked = 1 where System_User_ID =197 and @StoreId =272; update [system_user] set Locked = 1 where System_User_ID =156 and @StoreId =272; update [system_user] set Locked = 1 where System_User_ID =175 and @StoreId =272; update [system_user] set Locked = 1 where System_User_ID =489041 and @StoreId =154; update [system_user] set Locked = 1 where System_User_ID =489095 and @StoreId =154; update [system_user] set Locked = 1 where System_User_ID =489105 and @StoreId =154; update [system_user] set Locked = 1 where System_User_ID =489011 and @StoreId =154; update [system_user] set Locked = 1 where System_User_ID =489017 and @StoreId =154; update [system_user] set Locked = 1 where System_User_ID =489104 and @StoreId =154; update [system_user] set Locked = 1 where System_User_ID =489078 and @StoreId =154; update [system_user] set Locked = 1 where System_User_ID =458897 and @StoreId =154; update [system_user] set Locked = 1 where System_User_ID =489064 and @StoreId =154; update [system_user] set Locked = 1 where System_User_ID =458981 and @StoreId =154; update [system_user] set Locked = 1 where System_User_ID =458983 and @StoreId =154; update [system_user] set Locked = 1 where System_User_ID =489033 and @StoreId =154; update [system_user] set Locked = 1 where System_User_ID =489060 and @StoreId =154; update [system_user] set Locked = 1 where System_User_ID =458987 and @StoreId =154; update [system_user] set Locked = 1 where System_User_ID =489034 and @StoreId =154; update [system_user] set Locked = 1 where System_User_ID =489017 and @StoreId =163; update [system_user] set Locked = 1 where System_User_ID =458828 and @StoreId =163; update [system_user] set Locked = 1 where System_User_ID =231 and @StoreId =163; update [system_user] set Locked = 1 where System_User_ID =489011 and @StoreId =163; update [system_user] set Locked = 1 where System_User_ID =539049 and @StoreId =163; update [system_user] set Locked = 1 where System_User_ID =458950 and @StoreId =163; update [system_user] set Locked = 1 where System_User_ID =489016 and @StoreId =163; update [system_user] set Locked = 1 where System_User_ID =458833 and @StoreId =163; update [system_user] set Locked = 1 where System_User_ID =458954 and @StoreId =163; update [system_user] set Locked = 1 where System_User_ID =569072 and @StoreId =163; update [system_user] set Locked = 1 where System_User_ID =458982 and @StoreId =163; update [system_user] set Locked = 1 where System_User_ID =458876 and @StoreId =29; update [system_user] set Locked = 1 where System_User_ID =459058 and @StoreId =29; update [system_user] set Locked = 1 where System_User_ID =458910 and @StoreId =29; update [system_user] set Locked = 1 where System_User_ID =458986 and @StoreId =29; update [system_user] set Locked = 1 where System_User_ID =458939 and @StoreId =29; update [system_user] set Locked = 1 where System_User_ID =458834 and @StoreId =29; update [system_user] set Locked = 1 where System_User_ID =458899 and @StoreId =29; update [system_user] set Locked = 1 where System_User_ID =459177 and @StoreId =29; update [system_user] set Locked = 1 where System_User_ID =458910 and @StoreId =29; update [system_user] set Locked = 1 where System_User_ID =458852 and @StoreId =29; update [system_user] set Locked = 1 where System_User_ID =458806 and @StoreId =29; update [system_user] set Locked = 1 where System_User_ID =8 and @StoreId =29; update [system_user] set Locked = 1 where System_User_ID =458844 and @StoreId =29; update [system_user] set Locked = 1 where System_User_ID =549064 and @StoreId =29; update [system_user] set Locked = 1 where System_User_ID =569089 and @StoreId =29; update [system_user] set Locked = 1 where System_User_ID =459142 and @StoreId =29; update [system_user] set Locked = 1 where System_User_ID =459141 and @StoreId =29; update [system_user] set Locked = 1 where System_User_ID =459040 and @StoreId =29; update [system_user] set Locked = 1 where System_User_ID =459094 and @StoreId =64; update [system_user] set Locked = 1 where System_User_ID =140331 and @StoreId =64; update [system_user] set Locked = 1 where System_User_ID =459079 and @StoreId =64; update [system_user] set Locked = 1 where System_User_ID =499139 and @StoreId =64; update [system_user] set Locked = 1 where System_User_ID =459082 and @StoreId =64; update [system_user] set Locked = 1 where System_User_ID =458871 and @StoreId =64; update [system_user] set Locked = 1 where System_User_ID =549065 and @StoreId =64; update [system_user] set Locked = 1 where System_User_ID =26 and @StoreId =64; update [system_user] set Locked = 1 where System_User_ID =459093 and @StoreId =64; update [system_user] set Locked = 1 where System_User_ID =459005 and @StoreId =64; update [system_user] set Locked = 1 where System_User_ID =549067 and @StoreId =64; update [system_user] set Locked = 1 where System_User_ID =459079 and @StoreId =64; update [system_user] set Locked = 1 where System_User_ID =458996 and @StoreId =64; update [system_user] set Locked = 1 where System_User_ID =458952 and @StoreId =64; update [system_user] set Locked = 1 where System_User_ID =458997 and @StoreId =64; update [system_user] set Locked = 1 where System_User_ID =10194 and @StoreId =194; update [system_user] set Locked = 1 where System_User_ID =40266 and @StoreId =194; update [system_user] set Locked = 1 where System_User_ID =459228 and @StoreId =194; update [system_user] set Locked = 1 where System_User_ID =10221 and @StoreId =194; update [system_user] set Locked = 1 where System_User_ID =152 and @StoreId =194; update [system_user] set Locked = 1 where System_User_ID =10222 and @StoreId =194; update [system_user] set Locked = 1 where System_User_ID =10244 and @StoreId =194; update [system_user] set Locked = 1 where System_User_ID =10245 and @StoreId =194; update [system_user] set Locked = 1 where System_User_ID =10250 and @StoreId =194; update [system_user] set Locked = 1 where System_User_ID =10191 and @StoreId =194; update [system_user] set Locked = 1 where System_User_ID =10200 and @StoreId =266; update [system_user] set Locked = 1 where System_User_ID =155 and @StoreId =266; update [system_user] set Locked = 1 where System_User_ID =156 and @StoreId =266; update [system_user] set Locked = 1 where System_User_ID =177 and @StoreId =266; update [system_user] set Locked = 1 where System_User_ID =149 and @StoreId =266; update [system_user] set Locked = 1 where System_User_ID =167 and @StoreId =266; update [system_user] set Locked = 1 where System_User_ID =569075 and @StoreId =266; update [system_user] set Locked = 1 where System_User_ID =20224 and @StoreId =266; update [system_user] set Locked = 1 where System_User_ID =459025 and @StoreId =49; update [system_user] set Locked = 1 where System_User_ID =459081 and @StoreId =49; update [system_user] set Locked = 1 where System_User_ID =469077 and @StoreId =49; update [system_user] set Locked = 1 where System_User_ID =231 and @StoreId =49; update [system_user] set Locked = 1 where System_User_ID =469101 and @StoreId =49; update [system_user] set Locked = 1 where System_User_ID =164 and @StoreId =49; update [system_user] set Locked = 1 where System_User_ID =458809 and @StoreId =49; update [system_user] set Locked = 1 where System_User_ID =469099 and @StoreId =49; update [system_user] set Locked = 1 where System_User_ID =469085 and @StoreId =49; update [system_user] set Locked = 1 where System_User_ID =191 and @StoreId =49; update [system_user] set Locked = 1 where System_User_ID =458972 and @StoreId =49; update [system_user] set Locked = 1 where System_User_ID =458965 and @StoreId =49; update [system_user] set Locked = 1 where System_User_ID =458930 and @StoreId =49; update [system_user] set Locked = 1 where System_User_ID =94 and @StoreId =229; update [system_user] set Locked = 1 where System_User_ID =459144 and @StoreId =229; update [system_user] set Locked = 1 where System_User_ID =239 and @StoreId =229; update [system_user] set Locked = 1 where System_User_ID =243 and @StoreId =229; update [system_user] set Locked = 1 where System_User_ID =248 and @StoreId =229; update [system_user] set Locked = 1 where System_User_ID =74 and @StoreId =229; update [system_user] set Locked = 1 where System_User_ID =10332 and @StoreId =229; update [system_user] set Locked = 1 where System_User_ID =489146 and @StoreId =229; update [system_user] set Locked = 1 where System_User_ID =170 and @StoreId =229; update [system_user] set Locked = 1 where System_User_ID =10320 and @StoreId =229; update [system_user] set Locked = 1 where System_User_ID =459155 and @StoreId =229; update [system_user] set Locked = 1 where System_User_ID =203 and @StoreId =279; update [system_user] set Locked = 1 where System_User_ID =459031 and @StoreId =279; update [system_user] set Locked = 1 where System_User_ID =165 and @StoreId =279; update [system_user] set Locked = 1 where System_User_ID =198 and @StoreId =279; update [system_user] set Locked = 1 where System_User_ID =182 and @StoreId =279; update [system_user] set Locked = 1 where System_User_ID =459179 and @StoreId =279; update [system_user] set Locked = 1 where System_User_ID =162 and @StoreId =279; update [system_user] set Locked = 1 where System_User_ID =204 and @StoreId =279; update [system_user] set Locked = 1 where System_User_ID =519181 and @StoreId =288; update [system_user] set Locked = 1 where System_User_ID =40207 and @StoreId =288; update [system_user] set Locked = 1 where System_User_ID =469084 and @StoreId =288; update [system_user] set Locked = 1 where System_User_ID =458893 and @StoreId =288; update [system_user] set Locked = 1 where System_User_ID =40202 and @StoreId =288; update [system_user] set Locked = 1 where System_User_ID =459060 and @StoreId =288; update [system_user] set Locked = 1 where System_User_ID =10416 and @StoreId =288; update [system_user] set Locked = 1 where System_User_ID =40200 and @StoreId =288; update [system_user] set Locked = 1 where System_User_ID =50218 and @StoreId =288; update [system_user] set Locked = 1 where System_User_ID =458826 and @StoreId =157; update [system_user] set Locked = 1 where System_User_ID =459037 and @StoreId =157; update [system_user] set Locked = 1 where System_User_ID =262 and @StoreId =237; update [system_user] set Locked = 1 where System_User_ID =256 and @StoreId =237; update [system_user] set Locked = 1 where System_User_ID =216 and @StoreId =237; update [system_user] set Locked = 1 where System_User_ID =171 and @StoreId =237; update [system_user] set Locked = 1 where System_User_ID =83 and @StoreId =237; update [system_user] set Locked = 1 where System_User_ID =280 and @StoreId =237; update [system_user] set Locked = 1 where System_User_ID =87 and @StoreId =237; update [system_user] set Locked = 1 where System_User_ID =241 and @StoreId =237; update [system_user] set Locked = 1 where System_User_ID =268 and @StoreId =237; update [system_user] set Locked = 1 where System_User_ID =143 and @StoreId =237; update [system_user] set Locked = 1 where System_User_ID =176 and @StoreId =237; update [system_user] set Locked = 1 where System_User_ID =106 and @StoreId =237; update [system_user] set Locked = 1 where System_User_ID =135 and @StoreId =237; update [system_user] set Locked = 1 where System_User_ID =275 and @StoreId =237; update [system_user] set Locked = 1 where System_User_ID =200 and @StoreId =237; update [system_user] set Locked = 1 where System_User_ID =459044 and @StoreId =89; update [system_user] set Locked = 1 where System_User_ID =459035 and @StoreId =89; update [system_user] set Locked = 1 where System_User_ID =458954 and @StoreId =89; update [system_user] set Locked = 1 where System_User_ID =458808 and @StoreId =89; update [system_user] set Locked = 1 where System_User_ID =459047 and @StoreId =89; update [system_user] set Locked = 1 where System_User_ID =459059 and @StoreId =89; update [system_user] set Locked = 1 where System_User_ID =458813 and @StoreId =89; update [system_user] set Locked = 1 where System_User_ID =459049 and @StoreId =89; update [system_user] set Locked = 1 where System_User_ID =459048 and @StoreId =89; update [system_user] set Locked = 1 where System_User_ID =459043 and @StoreId =89; update [system_user] set Locked = 1 where System_User_ID =459036 and @StoreId =89; update [system_user] set Locked = 1 where System_User_ID =459045 and @StoreId =89; Print 'Insert into script history if everything else is cool'; Insert into Script_History (RunDate,Script_Name) Values (CURRENT_TIMESTAMP,'LockDuplicateUsers21Dec2023'); IF @@ERROR != 0 BEGIN RAISERROR ('UNABLE TO CONTINUE WITH SCRIPT', 11, 1); RETURN; END GO