Notes

------------------------------------------------------------------------------------------------------------------
-------------------------------------------------- Assignment Start ----------------------------------------------
------------------------------------------------------------------------------------------------------------------
PRINT 'Assignment Start'
------------------------------------------------------------------------------------------------------------------


SELECT @TableName = '5.0.0 Assignment:Assignment'
PRINT @TableName
IF NOT EXISTS ( SELECT *
FROM [LAPTOP-BI4KLJGI].[YOLO].[dbo].ConversionSnapShot css
WHERE css.TableName = @TableName
AND css.ExternalDB = @ExternalDB )
BEGIN
BEGIN TRY


SELECT @NewDBCount = COUNT(*) --Select count(*)
FROM [LAPTOP-BI4KLJGI].[OASIS].dbo.joborder A
INNER JOIN #TotalOrderConvertedList SO ON A.New_Order_ID = SO.ExternalID
AND SO.Externaldb=@ExternalDB
INNER JOIN [LAPTOP-BI4KLJGI].[OASIS].dbo.employeedetail em ON a.tj_emplnum = em.te_ssn
INNER JOIN #TotalEmployeeConvertedList E ON em.te_id = E.ExternalID
AND E.ExternalDB IS NOT NULL
WHERE A.ToConvert = 1


/*

Select *
FROM [LAPTOP-BI4KLJGI].[OASIS].dbo.joborder A
INNER JOIN #TotalOrderConvertedList SO ON A.New_Order_ID = SO.ExternalID
AND SO.Externaldb='CombinedRojen'
INNER JOIN [LAPTOP-BI4KLJGI].[OASIS].dbo.employeedetail em ON a.tj_emplnum = em.te_ssn
INNER JOIN #TotalEmployeeConvertedList E ON em.te_id = E.ExternalID
AND E.ExternalDB IS NOT NULL
WHERE A.ToConvert = 1

*/


SELECT @OldDBCount = COUNT(*) -- Select count(*)
FROM [LAPTOP-BI4KLJGI].[OASIS].dbo.joborder A
INNER JOIN [LAPTOP-BI4KLJGI].[OASIS].dbo.employeedetail em ON a.tj_emplnum = em.te_ssn
INNER JOIN [LAPTOP-BI4KLJGI].[OASIS].dbo.clientdetail c ON c.tc_clinum = A.tj_clientNo
WHERE A.ToConvert = 1
and c.toconvert = 1


IF ( ( @OldDBCount <> @NewDBCount ) )
BEGIN
SET @ErrorMessage = 'Error ' + @TableName
+ ': OldDBCount-'
+ CONVERT(VARCHAR, @OldDBCount)
+ ' does not match with NewDBCount-'
+ CONVERT(VARCHAR, @NewDBCount) + '.'
GOTO ConversionError
END
IF ( ( @OldDBCount = @NewDBCount ) )
BEGIN
EXEC [LAPTOP-BI4KLJGI].[OASIS].dbo.[CONV_Insert_ConversionSnapShot] @ExternalDB = @ExternalDB,
@TableName = @TableName

SET IDENTITY_INSERT [YOLO].[dbo].Assignment ON

INSERT INTO [LAPTOP-BI4KLJGI].[YOLO].[dbo].Assignment
( StaffingOrderGUID ,
EmployeeGUID ,
StaffingSupplierSiteGUID ,
PerformanceConfigChoiceID ,
Monday ,
Tuesday ,
Wednesday ,
Thursday ,
Friday ,
Saturday ,
Sunday ,
Note ,
ExternalID ,
ExternalDB ,
UserGUID ,
AssignmentID
)
SELECT SO.StaffingOrderGUID ,
E.EmployeeGUID ,
@DefaultStaffingSupplierSiteGUID ,
NULL/*Performance*/ ,
0 ,
0 ,
0 ,
0 ,
0 ,
0 ,
0 ,
A.jobDescrip ,
A.tj_jobnum ,
@ExternalDB ,
@CurrentUserGUID ,
A.tj_jobnum
FROM [LAPTOP-BI4KLJGI].[OASIS].dbo.joborder A
INNER JOIN #TotalOrderConvertedList SO ON A.New_Order_ID = SO.ExternalID
AND SO.Externaldb=@ExternalDB
INNER JOIN [LAPTOP-BI4KLJGI].[OASIS].dbo.employeedetail em ON a.tj_emplnum = em.te_ssn
INNER JOIN #TotalEmployeeConvertedList E ON em.te_id = E.ExternalID
AND E.ExternalDB IS NOT NULL
WHERE A.ToConvert = 1

