With
Cteprom
as
(
select p.GoodsId, pw.WarehouseId, p.PromotionGoodsTimeBegin, p.PromotionGoodsTimeEnd
from PromotionGoods p with(NoLock) join PromotionGroup pg with(NoLock) on p.PromotionGroupId=pg.PromotionGroupId
join PromotionWarehouse pw with(NoLock) on pw.PromotionGroupId=p.PromotionGroupId
where p.GoodsId in (7815)
and pw.WarehouseId in (999)
),

CteprodAMD
as
(
select g.GoodsId, g.GoodsName, c.WarehouseId, SUM(c.Quantity) QuaCredit			
from Goods g with(NoLock), CreditView c with(NoLock) , Cteprom
where g.Goodsid=c.Goodsid
and Cteprom.GoodsId=c.GoodsId
and Cteprom.WarehouseId=c.WarehouseId
and c.Datex between Cteprom.PromotionGoodsTimeBegin and Cteprom.PromotionGoodsTimeEnd
group by g.GoodsId, g.GoodsName, c.WarehouseId
),

Cteprod
as
(
select g.GoodsId, g.GoodsName, c.WarehouseId, SUM(c.Quantity) QuaCredit, c.Datex			
from Goods g with(NoLock), CreditView c with(NoLock), Cteprom
where g.Goodsid=c.Goodsid
and Cteprom.GoodsId=c.GoodsId
and Cteprom.WarehouseId=c.WarehouseId
and c.Datex between DATEADD (week, -1, Cteprom.PromotionGoodsTimeBegin) and DATEADD (week, -1, Cteprom.PromotionGoodsTimeEnd)
group by g.GoodsId, g.GoodsName, c.WarehouseId, c.Datex
)

select *
from CteprodAMD join Cteprod on CteprodAMD.GoodsId=Cteprod.GoodsId
join Cteprom on Cteprod.GoodsId=Cteprom.GoodsId

case 
when
Cteprod.Datex between Cteprom.PromotionGoodsTimeBegin and Cteprom.PromotionGoodsTimeEnd then DATEADD (week, -1, Cteprom.PromotionGoodsTimeBegin) 
and DATEADD (week, -1, Cteprom.PromotionGoodsTimeEnd) 
end

between

between

then