USP_DATAFORMTEMPLATE_VIEW_MKTPACKAGECREATIVE

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@VENDORID	uniqueidentifier	INOUT
@VENDOR	nvarchar(154)	INOUT
@CREATIVETYPE	nvarchar(100)	INOUT
@NAME	nvarchar(100)	INOUT
@DESCRIPTION	nvarchar(255)	INOUT
@COST	money	INOUT
@COSTDISTRIBUTIONMETHODCODE	tinyint	INOUT
@COSTDISTRIBUTIONMETHOD	nvarchar(50)	INOUT
@FILEURL	UDT_WEBADDRESS	INOUT
@FILE	varbinary	INOUT
@FILENAME	nvarchar(255)	INOUT
@SITE	nvarchar(1024)	INOUT
@BASECURRENCYID	uniqueidentifier	INOUT
@NUMPACKAGES	int	INOUT
@CURRENCY	nvarchar(110)	INOUT

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTPACKAGECREATIVE]
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @VENDORID uniqueidentifier = null output,
  @VENDOR nvarchar(154) = null output,
  @CREATIVETYPE nvarchar(100) = null output,
  @NAME nvarchar(100) = null output,
  @DESCRIPTION nvarchar(255) = null output,
  @COST money = null output,
  @COSTDISTRIBUTIONMETHODCODE tinyint = null output,
  @COSTDISTRIBUTIONMETHOD nvarchar(50) = null output,
  @FILEURL dbo.[UDT_WEBADDRESS] = null output,
  @FILE varbinary(max) = null output,
  @FILENAME nvarchar(255) = null output,
  @SITE nvarchar(1024) = null output,
  @BASECURRENCYID uniqueidentifier = null output,
  @NUMPACKAGES integer = null output,
  @CURRENCY nvarchar(110) = null output
)
as
  set nocount on;

  set @DATALOADED = 0;

  declare @CREATIVEID uniqueidentifier;

  -- the package creative data list includes the creative associated with the package via MKTPACKAGE.CREATIVEID, too, using MKTPACKAGE.ID as its ID

  -- if the ID passed in turns out to be bogus, assume it's MKTPACKAGE.ID and they're looking for MKTPACKAGE.CREATIVEID


  if exists (select top 1 1 from dbo.[MKTPACKAGECREATIVE] where [ID] = @ID)
    select @CREATIVEID = [CREATIVEID] from dbo.[MKTPACKAGECREATIVE] where [ID] = @ID;
  else
    select @CREATIVEID = [CREATIVEID] from dbo.[MKTPACKAGE] where [ID] = @ID;

  if not @CREATIVEID is null
    select
      @DATALOADED = 1,
      @VENDORID = [VENDORID],
      @VENDOR = [VENDOR],
      @CREATIVETYPE = [CREATIVETYPE],
      @NAME = [NAME],
      @DESCRIPTION = [DESCRIPTION],
      @SITE = [SITE],
      @COST = [COST],
      @COSTDISTRIBUTIONMETHODCODE = [COSTDISTRIBUTIONMETHODCODE],
      @COSTDISTRIBUTIONMETHOD = [COSTDISTRIBUTIONMETHOD],
      @FILEURL = [FILEURL],
      @FILE = [FILE],
      @FILENAME = [FILENAME],
      @BASECURRENCYID = [BASECURRENCYID],
      @NUMPACKAGES = [NUMPACKAGES],
      @CURRENCY = [CURRENCY]
    from dbo.[UFN_MKTCREATIVE_GETVIEW](@CREATIVEID);

  return 0;