USP_PDACCOUNTCODEMAPOFFICE_MAPPINGEXISTS
Returns a bit indicating if a mapping exists given an OFFICEID.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @OFFICEID | int | IN |
Definition
Copy
create procedure dbo.USP_PDACCOUNTCODEMAPOFFICE_MAPPINGEXISTS(@OFFICEID int=0)
as
begin
declare @MAPPINGEXISTS bit;
set @MAPPINGEXISTS = 0;
select
@MAPPINGEXISTS = 1
from
dbo.PDACCOUNTCODEMAPPING
where
OFFICEID = @OFFICEID
select @MAPPINGEXISTS
end