MSSQL - Fix Error - An object or column name is missing or empty. For SELECT INTO

Msg 1038, Level 15, State 4, Line 1
An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.


watch this example on YouTube



To fix it replace
 SELECT FisrtName + N'' '' + LastName
  FROM [Company].[dbo].[Customers]

with
SELECT FisrtName + N' ' + LastName
  FROM [Company].[dbo].[Customers]