Harald,

just two side notes:

1) Your CREATE VIEW statement doesn't run (it's erroneous).

2) If your'e on 2008, you may now use row constructors like this:

create view DIMSexes as

select * from (values(0,'Male','M')

...