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.
Ok, fine that returns all of my active accounts. this result set gives me Device, PortNumber, Account, Units, XrefID now i need to call a second process that pass the Device and PortNumber to get me the final result. so the call looks like this:
SELECT * FROM ACCOUNTS WHERE STATUS='ACTIVE'
whats the best practice to do something like this and how do i go about it?
EXEC CalcConsumption [DEVICEFROMPREVIOUSQUERY], [PORTNUMBERFROMPREVIOUSQUERY, '12-22-2014','02-15-2015'
|Syntax error [Missing Operator] in query expression||7||31|
|Error running stored procedure||11||17|
|What query can i write to find where a function is||4||22|
|Using an Aggregate Function with a not exists in Sql Server 2012||10||21|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
14 Experts available now in Live!