spTransactions_InsertCustomTransaction

CREATE procedure dbo.spTransactions_InsertCustomTransaction(
    @TransactionTypeGuid uniqueidentifier,
    @ClientsID int,
    @UserID int,
    @xmlData ntext)

as
    declare @ret int
    set @ret=0

    if (@UserID is null) or (@UserID<1)
        set @UserID = null

    if (datalength(@xmlData) < 8)
    begin
       raiserror ('Unable to insert custom transaction - CustomTransactions.Data cannot be a zero-length string and must be well formed XML',16,1)
       return 0
    end

    if @UserID=0 set @UserID=NULL

    insert into dbo.CustomTransactions
        (
        TransactionTypeGuid,
        ClientsID, 
        AddedByUserID, 
        Data
        ) 
    values
        (
        @TransactionTypeGuid,
        @ClientsID, 
        @UserID, 
        @xmlData)

    if @@error =0 return @@identity
    else return 0