WITH NewRows
AS
(
	SELECT *
	FROM
	(
		VALUES (1,'CLIENT_NAME','C',0,0)
		,(2,'PORT_ID','C',0,0)
		,(3,'DOA1','C',0,0)
		,(4,'STATUS_DATE','C',0,0)
		,(5,'CUST_TYP','C',0,0) 
		,(6,'LOAN_CD_TYP','C',0,0)
		,(7,'BAL','C',0,0)
		,(8,'DATE_LPAY','C',0,0)
		,(9,'AMT_LPAY','C',0,0)
		,(10,'CHRG_OFF_D','C',0,0) 
		,(11,'CHRG_OFF_A','C',0,0) 
		,(12,'SETT_AUTH','C',0,0) 
		,(13,'NAME','C',0,0) 
		,(14,'D_SUFFIX','C',0,0) 
		,(15,'PATIENT_NM','C',0,0) 
		,(16,'D_EMP_STREET','C',0,0)
		,(17,'D_EMP_STREET2','C',0,0) 
		,(18,'D_EMP_CITY','C',0,0) 
		,(19,'D_EMP_STATE','C',0,0) 
		,(20,'D_EMP_ZIP','C',0,0) 
		,(21,'ORIG_CRED','C',0,0) 
		,(22,'FRST_DT_DELQ','C',0,0) 
		,(23,'AGENCY_COMM','C',0,0) 
		,(24,'PALL_ACCTNO','C',0,0) 
		,(25,'ORIG_ACCTNO','C',0,0) 
		,(26,'D_PHYSICIAN','C',0,0) 
		,(27,'D_EMP','C',0,0)
		,(28,'FACILITY_NM','C',0,0)
		,(29,'DIAG_CD','C',0,0)
	) d (SD_KEY, SD_TYPE, EDIT_SECURITY, MULTI_RECORDS, OtherCol)
)
,MaxVal(SD_KEYMax)
AS
(
	SELECT MAX(SD_KEY) 
	FROM SDMAST WITH (UPDLOCK, SERIALIZABLE)
)
INSERT INTO SDMAST
SELECT SD_KeyMax + SD_KEY, SD_TYPE, EDIT_SECURITY, MULTI_RECORDS, OtherCol
FROM NewRows
	CROSS JOIN MaxVal;