SET IDENTITY_INSERT [YOLO].[dbo].Assignment OFF

IF ( @OldDBCount <> @NewDBCount )
BEGIN
SELECT 'Unconverted Assignment'
PRINT 'OrderNotConvert'
SELECT ta.OrderID ,
COUNT(*)
FROM joborder ta
left JOIN [LAPTOP-BI4KLJGI].[YOLO].[dbo].Assignment a ON a.externalID = ta.tj_jobnum
AND a.ExternalDB = @ExternalDB
inner JOIN #TotalOrderConvertedList SO ON tA.New_Order_ID = SO.ExternalID
AND so.ExternalDB = @ExternalDB
WHERE a.assignmentguid IS NULL
AND ta.ToConvert = 1
GROUP BY ta.OrderID

/*
SELECT ta.OrderID ,
COUNT(*) -- select count(*)
FROM joborder ta
left outer JOIN [LAPTOP-BI4KLJGI].[YOLO].[dbo].Assignment a ON a.externalID = ta.tj_jobnum
AND a.ExternalDB = 'CombinedRojen'
inner JOIN #TotalOrderConvertedList SO ON tA.New_Order_ID = SO.ExternalID
AND so.ExternalDB = 'CombinedRojen'
WHERE a.assignmentguid IS NULL
AND ta.ToConvert = 1
GROUP BY ta.OrderID

*/

PRINT 'EmployeeNotConvert'
SELECT em.te_id ,
COUNT(*)
FROM joborder ta
left outer JOIN [LAPTOP-BI4KLJGI].[YOLO].[dbo].Assignment a ON a.externalID = ta.tj_jobnum
AND a.ExternalDB = @ExternalDB
INNER JOIN [LAPTOP-BI4KLJGI].[OASIS].dbo.employeedetail em ON ta.tj_emplnum = em.te_ssn
inner JOIN #TotalEmployeeConvertedList E ON em.te_id = E.ExternalID
AND e.ExternalDB IS NOT NULL
WHERE a.assignmentguid IS NULL
AND ta.ToConvert = 1
GROUP BY em.te_id


/*
SELECT em.te_id ,
COUNT(*) -- select count(*)
FROM joborder ta
left outer JOIN [LAPTOP-BI4KLJGI].[YOLO].[dbo].Assignment a ON a.externalID = ta.tj_jobnum
AND a.ExternalDB = 'CombinedRojen'
INNER JOIN [LAPTOP-BI4KLJGI].[OASIS].dbo.employeedetail em ON ta.tj_emplnum = em.te_ssn
inner JOIN #TotalEmployeeConvertedList E ON em.te_id = E.ExternalID
AND e.ExternalDB IS NOT NULL
WHERE a.assignmentguid IS NULL
AND ta.ToConvert = 1
GROUP BY em.te_id

*/

SELECT @ErrorMessage = 'Error Assignment Conversion: OldDBCount-'
+ CONVERT(VARCHAR, @OldDBCount)
+ ' does not match with NewDBCount-'
+ CONVERT(VARCHAR, @NewDBCount)
+ '.' ,
@ErrorSeverity = 15
RAISERROR ( @ErrorMessage, @ErrorSeverity, 1 )
END

EXEC [LAPTOP-BI4KLJGI].[OASIS].dbo.[CONV_Insert_ConversionSnapShot] @ExternalDB = @ExternalDB,
@TableName = @TableName,
@NoOfRowsInserted = @NewDBCount,
@IsUpdateLog = 1
END
END TRY
BEGIN CATCH
DELETE css
FROM [LAPTOP-BI4KLJGI].[YOLO].[dbo].ConversionSnapShot css
WHERE css.TableName = @TableName
AND css.ExternalDB = @ExternalDB
SELECT @ErrorMessage = ERROR_MESSAGE() ,
@ErrorSeverity = ERROR_SEVERITY()
GOTO ConversionError
END CATCH
END






IF OBJECT_ID('Tempdb.[dbo].#TotalAssignmentConvertedList') IS NOT NULL
BEGIN
DROP TABLE Tempdb.[dbo].#TotalAssignmentConvertedList
END

select *
into #TotalAssignmentConvertedList
FROM [LAPTOP-BI4KLJGI].[YOLO].[dbo].Assignment
where ExternalDB = @ExternalDB



