I have two users logging into SQL Server and I want to use suser_sname() (if that is correct) to select data from within a view so that:
if the table data is say:
I want to create a view to:
if user1 then view all records where 0 in the final field
if user2 then view all records.
but how do you do that in a view? help :)