推 cluclu:好的 感謝 我試看看 我之前有用另一個disctinct方式成功 07/04 18:01
DECLARE @EMPLOYEE table
(
EMPLOYEE_ID varchar(10),
CHK_CODE varchar(5)
)
INSERT INTO @EMPLOYEE VALUES ('001','Y')
INSERT INTO @EMPLOYEE VALUES ('002','Y')
INSERT INTO @EMPLOYEE VALUES ('009','Y')
INSERT INTO @EMPLOYEE VALUES ('004','Y')
INSERT INTO @EMPLOYEE VALUES ('010','Y')
DECLARE @WEB_POWERSET_MENU table
(
EMPLOYEE_ID varchar(10),
DEPART varchar(20),
GROUP_ID varchar(10),
MODULES_ID varchar(10),
VIEW_YN varchar(10),
INSERT_YN varchar(10),
EDIT_YN varchar(10),
DELETE_YN varchar(10)
)
INSERT INTO @WEB_POWERSET_MENU (EMPLOYEE_ID, DEPART, GROUP_ID,
MODULES_ID, VIEW_YN, INSERT_YN, EDIT_YN, DELETE_YN)
SELECT
EMPLOYEE_ID,
'sysmanager','02','08','Y','Y','Y','Y' from @EMPLOYEE
SELECT * FROM @WEB_POWERSET_MENU
這樣符合你要的嗎
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 122.117.41.57