April 1, 2009 at 8:35 am
Hello ALL,
I have created a query in store procedure and wish to capture a case if that case falls into one of the columns. For example,
CaseID DECLEAREDDATE SOMATICMCCLEAREDDATE... DDS
A 1/1/2009 BO
B 1/3/2009 CT
If there is a case and that case names "A" is assigned to SomaticMCClearedDate to determine the outcome of this case. Then DEClearedDate and PsycMCClearedDate Should be empty. Or case B is assigned to DEClEAREDDATE to determine, and of course SomaticMCClearedDate and PsycMCClearedDate are empty. I would like to capture the case as single record "1". CASE ID IS PRIMARY KEY.
DDS is an office name, BO and CT are office abbreviation name. There are more than 2 fields name in the table, because there is no space for me to show, so I would like all to execuse me for such inconveniently.
I wish to have an outlook like below:
BOCLEARED CTCLEARED... TOTALCLEARED CLEAREDDATE DDS
1 1 1/1/2009 BO
1 1 1/3/2009 CT
------------------------------------
1 1 2
I wrote the codes for the outlook above, but somehow it can not capture the case falls in either column field name. Please take a look at my codes and point out what I need to add or eliminate in order to capture what I need to display.
WOULD ALL EXPERTS HELP ME?
Thank you
Joseph
April 1, 2009 at 8:52 am
Sorry Lynn,
I try to get much helps as possible.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply