USP_RESERVATIONSECURITYDEPOSITWITHHOLDREASONCODE_NORMALIZESEQUENCENUMBERS
Used to reset the sequence for table entries in the "Reservation Security Deposit Withhold Reason" 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: 9/30/2015 1:01:26 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.153.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE procedure dbo.USP_RESERVATIONSECURITYDEPOSITWITHHOLDREASONCODE_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.RESERVATIONSECURITYDEPOSITWITHHOLDREASONCODE
)
update dbo.RESERVATIONSECURITYDEPOSITWITHHOLDREASONCODE
set RESERVATIONSECURITYDEPOSITWITHHOLDREASONCODE.SEQUENCE = NEWNUMS.ROWNUM,
RESERVATIONSECURITYDEPOSITWITHHOLDREASONCODE.CHANGEDBYID=@CHANGEAGENTID,
RESERVATIONSECURITYDEPOSITWITHHOLDREASONCODE.DATECHANGED=GETDATE()
from dbo.RESERVATIONSECURITYDEPOSITWITHHOLDREASONCODE
inner join NEWNUMS
on RESERVATIONSECURITYDEPOSITWITHHOLDREASONCODE.ID = NEWNUMS.ID;
if @@error<>0 return 1;
return 0;