SELECT @TableName = '5.1.0 Assignment:AssignmentNode'
PRINT @TableName
IF NOT EXISTS ( SELECT *
FROM [LAPTOP-BI4KLJGI].[YOLO].[dbo].ConversionSnapShot css
WHERE css.TableName = @TableName
AND css.ExternalDB = @ExternalDB )
BEGIN
BEGIN TRY

SELECT @NewDBCount = COUNT(*) -- select count(*)
FROM #TotalAssignmentConvertedList a
INNER JOIN [LAPTOP-BI4KLJGI].[YOLO].[dbo].Node n ON a.StaffingSupplierSiteGUID = n.FKGUID
WHERE a.ExternalDB = @ExternalDB

/*
select count(*)
FROM #TotalAssignmentConvertedList a
INNER JOIN [LAPTOP-BI4KLJGI].[YOLO].[dbo].Node n ON a.StaffingSupplierSiteGUID = n.FKGUID
WHERE a.ExternalDB = 'CombinedRojen'
*/

SELECT @OldDBCount = COUNT(*) -- Select count(*)
FROM [LAPTOP-BI4KLJGI].[OASIS].dbo.joborder A
INNER JOIN [LAPTOP-BI4KLJGI].[OASIS].dbo.employeedetail em ON a.tj_emplnum = em.te_ssn
INNER JOIN [LAPTOP-BI4KLJGI].[OASIS].dbo.clientdetail c ON c.tc_clinum = A.tj_clientNo
WHERE A.ToConvert = 1
and c.toconvert = 1


/*
SELECT *
FROM #TotalAssignmentConvertedList a
INNER JOIN [LAPTOP-BI4KLJGI].[YOLO].[dbo].Node n ON a.StaffingSupplierSiteGUID = n.FKGUID
WHERE a.ExternalDB = 'CosmopolitianCS'

SELECT *
FROM [LAPTOP-BI4KLJGI].[OASIS].dbo.ASsignmentroot Ta
inner join dbo.EmployeeRoot er on er.AIdent = Ta.AIdent
WHERE Ta.ToConvert = 1
*/

IF ( ( @OldDBCount <> @NewDBCount ) )
BEGIN
SET @ErrorMessage = 'Error ' + @TableName
+ ': OldDBCount-'
+ CONVERT(VARCHAR, @OldDBCount)
+ ' does not match with NewDBCount-'
+ CONVERT(VARCHAR, @NewDBCount) + '.'
GOTO ConversionError
END
IF ( ( @OldDBCount = @NewDBCount ) )
BEGIN
EXEC [LAPTOP-BI4KLJGI].[OASIS].dbo.[CONV_Insert_ConversionSnapShot] @ExternalDB = @ExternalDB,
@TableName = @TableName

INSERT INTO [LAPTOP-BI4KLJGI].[YOLO].[dbo].AssignmentNode
( AssignmentGUID ,
NodeID
)
SELECT a.AssignmentGUID ,
n.NodeID
FROM #TotalAssignmentConvertedList a
INNER JOIN [LAPTOP-BI4KLJGI].[YOLO].[dbo].Node n ON a.StaffingSupplierSiteGUID = n.FKGUID
left join [LAPTOP-BI4KLJGI].[YOLO].[dbo].assignmentnode ann on ann.AssignmentGUID=a.AssignmentGUID
and ann.nodeid=n.nodeid
WHERE a.ExternalDB = @ExternalDB
and ann.AssignmentNodeguid is null

EXEC [LAPTOP-BI4KLJGI].[OASIS].dbo.[CONV_Insert_ConversionSnapShot] @ExternalDB = @ExternalDB,
@TableName = @TableName,
@NoOfRowsInserted = @NewDBCount,
@IsUpdateLog = 1
END
END TRY
BEGIN CATCH
DELETE css
FROM [LAPTOP-BI4KLJGI].[YOLO].[dbo].ConversionSnapShot css
WHERE css.TableName = @TableName
AND css.ExternalDB = @ExternalDB
SELECT @ErrorMessage = ERROR_MESSAGE() ,
@ErrorSeverity = ERROR_SEVERITY()
GOTO ConversionError
END CATCH
END







SELECT @TableName = '5.2.0 Assignment:AssignmentSchedule'
PRINT @TableName
IF NOT EXISTS ( SELECT *
FROM [LAPTOP-BI4KLJGI].[YOLO].[dbo].ConversionSnapShot css
WHERE css.TableName = @TableName
AND css.ExternalDB = @ExternalDB )
BEGIN
BEGIN TRY

