Function - udf_arch_PoDetailDesc

Properties

Property	Value
Name	udf_arch_PoDetailDesc
Schema	dbo
Function Type	Scalar
Deterministic	False
Is Encrypted	False
Ansi Nulls Status	True
Quoted Identifier Status	True
Description

Parameters

Name	Data Type	Direction	Description
@isn	int(10, 0)	Input

Parent Dependencies (objects that udf_arch_PoDetailDesc depends on)

Name	Type
FIP_PO_DET_DET_DESCRIPTION	Table
arch_PurchaseOrderLines	View

Child Dependencies (objects that depend on udf_arch_PoDetailDesc)

Name

Type

Extended Properties

Object

Property

Value

DDL

/****** Object: UserDefinedFunction [dbo].[udf_arch_PoDetailDesc] Script Date: 03/09/2017 16:47:10 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE FUNCTION [dbo].[udf_arch_PoDetailDesc]
    (
    @isn INT
    )
RETURNS varchar(6000)
AS
BEGIN
    DECLARE @DetailDesc varchar(6000)
    SELECT
       @DetailDesc = COALESCE(@DetailDesc + ' ', '') + DET_DESCRIPTION
     FROM FIP_PO_DET_DET_DESCRIPTION
     WHERE ISN_FIP_PO_DET = @isn
     ORDER BY cnxarraycolumn
    RETURN @DetailDesc
END