Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jhon11
Starting Member
42 Posts |
 Posted - 2007-11-09 : 13:33:47
|
| Client require count of patients that were mailed on and prescribers were mailed to, for 1 year of period. I already have reports that gives uniquie counts per mailing,bu customer wants a total unique count for entire year.SO I have to generate the reports which have fileds of count of patients, count of prescribers, count of prescriber who billed medicaid, and count of patinet who billed medicaid...can anybody tell me how to procced on this issue...i m new to itLooking for reply. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-11-09 : 13:36:27
|
Without seeing or knowing ANYTHING about your environment, table layouts?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
jhon11
Starting Member
42 Posts |
Posted - 2007-11-09 : 14:05:13
|
| I know its hard to think without seeing data tables and enviroment...but the thing is ...if you can just give me a steps to procced than that would be great....can you tell me about quires on this...thxs... |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2007-11-09 : 14:23:09
|
| SureYou need a query per each thin and union it togetherWant to do some leg work and show use the detailsRead the hint link in my sigAnd chiiiiiiiiiiiiiiiilllllllllllHow are we suppose to help if we don't know?My esp usb is clogged right nowBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
|
|
|
HELLLpppp