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 * , coalesce(AMIA.Item,AMIB.Item,AMIC.Item) FROM JD as I INNER JOIN amipartnumbers as AMIA ON AMIA.OEMItem = I.OEMPartNumber INNER JOIN amipartnumbers as AMIB ON AMIB.OEMItem = I.OEMPartNumber INNER JOIN amipartnumbers as AMIC ON AMIC.OEMItem = I.OEMSubNumber2 where coalesce(I.OEMPartNumber,I.OEMSubNumber,I.OEMSubNumber2)= '" & enterNumber & "'
|datetime in sql||6||28|
|SYNTAX PROBLEM -- adding another column into the stored procedure output||30||32|
|SQL - SP needs a little help||9||21|
|When I execute a stored proc with input parms using SQL Server 2008, I get the following error msg: Msg 8152 String or binary data would be truncated. Do you know how I can resolve this?||1||12|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
17 Experts available now in Live!