Shadow76
7/3/2015 - 10:54 AM

Тестирование поиска по НПД

Тестирование поиска по НПД

USE [Search_LAW]
GO

DECLARE
@hashList1 AS dbo.HashCodeTableParameter,
@hashList2 AS dbo.HashCodeTableParameter

INSERT INTO @hashList1 VALUES (8924532708692520173)
INSERT INTO @hashList1 VALUES (6560177503274676528)
INSERT INTO @hashList2 VALUES (8924532708692520173)

EXEC  [dbo].[Search]
	@hashList = @hashList1,
	@hashListUSS = @hashList2,
	@hashQuery = 3131570513076755325,
	@csvModuleIdList = N'81,97,99',
	@sortTypeID = 0,
	@statusIDFilter = 0,
	@minPosition = 1,
	@maxPosition = 150,
	@pubId = 11,
	@searchFlag = 8254,
	@partid = 1