This snippet is not so much a snippet as a tip. It's goal is to make your Linux from Scratch experience easier by allowing you the freedom of being able to attach and detach to a screen session from your host computer. Of course you would go through the book and change the chroot command to suit your needs, but just bear in mind that the chroot command you will use may be different from the one I use.

By using screen, you can start a lengthy compile and then detach, go about your business and re-attach another time. I use it primarily when I have to start a compilation from one computer, then later from another machine located somewhere else. Combined with SSH, this can be real handy.

desktop ~ # screen -S clfs
desktop ~ # chroot "${CLFS}" /tools/bin/env -i \
>     HOME=/root TERM="${TERM}" PS1='\u:\w\$ ' \
>     PATH=/bin:/usr/bin:/sbin:/usr/sbin:/tools/bin \
>     /tools/bin/bash --login +h
root:/#

At any time, you can hit ctrl+a+d to detach. Then if you want to re-attach just type screen -r clfs and whamo, your right back where you left off.

Thanks again to ChrisS67 for helping me with my GCC problem (or me forgetting to install findutils) ;)

// sample "update from" sql statement

UPDATE 
        [Crm].[tbPartyLegalEntityData]
SET 
        [CompanyType] = ape.[CompanyType],
        [EmployeesCount] = ape.[EmployeesCount]
FROM 
        [Crm].[tbPartyLegalEntityData] p
INNER JOIN 
        App.[tbApplicationPersonEmployer] AS ape 
ON 
        ape.[Bulstat] = p.[Bulstat]
WHERE 
        ape.[Bulstat] <> '!' 
        AND [ape].[EmployeesCount] IS NOT NULL 
        AND [ape].[CompanyType] IS NOT NULL