Syntax on a join

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  October 24, 2015 at 2:37 pm

  #1835366

  Phil Parkin (10/24/2015)

  ---

  Why use DATEPART(), when you can use YEAR() for this?

  Yeah, why am I not using the Year Function.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Jeff Moden

  SSC Guru

  Points: 1004646

  More actions

  October 25, 2015 at 11:12 am

  #1835420

  Welsh Corgi (10/23/2015)

  ---

  Lynn Pettis (10/23/2015)

  ---

  Something like this?

  SELECT

  DATEPART(yyyy,tc.Call_Date) AS ArchiverYear

  FROM

  dbo.tblCall tc

  INNER JOIN PrismDataArchive.dbo.ArchiveDriver AS Arch

  ON Arch.ArchiveYear = DATEPART(yyyy,tc.Call_Date);

  That worked perfectly Lynn.

  Thanks.:-)

  Which table is the larger for the code above? I suspect that it's the dbo.tblCall table but need to know for sure before I make a recommendation.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)