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

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

ktflash Ten Centuries Points: 1397 More actions · Answer 1

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

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

Greg Larsen SSC-Insane Points: 20936 More actions · Answer 2

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

Gregory A. Larsen, MVP