SELECT @NewDBCount = COUNT(*) -- select *
FROM #TotalAssignmentConvertedList A
INNER JOIN [LAPTOP-BI4KLJGI].[OASIS].dbo.joborder TA ON A.ExternalID = TA.tj_jobnum
AND A.ExternalDB = @ExternalDB
INNER JOIN [LAPTOP-BI4KLJGI].[YOLO].[dbo].OrderSchedule OS ON A.StaffingOrderGUID = OS.StaffingOrderGUID
AND TA.ToConvert = 1


/*
select *
FROM #TotalAssignmentConvertedList A
INNER JOIN [LAPTOP-BI4KLJGI].[OASIS].dbo.joborder TA ON A.ExternalID = TA.tj_jobnum
AND A.ExternalDB = 'CombinedRojen'
INNER JOIN [LAPTOP-BI4KLJGI].[YOLO].[dbo].OrderSchedule OS ON A.StaffingOrderGUID = OS.StaffingOrderGUID
AND TA.ToConvert = 1

*/


SELECT @OldDBCount = COUNT(*) -- select *
FROM [LAPTOP-BI4KLJGI].[OASIS].dbo.joborder AR
inner join [LAPTOP-BI4KLJGI].[OASIS].dbo.Clientdetail cd on cd.tc_clinum = AR.tj_clientNo
inner join [LAPTOP-BI4KLJGI].[OASIS].dbo.employeedetail ed on ed.te_ssn = AR.tj_emplnum
WHERE AR.ToConvert = 1
and cd.toconvert = 1

IF ( ( @OldDBCount <> @NewDBCount ) )
BEGIN
SET @ErrorMessage = 'Error ' + @TableName
+ ': OldDBCount-'
+ CONVERT(VARCHAR, @OldDBCount)
+ ' does not match with NewDBCount-'
+ CONVERT(VARCHAR, @NewDBCount) + '.'
GOTO ConversionError
END
IF ( ( @OldDBCount = @NewDBCount ) )
BEGIN
EXEC [LAPTOP-BI4KLJGI].[OASIS].dbo.[CONV_Insert_ConversionSnapShot] @ExternalDB = @ExternalDB,
@TableName = @TableName

INSERT INTO [LAPTOP-BI4KLJGI].[YOLO].[dbo].AssignmentSchedule
( AssignmentGUID ,
StartDate ,
EndDate ,
OrderScheduleGUID
--, shiftname
)
SELECT A.AssignmentGUID ,
TA.tj_start ,
TA.tj_end ,
OS.OrderScheduleGUID
--, ta.Shift
FROM #TotalAssignmentConvertedList A
INNER JOIN [LAPTOP-BI4KLJGI].[OASIS].dbo.joborder TA ON A.ExternalID = TA.tj_jobnum
AND A.ExternalDB = @ExternalDB
INNER JOIN [LAPTOP-BI4KLJGI].[YOLO].[dbo].OrderSchedule OS ON A.StaffingOrderGUID = OS.StaffingOrderGUID
AND TA.ToConvert = 1

/*
SELECT A.AssignmentGUID ,
TA.StartDate ,
TA.EndDate ,
OS.OrderScheduleGUID,
ta.Shift
FROM #TotalAssignmentConvertedList A
INNER JOIN [LAPTOP-BI4KLJGI].[OASIS].dbo.AssignmentRoot TA ON A.ExternalID = TA.ItemID
AND A.ExternalDB = 'CosmopolitianCS'
INNER JOIN [LAPTOP-BI4KLJGI].[YOLO].[dbo].OrderSchedule OS ON A.StaffingOrderGUID = OS.StaffingOrderGUID
AND TA.ToConvert = 1
*/

EXEC [LAPTOP-BI4KLJGI].[OASIS].dbo.[CONV_Insert_ConversionSnapShot] @ExternalDB = @ExternalDB,
@TableName = @TableName,
@NoOfRowsInserted = @NewDBCount,
@IsUpdateLog = 1
END
END TRY
BEGIN CATCH
DELETE css
FROM [LAPTOP-BI4KLJGI].[YOLO].[dbo].ConversionSnapShot css
WHERE css.TableName = @TableName
AND css.ExternalDB = @ExternalDB
SELECT @ErrorMessage = ERROR_MESSAGE() ,
@ErrorSeverity = ERROR_SEVERITY()
GOTO ConversionError
END CATCH
END





