Solve your biggest tech problems alongside global tech experts with 1:1 help.
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'
Join the community of 500,000 technology professionals and ask your questions.