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

• Greg Larsen

  SSC-Insane

  Points: 20961

  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

  Default port

  Points: 1400

  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 4 years, 10 months ago by ktflash.

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

  https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

• Greg Larsen

  SSC-Insane

  Points: 20961

  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