jamespfisher
Last Activity: Oct 11 '11, 03:52 AM
Joined: Oct 6 '11
Location:
-
Thanks man but I don't have admin access...can't do any of the insert statement stuff, plus there are about 90,000 client records and a couple thousand drug types! Bugger. Have to work out another way to do it hmmm -
PIVOT or CASE? - Combining multiple rows into 1 row..
Hey all
I'm writing a large extract report on clients of a pharmacy and the drugs they are prescribed (maximum of 6 drugs in total).
Data structure of the drugs table looks like this:
Client_id, Drug_id, Is_Main_drug
123, 789, 1
123, 526, 0
124, 478, 0
124, 789, 0
124, 526, 1
124, 775, 0
124, 885, 0
124, 993, 0
My aim is to...
No activity results to display
Leave a comment: