Microstrategy SQL

10 pts.
Tags:
Microstrategy
Data Table : IE9_RX_Fact Table 
Database Dictionary
--RX_FACT_ID - Unique record id for each transaction
--DSUPP_CD - Data Suppliers
--SUPP_LOC_CD - Site ID
--DSPNSD_LOC_CD - Pharmacy ID
--OPR_SRC_BTCH_NBR - TDW loading batch no.
--OPR_ROW_TYP_IND - Traceability for correction and regular supply
--OPR_SRC_SYS_ID - Data Type
 
Question:
 
 Write a query that will output the shop with highest number of supply for each supplier batch  311 to 314
 


Software/Hardware used:
SQL

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    We are happy to help you fix your code, and any errors you may get, we just won't do it for you if it's a class/homework assignment. 
    115,410 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: