olaayo
asked on
SQL Server INsert question
Truncate Table sysdba.MDMSACCOUNT_UPLOADS TAGING
SET IDENTITY_INSERT [sysdba].[MDMSACCOUNT_UPLO ADSTAGING] ON
go
INSERT INTO [CAST].[sysdba].[MDMSACCOU NT_UPLOADS TAGING]
--(--MDMSACCOUNT_UPLOADID,
(ACCOUNTID,ACCOUNT,SWIFT_B IC_CODE,AU DIT,INSERT _DATETIME, SENT_DATET IME)
SET IDENTITY_INSERT sysdba.MDMSACCOUNT_UPLOADS TAGING OFF
I am trying to insert into a table with Identity Column
SELECT
--(--MDMSACCOUNT_UPLOADID,
([ACCOUNTID],[ACCOUNT],[SW IFT_BIC_CO DE],[AUDIT ]
,CONVERT( varchar(10), INSERT_DATETIME,120) as [INSERT_DATETIME]
,[SENT_DATETIME])
FROM [CAST].[sysdba].[MDMSACCOU NT_UPLOAD]
WHERE AUDIT IN ('A', 'U', 'Y') AND SENT_DATETIME IS NULL
SET IDENTITY_INSERT [sysdba].[MDMSACCOUNT_UPLO
go
INSERT INTO [CAST].[sysdba].[MDMSACCOU
--(--MDMSACCOUNT_UPLOADID,
(ACCOUNTID,ACCOUNT,SWIFT_B
SET IDENTITY_INSERT sysdba.MDMSACCOUNT_UPLOADS
I am trying to insert into a table with Identity Column
SELECT
--(--MDMSACCOUNT_UPLOADID,
([ACCOUNTID],[ACCOUNT],[SW
,CONVERT( varchar(10), INSERT_DATETIME,120) as [INSERT_DATETIME]
,[SENT_DATETIME])
FROM [CAST].[sysdba].[MDMSACCOU
WHERE AUDIT IN ('A', 'U', 'Y') AND SENT_DATETIME IS NULL
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am trying to run insert in to this table
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [sysdba].[MDMSACCOUNT_UPLO ADSTAGING] (
[MDMSACCOUNT_UPLOAD_ID] [int] IDENTITY(1,1) NOT NULL,
[MDMSACCOUNT_UPLOADID] [char](12) NULL,
[ACCOUNTID] [char](12) NOT NULL,
[ACCOUNT] [varchar](30) NOT NULL,
[SWIFT_BIC_CODE] [varchar](11) NULL,
[AUDIT] [char](1) NOT NULL,
[INSERT_DATETIME] [datetime] NOT NULL,
[SENT_DATETIME] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [sysdba].[MDMSACCOUNT_UPLO
[MDMSACCOUNT_UPLOAD_ID] [int] IDENTITY(1,1) NOT NULL,
[MDMSACCOUNT_UPLOADID] [char](12) NULL,
[ACCOUNTID] [char](12) NOT NULL,
[ACCOUNT] [varchar](30) NOT NULL,
[SWIFT_BIC_CODE] [varchar](11) NULL,
[AUDIT] [char](1) NOT NULL,
[INSERT_DATETIME] [datetime] NOT NULL,
[SENT_DATETIME] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
did not understand your question
ASKER
Truncate Table sysdba.MDMSACCOUNT_UPLOADS TAGING
SET IDENTITY_INSERT [sysdba].[MDMSACCOUNT_UPLO ADSTAGING] ON
go
INSERT INTO [CAST].[sysdba].[MDMSACCOU NT_UPLOADS TAGING]
--(--MDMSACCOUNT_UPLOADID,
(ACCOUNTID,ACCOUNT,SWIFT_B IC_CODE,AU DIT,INSERT _DATETIME, SENT_DATET IME)
SET IDENTITY_INSERT sysdba.MDMSACCOUNT_UPLOADS TAGING OFF
I am trying to insert into a table with Identity Column
SELECT
--(--MDMSACCOUNT_UPLOADID,
([ACCOUNTID],[ACCOUNT],[SW IFT_BIC_CO DE],[AUDIT ]
,CONVERT( varchar(10), INSERT_DATETIME,120) as [INSERT_DATETIME]
,[SENT_DATETIME])
FROM [CAST].[sysdba].[MDMSACCOU NT_UPLOAD]
WHERE AUDIT IN ('A', 'U', 'Y') AND SENT_DATETIME IS NULL
I am trying to run insert in to this table using the query above
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [sysdba].[MDMSACCOUNT_UPLO ADSTAGING] (
[MDMSACCOUNT_UPLOAD_ID] [int] IDENTITY(1,1) NOT NULL,
[MDMSACCOUNT_UPLOADID] [char](12) NULL,
[ACCOUNTID] [char](12) NOT NULL,
[ACCOUNT] [varchar](30) NOT NULL,
[SWIFT_BIC_CODE] [varchar](11) NULL,
[AUDIT] [char](1) NOT NULL,
[INSERT_DATETIME] [datetime] NOT NULL,
[SENT_DATETIME] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
SET IDENTITY_INSERT [sysdba].[MDMSACCOUNT_UPLO
go
INSERT INTO [CAST].[sysdba].[MDMSACCOU
--(--MDMSACCOUNT_UPLOADID,
(ACCOUNTID,ACCOUNT,SWIFT_B
SET IDENTITY_INSERT sysdba.MDMSACCOUNT_UPLOADS
I am trying to insert into a table with Identity Column
SELECT
--(--MDMSACCOUNT_UPLOADID,
([ACCOUNTID],[ACCOUNT],[SW
,CONVERT( varchar(10), INSERT_DATETIME,120) as [INSERT_DATETIME]
,[SENT_DATETIME])
FROM [CAST].[sysdba].[MDMSACCOU
WHERE AUDIT IN ('A', 'U', 'Y') AND SENT_DATETIME IS NULL
I am trying to run insert in to this table using the query above
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [sysdba].[MDMSACCOUNT_UPLO
[MDMSACCOUNT_UPLOAD_ID] [int] IDENTITY(1,1) NOT NULL,
[MDMSACCOUNT_UPLOADID] [char](12) NULL,
[ACCOUNTID] [char](12) NOT NULL,
[ACCOUNT] [varchar](30) NOT NULL,
[SWIFT_BIC_CODE] [varchar](11) NULL,
[AUDIT] [char](1) NOT NULL,
[INSERT_DATETIME] [datetime] NOT NULL,
[SENT_DATETIME] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
what error message are you getting?
ASKER
Perfect solution Thanks
Open in new window