Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
(select distinct stuff((select ', ' + EQPMNT_NAME from EQUIPMENT WHERE EQPMNT_KEY=er.EQPMNT_KEY for xml path('')), 1, 2, '') As EQUIPMENT FROM EQUIPMENT_REQUEST er WHERE RQUST_KEY=70)
|SYNTAX PROBLEM -- adding another column into the stored procedure output||30||33|
|Getting max record but maybe not use Group BY||2||19|
|What query can i write to find where a function is||4||23|
|Using SQL Server 2008, how would you convert [datediff(day, dtcreated,getdate()) AS Age] into its equivalent if "dtcreated" is defined as varchar(10)?||14||23|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
28 Experts available now in Live!