Everything you need to know about backup and disaster recovery with AWS, for FREE!
SELECT EMPLOYEE.FIRST + ' ' + EMPLOYEE.LAST AS NAME, CLIENT.NAME AS CLIENT, PROJECT.NAME AS PROJECT, TASK.NAME AS TASK, [GROUP].NAME AS TEAM, TRANS.DATE, CUSTOMVALUE.VALUE FROM PROJECT INNER JOIN TRANS ON PROJECT.ID = TRANS.PROJECT INNER JOIN TASK ON TRANS.TASK = TASK.ID INNER JOIN EMPLOYEE ON TRANS.EMPLOYEE = EMPLOYEE.ID INNER JOIN [GROUP] ON TRANS.[GROUP] = [GROUP].ID LEFT OUTER JOIN CUSTOM INNER JOIN CUSTOMVALUE ON CUSTOM.ID = CUSTOMVALUE.CUSTOM INNER JOIN CUSTOMTEMPLATE ON CUSTOM.CUSTOMTEMPLATE = CUSTOMTEMPLATE.ID ON PROJECT.ID = CUSTOM.LINKID AND TASK.ID = CUSTOM.LINKID LEFT OUTER JOIN CLIENT ON TRANS.PROJECT = CLIENT.ID WHERE (CUSTOMVALUE.VALUE IS NOT NULL) ORDER BY NAME
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|databases from multiple applications - same instance||6||40|
|SQL Not Equal To not working as expected||11||30|
|SQLCMD question to have fields created as fixed length||2||36|
|learning MS SSIS||13||25|
Join the community of 500,000 technology professionals and ask your questions.