UFN_MKTVENDOR_GETVENDORSERVICES

create function dbo.[UFN_MKTVENDOR_GETVENDORSERVICES]
(
  @VENDORID uniqueidentifier
)
returns table
as
  return 
  (
    select 
      [MKTVENDORSERVICE].[ID],
      [MKTVENDORSERVICE].[SERVICEID],
      [MKTSERVICE].[NAME],
      [MKTSERVICECATEGORYCODE].[DESCRIPTION] as [CATEGORY],
      [MKTSERVICE].[SERVICECATEGORYCODEID]
    from 
      dbo.[MKTVENDORSERVICE]
    inner join
      dbo.[MKTSERVICE]
    on
      [MKTSERVICE].[ID] = [MKTVENDORSERVICE].[SERVICEID]
    inner join
      [MKTSERVICECATEGORYCODE]
    on
      [MKTSERVICECATEGORYCODE].[ID] = [MKTSERVICE].[SERVICECATEGORYCODEID]
    where 
      [MKTVENDORSERVICE].[VENDORID] = @VENDORID
  )