Select
      p.ProductID,
      p.PrName,
      ISNULL(RestBegin.A1, 0 ) As KolProdBegin, 
      ISNULL(RestCome.A2, 0 ) As KolProdCome,
      ISNULL(RestOutCome.A3, 0 ) As KolProdOutCome,
      ISNULL(RestBegin.A4, 0 ) As KolProdEnd

From
SP_Product p 
LEFT JOIN
 ( Select ProductID, Sum(Rest ) As A1 From REG_ProductMove Where SkladID = @SkladID and RegData <@D1  Group by ProductID) As RestBegin on p.ProductID = RestBegin.ProductID

LEFT JOIN
 ( Select ProductID, Sum(Rest ) As A2 From REG_ProductMove Where SkladID = @SkladID and RegData >=@D1 And RegData <=@D2 And CO =  1  Group by ProductID  ) As RestCome on
p.ProductID = RestCome.ProductID
LEFT JOIN
 ( Select ProductID, Sum(Rest ) As A3 From REG_ProductMove Where SkladID = @SkladID and RegData >=@D1 And RegData <=@D2 And CO =  0  Group by ProductID  ) As RestOutCome on
p.ProductID = RestOutCome.ProductID
LEFT JOIN
 ( Select ProductID, Sum(Rest ) As A4 From REG_ProductMove Where SkladID = @SkladID and RegData <=@D2 Group by ProductID ) As RestEnd on 
p.ProductID = RestEnd.ProductID

Order by
          p.PrName

Create table #report_tmp (ProductID, A1, A2, A3, A4)

Insert into #report_tmp (ProductID, A1, A2, A3, A4)
Select ProductID, Sum(Rest ) As A1,  0 ,  0 ,  0  From REG_ProductMove Where SkladID = @SkladID and RegData <@D1 Group by ProductID

Insert into #report_tmp (ProductID, A1, A2, A3, A4)
Select ProductID,  0 , Sum(Rest ) As A2,  0 ,  0   From REG_ProductMove Where SkladID = @SkladID and RegData >=@D1 And RegData <=@D2 And CO =  1   Group by ProductID

Insert into #report_tmp (ProductID, A1, A2, A3, A4)
Select ProductID,  0 ,  0 ,  Sum(Rest ) As A3,  0  From REG_ProductMove Where SkladID = @SkladID and RegData >=@D1 And RegData <=@D2 And CO =  0   Group by ProductID

Insert into #report_tmp (ProductID, A1, A2, A3, A4)
Select ProductID,  0 , 0 , 0 , Sum(Rest ) As A4 From REG_ProductMove Where SkladID = @SkladID and RegData <=@D2 Group by ProductID


Select
      p.ProductID,
      p.PrName,
      Rest.KolProdBegin ,
      Rest.KolProdCome,
      Rest.KolProdOutCome,
      Rest.KolProdEnd
From
SP_Product p 
Inner Join (Select ProductID, Sum(A1) As KolProdBegin , Sum(A2) As KolProdCome, Sum(A3) As KolProdOutCome, Sum(A4) As KolProdEnd From #report_tmp  Group by ProductID) As Rest on p.ProductID = Rest.ProductID


Drop table #report_tmp 

declare @d1 smalldatetime 
declare @d2 smalldatetime 
Select @d1 = '2011-11-24', @d2 = '2011-11-24'

declare @d1 smalldatetime 
declare @d2 smalldatetime 
Select @d1 = convert(smalldatetime, '2011-11-24', 101 ), @d2 = convert(smalldatetime, '2011-11-24', 101 )

Exec Itog2 @d1, @d2 , @IDSklad = чего то там