<% Option Explicit %> <!--#include file="../common.asp" -->
<%
strSQL = "UPDATE tblAuthor SET Group_ID = 14 WHERE(LEFT(Stat1, 1) = N'E') AND (Right(Stat1, 2) < N'97')" adoCon.Execute strSQL
strSQL = "UPDATE tblAuthor SET Group_ID = 15 WHERE(LEFT(Stat1, 1) = N'D') AND (Right(Stat1, 2) < N'97')" adoCon.Execute strSQL
strSQL = "UPDATE tblAuthor SET Group_ID = 16 WHERE(LEFT(Stat1, 1) = N'G') AND (Right(Stat1, 2) < N'97')" adoCon.Execute strSQL
strSQL = "UPDATE tblAuthor SET Group_ID = 17 WHERE(LEFT(Stat1, 1) = N'R') AND (Right(Stat1, 2) < N'97')" adoCon.Execute strSQL
strSQL = "UPDATE tblAuthor SET Group_ID = 18 WHERE(LEFT(Stat1, 1) = N'I') AND (Right(Stat1, 2) < N'97')" adoCon.Execute strSQL
strSQL = "UPDATE tblAuthor SET Group_ID = 19 WHERE(LEFT(Stat1, 1) = N'F') AND (Right(Stat1, 2) < N'97')" adoCon.Execute strSQL
strSQL = "UPDATE tblAuthor SET Group_ID = 20 WHERE(LEFT(Stat1, 1) = N'H') AND (Right(Stat1, 2) < N'97')" adoCon.Execute strSQL
strSQL = "UPDATE tblAuthor SET Group_ID = 21 WHERE(LEFT(Stat1, 1) = N'L') AND (Right(Stat1, 2) < N'97')" adoCon.Execute strSQL
strSQL = "UPDATE tblAuthor SET Group_ID = 22 WHERE(LEFT(Stat1, 1) = N'M') AND (Right(Stat1, 2) < N'97')" adoCon.Execute strSQL
strSQL = "UPDATE tblAuthor SET Group_ID = 7 WHERE(LEFT(Stat1, 1) = N'A') AND (RIGHT(Stat1, 2) > N'04')" adoCon.Execute strSQL
strSQL = "UPDATE tblAuthor SET Group_ID = 7 WHERE(LEFT(Stat1, 1) = N'A') AND (RIGHT(Stat1, 2) = N'02')" adoCon.Execute strSQL
strSQL = "UPDATE tblAuthor SET Group_ID = 6 WHERE(RIGHT(Stat1, 2) > N'97') OR (LEFT(Stat1,1)=N'B')" adoCon.Execute strSQL adoCon.Close Set adoCon = Nothing Set strCon = Nothing %>
|