UFN_BALANCINGENTRY_GETELEMENTSDEBITTO

CREATE function dbo.UFN_BALANCINGENTRY_GETELEMENTSDEBITTO(@BALANCINGENTRYID uniqueidentifier,@BALANCINGENTRYTYPECODE tinyint)
returns @BALANCINGENTRYDEBITTO table
  (ID uniqueidentifier,
  BALANCINGENTRYTYPECODE tinyint,
  DATAELEMENTID uniqueidentifier,
  ACCOUNTSTRUCTUREID uniqueidentifier)
with execute as caller
as begin
  insert into @BALANCINGENTRYDEBITTO(ID, BALANCINGENTRYTYPECODE, DATAELEMENTID, ACCOUNTSTRUCTUREID)
  select unPvt.ID, BALANCINGENTRYTYPECODE, DATAELEMENTID, PDACCOUNTSEGMENTVALUE.PDACCOUNTSTRUCTUREID
  from
  (select ID, BALANCINGENTRYTYPECODE, DATAELEMENT1ID, DATAELEMENT2ID, DATAELEMENT3ID, DATAELEMENT4ID, DATAELEMENT5ID, DATAELEMENT6ID, DATAELEMENT7ID, DATAELEMENT8ID, DATAELEMENT9ID, DATAELEMENT10ID,
      DATAELEMENT11ID, DATAELEMENT12ID, DATAELEMENT13ID, DATAELEMENT14ID, DATAELEMENT15ID, DATAELEMENT16ID, DATAELEMENT17ID, DATAELEMENT18ID, DATAELEMENT19ID, DATAELEMENT20ID,
      DATAELEMENT21ID, DATAELEMENT22ID, DATAELEMENT23ID, DATAELEMENT24ID, DATAELEMENT25ID, DATAELEMENT26ID, DATAELEMENT27ID, DATAELEMENT28ID, DATAELEMENT29ID, DATAELEMENT30ID
  from dbo.BALANCINGENTRYELEMENT
  where BALANCINGENTRYID = @BALANCINGENTRYID
  AND BALANCINGENTRYTYPECODE = 3) p
  unpivot
  (DATAELEMENTID for dColumn in
      (DATAELEMENT1ID, DATAELEMENT2ID, DATAELEMENT3ID, DATAELEMENT4ID, DATAELEMENT5ID, DATAELEMENT6ID, DATAELEMENT7ID, DATAELEMENT8ID, DATAELEMENT9ID, DATAELEMENT10ID,
      DATAELEMENT11ID, DATAELEMENT12ID, DATAELEMENT13ID, DATAELEMENT14ID, DATAELEMENT15ID, DATAELEMENT16ID, DATAELEMENT17ID, DATAELEMENT18ID, DATAELEMENT19ID, DATAELEMENT20ID,
      DATAELEMENT21ID, DATAELEMENT22ID, DATAELEMENT23ID, DATAELEMENT24ID, DATAELEMENT25ID, DATAELEMENT26ID, DATAELEMENT27ID, DATAELEMENT28ID, DATAELEMENT29ID, DATAELEMENT30ID)) as unPvt
  inner join dbo.PDACCOUNTSEGMENTVALUE ON unPvt.DATAELEMENTID = PDACCOUNTSEGMENTVALUE.ID    
  return;
end