USP_NAMEFORMATFUNCTIONDETAILS_VALIDATEINITIAL

create procedure dbo.USP_NAMEFORMATFUNCTIONDETAILS_VALIDATEINITIAL(@NAMEFORMATFUNCTIONDETAILS xml)
as
begin
    declare @INVALID_NAMEFORMATFIELDID uniqueidentifier = null;

    select
        top 1 @INVALID_NAMEFORMATFIELDID = DETAILS.NAMEFORMATFIELDID
    from dbo.UFN_NAMEFORMATFUNCTION_GETDETAILS_FROMITEMLISTXML(@NAMEFORMATFUNCTIONDETAILS) DETAILS
    inner join NAMEFORMATFIELD
        on DETAILS.NAMEFORMATFIELDID = NAMEFORMATFIELD.ID
    where DETAILS.INITIAL = 1 and NAMEFORMATFIELD.ALLOWINITIAL = 0;

    if not @INVALID_NAMEFORMATFIELDID is null
    begin
        declare @ERRMSG nvarchar(100);
        select 
            @ERRMSG = 'You cannot select Initial for a ' + DISPLAY + ' field' 
        from dbo.NAMEFORMATFIELD 
        where ID = @INVALID_NAMEFORMATFIELDID;

        raiserror(@ERRMSG, 13, 1);        
    end
end