SET IDENTITY_INSERT [CustSA] ON
GO

INSERT INTO [CustSA] (
[ID], 
[CustID],
[SANumber],
[TypeID], 
[Inactive],
[TermBegins],               
[TermEnds],
[bUseBillAddress], 
[bOverrideEndDate])

SELECT
[ID], 
[CustID],
[SANumber],
[TypeID], 
[Inactive],
[TermBegins],               
[TermEnds],
[bUseBillAddress], 
[bOverrideEndDate]

FROM [tempCustSA]
GO

SET IDENTITY_INSERT [CustSA] OFF
GO