Are you interested in becoming an AWS Certified Solutions Architect?
Discover a new interactive way of training for the exam.
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'
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.