USP_EMAIL_GETMERGEDATA

This stored procedure returns merge data for a view that is passed in as a parameter.

Parameters

Parameter	Parameter Type	Mode	Description
@MERGEDATAVIEWOBJECT	nvarchar(255)	IN

Definition

Copy



      CREATE procedure dbo.USP_EMAIL_GETMERGEDATA
      (
        @MERGEDATAVIEWOBJECT as nvarchar(255)
      )
      with execute as owner
      as

      begin       
        if object_id('dbo.' + @MERGEDATAVIEWOBJECT) is not null
        begin
          DECLARE    @MERGEDATAQUERY as nvarchar(500);
          SET @MERGEDATAQUERY = 'set nocount on; select * from dbo.' + @MERGEDATAVIEWOBJECT

          exec sp_executesql @MERGEDATAQUERY;
        end
      end