USP_MKTSEGMENTATIONBUDGET_LOAD

CREATE procedure dbo.[USP_MKTSEGMENTATIONBUDGET_LOAD]
(
  @SEGMENTATIONID uniqueidentifier
)
as
  set nocount on;

  select
    [MKTSEGMENTATION].[MAILINGTYPECODE],
    [MKTSEGMENTATIONBUDGET].[BUDGETAMOUNT],
    [MKTSEGMENTATIONBUDGET].[FIXEDCOST],
    [MKTSEGMENTATION].[ACTIVE] as [SEGMENTATIONACTIVE],
    [MKTSEGMENTATIONBUDGET].[TSLONG],
    [MKTSEGMENTATIONBUDGET].[BASECURRENCYID],
    [MKTSEGMENTATIONBUDGET].[ORGANIZATIONBUDGETAMOUNT],
    [MKTSEGMENTATIONBUDGET].[ORGANIZATIONFIXEDCOST]
  from dbo.[MKTSEGMENTATIONBUDGET]
  inner join dbo.[MKTSEGMENTATION] on [MKTSEGMENTATION].[ID] = [MKTSEGMENTATIONBUDGET].[ID]
  where [MKTSEGMENTATIONBUDGET].[ID] = @SEGMENTATIONID;

  return 0;