Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Need a Query to return
In table "Clinical Transactions" there field "proc_code" designates a type of transaction. The field "proc_chron" holds the date of the transaction. Field "patient_id" is for the patient who had the transaction. I need a list of which patients had both...- Cwisofsky
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Need a Query to return
I am trying to write a query to return to values. I have a database that has clinical_transactions and I need to know if a person received a proc_code = "SC20" and a proc_code = "SC01" transaction in a given time frame. I have tried inner joins, unions, and temp tables and...- Cwisofsky
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
