UFN_DOWNLOAD_MKTPACKAGECREATIVE_FILE

create function dbo.[UFN_DOWNLOAD_MKTPACKAGECREATIVE_FILE]
(
  @ID uniqueidentifier
)
returns table
as

  -- Get the file from the creative if the id comes from MKTPACKAGECREATIVE or MKTPACKAGE

  return 
    select [MKTCREATIVE].[FILE] 
    from dbo.[MKTCREATIVE]
    left join dbo.[MKTPACKAGECREATIVE] on [MKTPACKAGECREATIVE].[CREATIVEID] = [MKTCREATIVE].[ID]
    left join dbo.[MKTPACKAGE] on [MKTPACKAGE].[CREATIVEID] = [MKTCREATIVE].[ID]
    where
      [MKTPACKAGECREATIVE].[ID] = @ID
      or [MKTPACKAGE].[ID] = @ID;