USP_DATAFORMTEMPLATE_VIEW_MKTSEED

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@NAME	nvarchar(154)	INOUT
@ADDRESSBLOCK	nvarchar(300)	INOUT
@PHONENUMBER	nvarchar(100)	INOUT
@EMAILADDRESS	nvarchar(100)	INOUT

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTSEED]
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @NAME nvarchar(154) = null output,
  @ADDRESSBLOCK nvarchar(300) = null output,
  @PHONENUMBER nvarchar(100) = null output, 
  @EMAILADDRESS nvarchar(100) = null output
)
as
  begin

  set @DATALOADED = 0;

    select
      @DATALOADED = 1,
      @NAME = [MKTSEED].[NAME],
      @ADDRESSBLOCK = replace(dbo.[UFN_BUILDFULLADDRESS](NULL, [MKTSEED].[ADDRESSBLOCK], [MKTSEED].[CITY], [MKTSEED].[STATEID], [MKTSEED].[POSTCODE], [MKTSEED].[COUNTRYID]),nchar(13)+nchar(10),' '),
      @PHONENUMBER = [MKTSEED].[PHONENUMBER],
      @EMAILADDRESS = [MKTSEED].[EMAILADDRESS]
    from
      dbo.[MKTSEED]
    where 
      [MKTSEED].[ID] = @ID;

    return 0;
  end