UFN_PDACCOUNTCODEMAPWRITEOFFREASONCODES_NAMESTRING
Return
| Return Type |
|---|
| nvarchar(max) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_PDACCOUNTCODEMAPWRITEOFFREASONCODES_NAMESTRING(
@ID uniqueidentifier
)
returns nvarchar(max)
with execute as caller
as begin
declare @retString nvarchar(max)
if exists(select TOP 1 SUBTYPEID from dbo.PDACCOUNTCODEMAPPINGSUBTYPE where PDACCOUNTCODEMAPPINGID = @ID and ADDITIONALSUBTYPE=15 and SUBTYPEID='99999999-9999-9999-9999-999999999999')
select @retString = 'All reason codes'
else
begin
select @retString = isnull(@retString+', ','') + CODE + ' - ' + DESCRIPTION
from dbo.WRITEOFFREASONCODE
join dbo.PDACCOUNTCODEMAPPINGSUBTYPE on PDACCOUNTCODEMAPPINGSUBTYPE.SUBTYPEID = WRITEOFFREASONCODE.ID
where PDACCOUNTCODEMAPPINGSUBTYPE.PDACCOUNTCODEMAPPINGID = @ID and ADDITIONALSUBTYPE=15
order by CODE,DESCRIPTION
end
return @retString
end