set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go




ALTER PROCEDURE [dbo].[STPListWareHouse] 
	@GoodSysCode int=0
AS
if @GoodSysCode=0
SELECT     SysCode, WareHouseName as Title
FROM         WareHouseTbl
else
SELECT     WareHouseTbl.WareHouseName AS Title, derivedtbl_1.qty, WareHouseTbl.SysCode
FROM         WareHouseTbl LEFT OUTER JOIN
                          (SELECT     TOP (100) PERCENT WareHouse, SUM(NetQuantity) AS qty
FROM         VWInvoiceDetailComplete
WHERE     (GoodSysCode = @GoodSysCode)
GROUP BY WareHouse) AS derivedtbl_1 ON WareHouseTbl.SysCode = derivedtbl_1.WareHouse
ORDER BY derivedtbl_1.qty DESC