Customers with the total sales, who placed an order last year but not this year.

• nexus2vijay

  SSC-Addicted

  Points: 422

  More actions

  November 12, 2015 at 6:46 am

  #322301

  Thanks

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  November 12, 2015 at 7:06 am

  #1839362

  Duplicate post. No replies here please.

  http://www.sqlservercentral.com/Forums/Topic1735989-3077-1.aspx

  Also, we don't do people's homework for them. I don't need to practice basic T-SQL, and you won't learn anything by having someone else do your work for you.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass