spMFUpdateTable_ObjIDs_GetGroupedList

Signature

EXEC dbo.spMFUpdateTable_ObjIDs_GetGroupedList
    @ObjIds_FieldLenth = 3900,
    @Debug = 0;

Returns

INT: 1 on success; -1 on error.

Parameters

@ObjIds_FieldLenth

• Type: SMALLINT

• Required: No (default = 3900)

• Description: Size of each group’s CSV text field.

@Debug

• Type: SMALLINT

• Required: No (default = 0)

• Description: Debug level. - 1 = Standard Debug Mode - 101 = Advanced Debug Mode

Purpose

The purpose of this procedure is to group source records into batches and compile a list of OBJIDs in CSV format to pass to spMFUpdateTable

Examples

IF OBJECT_ID('tempdb..#ObjIdList') IS NOT NULL DROP TABLE #ObjIdList;
CREATE TABLE #ObjIdList ( [ObjId] INT  PRIMARY KEY )

INSERT #ObjIdList ( ObjId )
SELECT ObjID
FROM MFYourTable

EXEC spMFUpdateTable_ObjIDS_GetGroupedList

Changelog

Date	Author	Description
2021-05-10	LC	prevent group list process when objid count < 500
2021-03-10	LC	set default field length to 3900
2020-12-11	LC	fix bug related to number of objids in list
2020-09-08	Lc	resolve number of objids in batch
2020-04-08	LC	Resolve issue with #objidlist not exist
2019-08-30	JC	Added documentation
2017-06-08	AC	Change default size of @ObjIds_FieldLenth