<IMHO>Data is a mess.  That is the nature of the world.  Different people look at the same thing in different ways.  That is the nature of people.  I remember Grady...

On my browser, a link to "Using Apply" is https://technet.microsoft.com/en-us/library/ms175156%28v=sql.105%29.aspx, but the link in the article actually lands on "FROM (Transact SQL)"

If I understand correctly,

I expect you have a folder on your machine at 'C:\Users\whouston.SFI\Documents', unless the way you set up your machine is radically different than most machines I've met....

I found

$wintitle = $CurrentUser.Name + " " + $Host.Name + " " + $Host.Version

was sufficient to get the version to display the way I expected.