SELECT @TableName = '5.3.1 Assignment:AssignmentRate:REG'
PRINT @TableName
IF NOT EXISTS ( SELECT *
FROM [LAPTOP-BI4KLJGI].[YOLO].[dbo].ConversionSnapShot css
WHERE css.TableName = @TableName
AND css.ExternalDB = @ExternalDB )
BEGIN
BEGIN TRY

SELECT @NewDBCount = COUNT(*)--select count(*)
FROM #TotalAssignmentConvertedList A
INNER JOIN [LAPTOP-BI4KLJGI].[OASIS].dbo.joborder TA ON A.ExternalID = TA.tj_jobnum
AND A.ExternalDB = @ExternalDB
AND TA.ToConvert = 1
INNER JOIN [LAPTOP-BI4KLJGI].[YOLO].[dbo].ConfigTransactionType CTT ON CTT.SystemName IN (
'Reg' )
INNER JOIN [LAPTOP-BI4KLJGI].[YOLO].[dbo].vConfigSystemChoiceProperty vcscp ON vcscp.category = 'RateFrequency'
AND vcscp.ChoiceCode = 'Recurring'
AND vcscp.Property = 'IsDefault'
INNER JOIN [LAPTOP-BI4KLJGI].[YOLO].[dbo].AssignmentSchedule S ON a.assignmentguid = S.assignmentguid
WHERE CTT.RootStaffingSupplierGUID = @RootStaffingSupplierGUID

/*
select count(*)
FROM #TotalAssignmentConvertedList A
INNER JOIN [LAPTOP-BI4KLJGI].[OASIS].dbo.joborder TA ON A.ExternalID = TA.tj_jobnum
AND A.ExternalDB = 'CombinedRojen'
AND TA.ToConvert = 1
INNER JOIN [LAPTOP-BI4KLJGI].[YOLO].[dbo].ConfigTransactionType CTT ON CTT.SystemName IN (
'Reg' )
INNER JOIN [LAPTOP-BI4KLJGI].[YOLO].[dbo].vConfigSystemChoiceProperty vcscp ON vcscp.category = 'RateFrequency'
AND vcscp.ChoiceCode = 'Recurring'
AND vcscp.Property = 'IsDefault'
INNER JOIN [LAPTOP-BI4KLJGI].[YOLO].[dbo].AssignmentSchedule S ON a.assignmentguid = S.assignmentguid
WHERE CTT.RootStaffingSupplierGUID = '0AE8551D-582E-41DF-B162-D97867E76DA4'
*/




--select count(*) -- 187,417
--FROM #TotalAssignmentConvertedList A
-- INNER JOIN [LAPTOP-BI4KLJGI].[OASIS].dbo.AssignmentRoot TA ON A.ExternalID = TA.ItemID
-- AND A.ExternalDB = 'CosmopolitianCS'
-- AND TA.ToConvert = 1
-- INNER JOIN [LAPTOP-BI4KLJGI].[YOLO].[dbo].ConfigTransactionType CTT ON CTT.SystemName IN (
-- 'Reg' )
-- INNER JOIN [LAPTOP-BI4KLJGI].[YOLO].[dbo].vConfigSystemChoiceProperty vcscp ON vcscp.category = 'RateFrequency'
-- AND vcscp.ChoiceCode = 'Recurring'
-- AND vcscp.Property = 'IsDefault'
-- INNER JOIN [LAPTOP-BI4KLJGI].[YOLO].[dbo].AssignmentSchedule S ON a.assignmentguid = S.assignmentguid
--WHERE CTT.RootStaffingSupplierGUID = '0AE8551D-582E-41DF-B162-D97867E76DA4'



