Hot_fix_tính diện tích trống - Luc Tran Van, 03/11/2022 11:35 AM
ALTER PROCEDURE [dbo].[BUD_AREA_ByMasterID]
@BUILDING_ID varchar(15)
AS
BEGIN
SELECT A.*,
A.FLOOR_AREA- (A.INTERNAL_AREA + A.UTILZED_AREA) AS DIENTICH_CONLAI
FROM BUD_AREA_DT A
WHERE A.BUILD_ID= @BUILDING_ID
END