Код

		|--Bookmark Lookup(BOOKMARK: ([Bmk1001]), OBJECT: ([TorgSB_N].[dbo].[_1SJOURN] AS [J]))	1	4	3	Bookmark Lookup	Bookmark Lookup	BOOKMARK: ([Bmk1001]), OBJECT: ([TorgSB_N].[dbo].[_1SJOURN] AS [J])	[J].[IDDOCDEF], [J].[DATE_TIME_IDDOC]	1.0	6.2500001E-3	0.0000011	300	0.03251927	[RegP].[SP2654], [RegP].[SP1131], [RegP].[SP1132], [RegP].[SP2706], [RegP].[SP2707], [RegP].[SP3597], [RegP].[SP3601], [RegP].[SP1133], [RegP].[SP2655], [RegP].[SP2799], [RegP].[SP3286], [RegP].[SP3665], [J].[IDDOCDEF], [J].[DATE_TIME_IDDOC]	[NULL]	PLAN_ROW	0	1.0
		     |--Nested Loops(Left Outer Join, OUTER REFERENCES: ([RegP].[SP1132]))	1	5	4	Nested Loops	Left Outer Join	OUTER REFERENCES: ([RegP].[SP1132])	[NULL]	1.0	0.0	0.00001254	205	2.6268167E-2	[RegP].[SP2654], [RegP].[SP1131], [RegP].[SP1132], [RegP].[SP2706], [RegP].[SP2707], [RegP].[SP3597], [RegP].[SP3601], [RegP].[SP1133], [RegP].[SP2655], [RegP].[SP2799], [RegP].[SP3286], [RegP].[SP3665], [Bmk1001]	[NULL]	PLAN_ROW	0	1.0
			    |--Nested Loops(Left Semi Join, WHERE: ([RegP].[SP1131]=[Doc].[SP249]))	1	6	5	Nested Loops	Left Semi Join	WHERE: ([RegP].[SP1131]=[Doc].[SP249])	[NULL]	1.0	0.0	2.7815544E-4	175	0.01335981	[RegP].[SP2654], [RegP].[SP1131], [RegP].[SP1132], [RegP].[SP2706], [RegP].[SP2707], [RegP].[SP3597], [RegP].[SP3601], [RegP].[SP1133], [RegP].[SP2655], [RegP].[SP2799], [RegP].[SP3286], [RegP].[SP3665]	[NULL]	PLAN_ROW	0	1.0
			    |    |--Clustered Index Seek(OBJECT: ([TorgSB_N].[dbo].[RG1130].[PK_RG1130] AS [RegP]), SEEK: ([RegP].[PERIOD]='Apr  1 2008 12:00AM'),  WHERE: ([RegP].[SP1133]>0.00000) ORDERED FORWARD)	1	7	6	Clustered Index Seek	Clustered Index Seek	OBJECT: ([TorgSB_N].[dbo].[RG1130].[PK_RG1130] AS [RegP]), SEEK: ([RegP].[PERIOD]='Apr  1 2008 12:00AM'),  WHERE: ([RegP].[SP1133]>0.00000) ORDERED FORWARD	[RegP].[SP2654], [RegP].[SP1131], [RegP].[SP1132], [RegP].[SP2706], [RegP].[SP2707], [RegP].[SP3597], [RegP].[SP3601], [RegP].[SP1133], [RegP].[SP2655], [RegP].[SP2799], [RegP].[SP3286], [RegP].[SP3665]	1.0	6.3284999E-3	8.0320715E-5	175	6.4088209E-3	[RegP].[SP2654], [RegP].[SP1131], [RegP].[SP1132], [RegP].[SP2706], [RegP].[SP2707], [RegP].[SP3597], [RegP].[SP3601], [RegP].[SP1133], [RegP].[SP2655], [RegP].[SP2799], [RegP].[SP3286], [RegP].[SP3665]	[NULL]	PLAN_ROW	0	1.0
			    |    |--Clustered Index Seek(OBJECT: ([TorgSB_N].[dbo].[DT239].[PK_DT239] AS [Doc]), SEEK: ([Doc].[IDDOC]='  D4D2CEE') ORDERED FORWARD)	1	8	6	Clustered Index Seek	Clustered Index Seek	OBJECT: ([TorgSB_N].[dbo].[DT239].[PK_DT239] AS [Doc]), SEEK: ([Doc].[IDDOC]='  D4D2CEE') ORDERED FORWARD	[Doc].[SP249]	26.617744	6.3284999E-3	1.0785937E-4	62	6.6520781E-3	[Doc].[SP249]	[NULL]	PLAN_ROW	0	3.0
			    |--Index Seek(OBJECT: ([TorgSB_N].[dbo].[_1SJOURN].[IDDOC] AS [J]), SEEK: ([J].[IDDOC]=right(Convert([RegP].[SP1132]), 9)) ORDERED FORWARD)	1	12	5	Index Seek	Index Seek	OBJECT: ([TorgSB_N].[dbo].[_1SJOURN].[IDDOC] AS [J]), SEEK: ([J].[IDDOC]=right(Convert([RegP].[SP1132]), 9)) ORDERED FORWARD	[Bmk1001]	1.0	6.3284999E-3	7.9605998E-5	38	1.2895818E-2	[Bmk1001]	[NULL]	PLAN_ROW	0	3.0 

Код

SELECT
	  RegP.sp2654 as Firma,
     RegP.sp1131 AS Tovar,
	  RegP.sp1132 as PrihDoc,
	  RegP.sp2706 as Status,
	  RegP.sp2707 as Contragent,
	  RegP.sp3597 as Postav,
	  RegP.sp3601 as Postavka,
     RegP.sp1133  AS Ostat,
     RegP.sp2655  AS Stoim,
     RegP.sp2799  AS ProdStoim,
     RegP.sp3286  AS NDS,
     RegP.sp3665  AS NP,
	  (CASE J.IDDocDef
			WHEN 239 THEN 'Перемещение'
			WHEN 5598 THEN 'ВводОстатковТМЦ'
			WHEN 434 THEN 'ПриходнаяНакладная'
			WHEN 657 THEN 'ВводОстатковРеализации'
			WHEN 1160 THEN 'ВводПартийТоваров'
			WHEN 6272 THEN 'ВводОстатковВМагазинах'
			WHEN 493 THEN 'ПриходнаяРеализатора'
			WHEN 3831 THEN 'ОприходованиеИзлишков'
		ELSE ''
		END) as VidDoc,
	  J.DATE_TIME_IDDOC as Partia
  FROM
     rg1130 as RegP

	LEFT JOIN _1sjourn J (NOLOCK) ON J.IDDOC = right(RegP.sp1132, 9)
 WHERE RegP.sp1133 >0
			AND RegP.sp1131 in (SELECT Doc.sp249 from dt239 Doc (nolock)
				Where Doc.IDDoc = '  D4D2CEE')
			AND Period = '20080401'
 ORDER BY RegP.sp1131, J.DATE_TIME_IDDOC, RegP.sp1132 

Код

$ВидДокументПредставление 

Код

FROM $РегистрИтоги.ПартииТоваров as РегП 

Код

LEFT JOIN _1sjourn J (NOLOCK) ON J.IDDOC = right($РегП.ПрихДокумент, 9)