Thanks laurie!

There is something else but I think I could work it out. One of the problem was a thing that I didn't entered few row data, I left them NULL (for instance Father occupation, mother birthname - those data wasn't entered in original paper data that was given to me).

When I executed T-SQL

Select Father_FirstName + ' ' + Father_LastName + ' ' + Father_Occupation... AS Parent

Result was NULL

cause of NULL data in Father_Occupation field (column).

I will try, however, to work it out on my own. Thanks for the help.