-
Jul 26th, 2013, 06:22 AM
#1
Thread Starter
Hyperactive Member
Query for inventory report
I have 2 tables I SQL DB
1.BedMaster - fiels(WardNo,BedNo,BedSts)
Data(G2,G1,A)
2.Admissions fileds(AdmNo,PatientNo,BedNo,AdmissionDate,DischargeDate)
Data(101,55,G1,21/07/2013,27/07/2013)
this type of data I m capturing in the tables
I want to generate a report for bed inventory on any date example on 28 JUl
I want to know how many beds were occupied on 25th jul
how can I make a query for it
I have the admissiondate and dischargedate for bedno
how can query to know about the date between this tow dates
-
Jul 26th, 2013, 10:28 AM
#2
Re: Query for inventory report
pseudo code but it should give you an idea:
select * from table1 where AdmissionDat >= 'start date' and eDischargeDate <= 'end date'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|