USE [SAM4]
GO

/****** Object:  UserDefinedFunction [dbo].[BillingAddressFunction]    Script Date: 03/26/2015 10:06:29 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[BillingAddressFunction]') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))
DROP FUNCTION [dbo].[BillingAddressFunction]
GO

USE [SAM4]
GO

/****** Object:  UserDefinedFunction [dbo].[BillingAddressFunction]    Script Date: 03/26/2015 10:06:29 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE FUNCTION [dbo].[BillingAddressFunction]()
RETURNS @RESULT Table
       ([LastBillDate]     datetime,
        [MatterCode]       varchar(17),
        [Addressee]        varchar(500),
        [Address]          varchar(500),
        [ID]               int            identity(1, 1))
AS
BEGIN
INSERT 
  INTO @RESULT
      ([LastBillDate],
       [MatterCode],
       [Addressee], 
       [Address])
 SELECT TOP (100) PERCENT MAX(BAD.[BillDate]) AS LastBillDate,
         BAD.[MatterCode],
         BAD.[Addressee],
         BAD.[Address]
 FROM     dbo.BillingAddressDate BAD
 GROUP BY BAD.[MatterCode],
         BAD.[Addressee],
         BAD.[Address]
 ORDER BY BAD.[MatterCode]
         
RETURN
END

GO





USE [SAM4]
GO

/****** Object:  View [dbo].[BillingAddress]    Script Date: 03/26/2015 10:05:48 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[BillingAddress]'))
DROP VIEW [dbo].[BillingAddress]
GO

USE [SAM4]
GO

/****** Object:  View [dbo].[BillingAddress]    Script Date: 03/26/2015 10:05:48 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[BillingAddress]
AS
SELECT     LastBillDate, MatterCode, Addressee, Address, ID
FROM         dbo.BillingAddressFunction() AS BillingAddressFunction_1

GO