Good Morning Experts,
I am trying to insert a sequence into the following insert record.
INSERT INTO SF4204_HDR ([OPRID]
,[RUN_CNTL_ID]
,[EMPLID]
,[NAME]
,[ACAD_PLAN]
,[ACAD_LEVEL_BOT]
,[PLAN_DESCR]
,[INVOICE_ID]
,[PRIOR_YEAR_AMT]
,[ADDRESS1]
,[ADDRESS2]
,[CITY]
,[STATE]
,[POSTAL]
,[COMMENTSHORT]
,[NC_SELCRIT_YN])
SELECT 'LN'
,'TEST'
,COMMON_ID
,' '
,' '
,' '
,' '
,' '
,NEXT VALUE FOR Invoice_Seq
,' '
,' '
,' '
,' '
,' '
,' '
' '
FROM PS_EMPLOYEE
It is not populating. Any ideas why. It is sqlserver. I can run the select ok and I see it populating but not when I do the insert.
Thanks, Brock.
are you inserting wrong values into the fields?