USP_FAFADDRESSBOOKCATEGORYCODE_NORMALIZESEQUENCENUMBERS

Used to reset the sequence for table entries in the "FAF Addressbook Category" code table.

Parameters

Parameter	Parameter Type	Mode	Description
@CHANGEAGENTID	uniqueidentifier	IN	The ID of the change agent resetting the sequence.

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  4/29/2010 7:21:55 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.6.1444.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE procedure dbo.USP_FAFADDRESSBOOKCATEGORYCODE_NORMALIZESEQUENCENUMBERS
(
@CHANGEAGENTID uniqueidentifier = NULL
)
as

if @CHANGEAGENTID IS NULL
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

with NEWNUMS(ROWNUM, ID) as
(
    select row_number() over(order by SEQUENCE), ID
    from dbo.FAFADDRESSBOOKCATEGORYCODE
)
update dbo.FAFADDRESSBOOKCATEGORYCODE
set FAFADDRESSBOOKCATEGORYCODE.SEQUENCE = NEWNUMS.ROWNUM,
    FAFADDRESSBOOKCATEGORYCODE.CHANGEDBYID=@CHANGEAGENTID,
    FAFADDRESSBOOKCATEGORYCODE.DATECHANGED=GETDATE()
from dbo.FAFADDRESSBOOKCATEGORYCODE
    inner join NEWNUMS
    on FAFADDRESSBOOKCATEGORYCODE.ID = NEWNUMS.ID;

if @@error<>0 return 1;

return 0;