批量修改权限问题现象客户需要给全部帐套固定的权限如果给全部权限的话还不行如果从前台增加的话那么一个一个点太慢了解决思路前台点太慢是不是可以从某个表直接插入，尝试以后决定从后台增加解决办法insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent)select 001,2012 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 002,2013 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 002,2014 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 003,2012 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 003,2013 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 003,2014 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 101,2006 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 101,2007 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 101,2008 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser,csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 101,2009 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 101,2010 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 101,2011 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 101,2012 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 101,2013 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 101,2014 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 102,2010 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 102,2011 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 102,2012 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 102,2013 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 102,2014 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 103,2002 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 103,2003 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 103,2004 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 103,2005 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 103,2006 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 103,2007 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 103,2008 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth wherecuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 103,2009 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 103,2010 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 103,2011 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 103,2012 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 103,2013 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 109,2011 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 111,2013 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 111,2014 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 112,2013 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType,cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 112,2014 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 201,2011 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 201,2012 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 202,2013 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 202,2014 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 203,2009 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 203,2010 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 203,2011 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent)select 203,2012 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 204,2013 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 204,2014 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 205,2009 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 205,2010 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 206,2004 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 206,2005 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 206,2006 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 206,2007 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser,csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 206,2008 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 206,2009 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 206,2010 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 206,2011 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 206,2012 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 206,2013 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 207,2005 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 207,2006 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 207,2007 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 207,2008 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 207,2009 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 207,2010 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 207,2011 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 207,2012 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 208,2005 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 208,2006 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 209,2010 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 302,2013 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth wherecuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 104,2014 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011insert into ua_holdauth(cAcc_Id, iYear, cUser_Id, cAuth_Id, iIsUser, csub_id, cAuthType, cRepellent, cRepellentModule, cNotRepellent) select 105,2014 ,cUser_Id,cAuth_Id,iIsUser,csub_id,cAuthType, cRepellent, cRepellentModule, cNotRepellent from ua_holdauth where cuser_id='all'and cacc_id=001 and iyear=2011。