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