Get Values from Lookup table and use in view / stored procedure, Sql Server

Get Values from Lookup table and use in view / stored procedure

Language: Layout:

View schema
Execution time: 0,06 sec, rows selected: 30, rows affected: 63, absolute service time: 0,22 sec, absolute service time: 0,22 sec

	Id	StatusId	Date	Name
1	1	1	NULL	Test
2	2	2	NULL	New
3	3	NULL	NULL	NULL
4	4	1	NULL	Test
5	5	2	NULL	New
6	6	NULL	NULL	NULL
7	7	1	NULL	Test
8	8	2	NULL	New
9	9	NULL	NULL	NULL
10	10	1	NULL	Test
11	11	2	NULL	New
12	12	NULL	27.06.2019 00:00:00	InProgress
13	13	1	NULL	Test
14	14	2	NULL	New
15	15	NULL	NULL	NULL
16	16	1	NULL	Test
17	17	2	NULL	New
18	18	NULL	NULL	NULL
19	19	1	NULL	Test
20	20	2	NULL	New
21	21	NULL	NULL	NULL
22	22	1	NULL	Test
23	23	2	NULL	New
24	24	NULL	27.06.2019 00:00:00	InProgress
25	25	1	NULL	Test
26	26	2	NULL	New
27	27	NULL	NULL	NULL
28	28	1	NULL	Test
29	29	2	NULL	New
30	30	NULL	NULL	NULL