USP_FENXT_ADDACCOUNTSTRUCTURESTART

            create procedure dbo.USP_FENXT_ADDACCOUNTSTRUCTURESTART
                (
                @PDACCOUNTSYSTEMID uniqueidentifier
                )
            as

                declare @CHANGEAGENTID uniqueidentifier;
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                declare @CURRENTDATE datetime;
                    set @CURRENTDATE = getdate();

                update dbo.FENXTACCOUNTSTRUCTURE 
                set SEGMENTSTART = (select isnull(sum(SEGMENTLENGTH) +count(case SEPARATOR when '' then null else 1 end),0)+1 
                                    from dbo.FENXTACCOUNTSTRUCTURE as PREVIOUSSEGMENTS 
                                    WHERE PREVIOUSSEGMENTS.SEGMENTID < FENXTACCOUNTSTRUCTURE.SEGMENTID 
                                    and PREVIOUSSEGMENTS.PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID),
                    CHANGEDBYID = @CHANGEAGENTID,
                    DATECHANGED = @CURRENTDATE
                where PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID;