UFN_BILLINGITEM_GETGRADELEVELENTRIES

            CREATE function dbo.UFN_BILLINGITEM_GETGRADELEVELENTRIES
            (
                @BILLINGITEMDATESID uniqueidentifier
            )
            returns table
            as
            return
            (
                select TOP 1000
                    BIPG.ID,
                    BIPG.GRADELEVELID,
                    BIPG.PRICE
                from
                    dbo.BILLINGITEMPRICEBYGRADELEVEL BIPG inner join dbo.GRADELEVEL GL on BIPG.GRADELEVELID=GL.ID
                where
                    BIPG.BILLINGITEMDATESID = @BILLINGITEMDATESID
                order by GL.SEQUENCE ASC

            )