Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
SET mthid = CONVERT(varchar(10),DATEPART(year,activity)) + RIGHT('0' + RTRIM(DATEPART(MM,activity)),2) + CONVERT(varchar(10), emp_id);
Open in new window
Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.
If you are experiencing a similar issue, please ask a related question
Join the community of 500,000 technology professionals and ask your questions.
Join & Ask a Question
Join our community for more solutions or to ask questions.
For immediate help use Live now!