USE [DB NAME]
GO
DECLARE @ModelName NVARCHAR(50) = 'SampleModelname'
DECLARE @UserName NVARCHAR(50) = SUSER_NAME()
DECLARE @UserId INT = (SELECT ID FROM mdm.tblUser u WHERE u.UserName = @UserName)
DECLARE @VersionId INT = (SELECT MAX(ID) FROM mdm.viw_SYSTEM_SCHEMA_VERSION WHERE Model_Name = @ModelName)
INSERT INTO [mdmDB].[mdm].[tblStgMember]
([ModelName]
,[HierarchyName]
,[EntityName]
,[MemberType_ID]
,[MemberName]
,[MemberCode])
SELECT @ModelName AS [ModelName]
,NULL
,N'EntityName'
,1
,'' AS [Name]
,Code AS [Code]
FROM db.dbo.tmpTable
INSERT INTO mdmDB.mdm.tblStgMemberAttribute
(ModelName
, EntityName
, MemberType_ID
, MemberCode
, AttributeName
, AttributeValue)
SELECT DISTINCT @ModelName AS [ModelName]
,N'EntityName'
,1
,r.Code as [Code]
,'Company'
,r.CompanyCode
FROM db.dbo.tmpTable r
INNER JOIN [mdmDB].[mdm].[ViewDN] cd
ON r.Code = cd.[Code]
EXEC mdm.udpStagingSweep @UserId=@UserId, @VersionId=@VersionId, @Process=1
GO
DECLARE @ModelName NVARCHAR(50) = 'SampleModelname'
DECLARE @UserName NVARCHAR(50) = SUSER_NAME()
DECLARE @UserId INT = (SELECT ID FROM mdm.tblUser u WHERE u.UserName = @UserName)
DECLARE @VersionId INT = (SELECT MAX(ID) FROM mdm.viw_SYSTEM_SCHEMA_VERSION WHERE Model_Name = @ModelName)
INSERT INTO [mdmDB].[mdm].[tblStgMember]
([ModelName]
,[HierarchyName]
,[EntityName]
,[MemberType_ID]
,[MemberName]
,[MemberCode])
SELECT @ModelName AS [ModelName]
,NULL
,N'EntityName'
,1
,'' AS [Name]
,Code AS [Code]
FROM db.dbo.tmpTable
INSERT INTO mdmDB.mdm.tblStgMemberAttribute
(ModelName
, EntityName
, MemberType_ID
, MemberCode
, AttributeName
, AttributeValue)
SELECT DISTINCT @ModelName AS [ModelName]
,N'EntityName'
,1
,r.Code as [Code]
,'Company'
,r.CompanyCode
FROM db.dbo.tmpTable r
INNER JOIN [mdmDB].[mdm].[ViewDN] cd
ON r.Code = cd.[Code]
EXEC mdm.udpStagingSweep @UserId=@UserId, @VersionId=@VersionId, @Process=1