SELECT @OldDBCount = COUNT(*) -- 187,417
FROM [LAPTOP-BI4KLJGI].[OASIS].dbo.joborder o ,
[LAPTOP-BI4KLJGI].[OASIS].[dbo].clientdetail cd,
[LAPTOP-BI4KLJGI].[OASIS].[dbo].employeedetail ed,
[LAPTOP-BI4KLJGI].[YOLO].[dbo].ConfigTransactionType CTT ,
[LAPTOP-BI4KLJGI].[YOLO].[dbo].vconfigsystemChoiceProperty CSC
WHERE CTT.SystemName IN ( 'Reg' )
AND CSC.category = 'RateFrequency'
AND CSC.ChoiceCode = 'Recurring'
and cd.tc_clinum = o.tj_clientNo
and ed.te_ssn = o.tj_emplnum
AND CTT.RootStaffingSupplierGUID = @RootStaffingSupplierGUID
AND o.ToConvert = 1 --and ((PayRate IS NOT NULL AND PayRate<> 0) OR ( BillRate IS NOT NULL AND BillRate <> 0))
AND cd.ToConvert = 1
/*


SELECT *
FROM [LAPTOP-BI4KLJGI].[OASIS].dbo.joborder o ,
[LAPTOP-BI4KLJGI].[OASIS].[dbo].clientdetail cd,
[LAPTOP-BI4KLJGI].[OASIS].[dbo].employeedetail ed,
[LAPTOP-BI4KLJGI].[YOLO].[dbo].ConfigTransactionType CTT ,
[LAPTOP-BI4KLJGI].[YOLO].[dbo].vconfigsystemChoiceProperty CSC
WHERE CTT.SystemName IN ( 'Reg' )
AND CSC.category = 'RateFrequency'
AND CSC.ChoiceCode = 'Recurring'
and cd.tc_clinum = o.tj_clientNo
and ed.te_ssn = o.tj_emplnum
AND CTT.RootStaffingSupplierGUID = @RootStaffingSupplierGUID
AND o.ToConvert = 1 --and ((PayRate IS NOT NULL AND PayRate<> 0) OR ( BillRate IS NOT NULL AND BillRate <> 0))
*/


IF ( ( @OldDBCount <> @NewDBCount ) )
BEGIN
SET @ErrorMessage = 'Error ' + @TableName
+ ': OldDBCount-'
+ CONVERT(VARCHAR, @OldDBCount)
+ ' does not match with NewDBCount-'
+ CONVERT(VARCHAR, @NewDBCount) + '.'
GOTO ConversionError
END
IF ( ( @OldDBCount = @NewDBCount ) )
BEGIN
EXEC [LAPTOP-BI4KLJGI].[OASIS].dbo.[CONV_Insert_ConversionSnapShot] @ExternalDB = @ExternalDB,
@TableName = @TableName

INSERT INTO [LAPTOP-BI4KLJGI].[YOLO].[dbo].AssignmentRate
( AssignmentGUID ,
ConfigTransactionTypeID ,
PayRate ,
BillRate ,
FrequencyConfigSystemChoiceID ,
AssignmentScheduleGUID
)
SELECT A.AssignmentGUID ,
CTT.ConfigTransactionTypeID ,
ISNULL(TA.tj_epr, 0) ,
ISNULL(TA.tj_cbr, 0) ,
vcscp.ConfigSystemChoiceID ,
s.assignmentscheduleguid
FROM #TotalAssignmentConvertedList A
INNER JOIN [LAPTOP-BI4KLJGI].[OASIS].dbo.joborder TA ON A.ExternalID = TA.tj_jobnum
AND A.ExternalDB = @ExternalDB
AND TA.ToConvert = 1
INNER JOIN [LAPTOP-BI4KLJGI].[YOLO].[dbo].ConfigTransactionType CTT ON CTT.SystemName IN (
'Reg' )
INNER JOIN [LAPTOP-BI4KLJGI].[YOLO].[dbo].vConfigSystemChoiceProperty vcscp ON vcscp.category = 'RateFrequency'
AND vcscp.ChoiceCode = 'Recurring'
AND vcscp.Property = 'IsDefault'
INNER JOIN [LAPTOP-BI4KLJGI].[YOLO].[dbo].AssignmentSchedule S ON a.assignmentguid = S.assignmentguid
WHERE CTT.RootStaffingSupplierGUID = @RootStaffingSupplierGUID
EXEC [LAPTOP-BI4KLJGI].[OASIS].dbo.[CONV_Insert_ConversionSnapShot] @ExternalDB = @ExternalDB,
@TableName = @TableName,
@NoOfRowsInserted = @NewDBCount,
@IsUpdateLog = 1
END
END TRY
BEGIN CATCH
DELETE css
FROM [LAPTOP-BI4KLJGI].[YOLO].[dbo].ConversionSnapShot css
WHERE css.TableName = @TableName
AND css.ExternalDB = @ExternalDB
SELECT @ErrorMessage = ERROR_MESSAGE() ,
@ErrorSeverity = ERROR_SEVERITY()
GOTO ConversionError
END CATCH
END




-------------------------------------------------- End --------------------------------------------------
PRINT 'StaffingOrder End'