기본

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

/*------------------------------------------------------------------
* Object Name : dbo.sp_Master_List
* Description : 1.호출페이지
* Example : EXEC sp_Master_List 1, 5,'',''
Modified Date Author Description
============= =========== ===========
2009-01-01 함영진 CREATE
-------------------------------------------------------------------*/
CREATE PROCEDURE [dbo].[sp_Master_List]
@ACD AS CHAR(3) =''
,@NCD AS CHAR(2) =''
,@CCD AS varchar(5) ='' -- 코드
,@HCD AS char(10) =''
AS

SET NOCOUNT ON;
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

SELECT
,tha.AM
,thn.NM
,thc.CM
,thm.HCD + ' ' + thm.Addr
,CONVERT(varchar(10),thm.DT,120) AS DT
,thm.UserID
FROM dbo.A tha
LEFT OUTER JOIN dbo.V thn
ON tha.ACD = thn.ACD
LEFT OUTER JOIN dbo.C thc
ON thn.NCD = thc.NCD
LEFT OUTER JOIN dbo.GG thm
ON thc.CCD =thm.CCD
WHERE tha.ACD= CASE @ACD WHEN '' THEN tha.ACD ELSE @ACD END
AND thn.NCD = CASE @NCD WHEN '' THEN thn.NCD ELSE @NCD END
AND thm.CD = CASE @CCD WHEN '' THEN thm.CCD ELSE @CCD END
AND thm.HCD = CASE @HCD WHEN '' THEN thm.HCD ELSE @HCD END
AND thm.YN = 'N';