• Here the script that states "No column reference pulls data from multiple rows"

    create function aaaa() returns int

    as

    begin

    return (select SUM(a) from aza )

    end

    GO

    create table aza(a int,b as dbo.aaaa())

    create index idx_aza on aza(b) -- raise error: function is NON-DETERMINISTIC