Dynamic pivot with year as column

0

Please login or register to vote for this query.

(click on this box to dismiss)

Robotics Meta

Q&A about the site for professional robotic engineers, hobbyists, researchers and students

DECLARE @dtJoinDT AS NVARCHAR(20)


SELECT CAST((DATEDIFF(YEAR,CAST (@dtJoinDT AS DATE),GETDATE())) AS NUMERIC(18,3)) 'tenure'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results