USP_DATAFORMTEMPLATE_ADD_FILEVIEWDATA

create procedure dbo.USP_DATAFORMTEMPLATE_ADD_FILEVIEWDATA
(   
    @ID uniqueidentifier = null output,   
    @CHANGEAGENTID uniqueidentifier = null,
    @TEMPID uniqueidentifier = null,
      @SESSIONID nvarchar(36) = null,
    @MAXRECORDS int = 0
)
as

set nocount on;

if @ID is null
    set @ID = newid()

if @CHANGEAGENTID is null  
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

declare @CURRENTDATE datetime
set @CURRENTDATE = getdate()

begin try  

  declare @TEMP table (BinaryData image, TextData ntext)
  insert into @TEMP
  exec [dbo].[spTempDataFetch] @TEMPID    

  declare @XMLDATA xml
  set @XMLDATA = (select top 1 TEXTDATA from @TEMP)

  declare @XMLTOADD xml
  set @XMLTOADD = (select @XMLDATA.query('/FileViews/Fl[@SID=sql:variable("@SESSIONID")]'))

  if @XMLTOADD is not null
    exec dbo.USP_FILEVIEWDATA_ADDFILEVIEW @ID, @CHANGEAGENTID, @XMLTOADD, @MAXRECORDS


end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0