Transact-SQL: The Building Blocks to SQL Server Programming by Gregory A. Larsen

• Greg Larsen

  SSC-Insane

  Points: 20726

  More actions

  July 28, 2020 at 12:34 pm

  #3775365

  Comments posted to this topic are about the item Transact-SQL: The Building Blocks to SQL Server Programming by Gregory A. Larsen

  Gregory A. Larsen, MVP

• ktflash

  Ten Centuries

  Points: 1221

  More actions

  August 13, 2020 at 9:45 am

  #3780126

  Greg Larsen wrote:

  Comments posted to this topic are about the item Transact-SQL: The Building Blocks to SQL Server Programming by Gregory A. Larsen

   

  I might be wrong but is there a small thing missing on page 67 (PDF Page 75)?

  There is an "order by" for the attribut Make_Model, but the alias is not set for the Car.Make + '_' Car.Model

  Unless i am wrong:

  Is:

  select Car.Make + '_ ' + Car.Model

   

  should:

  select Make_Model  = Car.Make + '_ ' + Car.Model

  select Car.Make + '_ ' + Car.Model as Make_Model

  • This reply was modified 2 months, 2 weeks ago by  ktflash.

  I want to be the very best
  Like no one ever was

• Greg Larsen

  SSC-Insane

  Points: 20726

  More actions

  August 13, 2020 at 2:39 pm

  #3780267

  You are correct.   Thank you for pointing out this mistake.   I will see if that can get updated.

  Gregory A. Larsen, MVP