How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Scott Your Own Question

Scott
Scott, MIT Graduate
Category: Homework
Satisfied Customers: 3040
Experience:  MIT Graduate (Math, Programming, Science, and Music)
3546829
Type Your Homework Question Here...
Scott is online now
A new question is answered every 9 seconds

Can someone explain this sql statement to me ?......for example

Customer Question

Can someone explain this sql statement to me ?......for example just substitute anything in the columns I understand 'full outer join' and max and isnull........just when it is all together in one statement, I don't understand ?

select max(isnull(#templead.cnt,0)+isnull(#tempacctShared.cnt,0))(#tempacctShared.accountant_id,#templead.auditor_id)
from #templead full outer join #tempacctShared
on #templead.auditor_id= #tempacctShared.accountant_id
and isnull(accountant_id,auditor_id) not in (select accountant_id from #tempRez)
result > 1874

select max(isnull(#templead.cnt,0)+isnull(#tempacctShared.cnt,0))--,isnull(#tempacctShared.accountant_id,#templead.auditor_id)
from #templead full outer join #tempacctShared
on #templead.auditor_id= #tempacctShared.accountant_id
and isnull(accountant_id,auditor_id) in (select accountant_id from #tempRez)
result > 2499

Thanks
Submitted: 5 years ago.
Category: Homework
Expert:  Angela--Mod replied 5 years ago.
Hi, I’m a moderator for this topic and I wonder whether you’re still waiting for an answer. If you are, please let me know and I will do my best to find an Expert to assist you right away. If not, feel free to let me know and I will cancel this question for you. Thank you!
Customer: replied 5 years ago.

 

This has been answered....thanks

Related Homework Questions