February 6, 2009 at 12:31 pm
TABLE BO
DDS BOCLEARED BOCLEAREDDATE
BO 1 1/1/2009
BO 2 1/2/2009
BO 3 1/7/2009
Table CT
DDS CTCLEARED CTCLEAREDDATE
CT 2 1/1/2009
CT 3 1/2/2009
CT 2 1/7/2009
Table NH
DDS NHCLEARED NHCLEAREDDAT
NH 3 1/4/2009
NH 4 1/5/2009
NH 3 1/7/2009
Table VT
DDS VTCLEARED VTCLEAREDDATE
VT 1 1/5/2009
VT 2 1/6/2009
VT 3 1/7/2009
My question is:
I wish to display like the format below, but I also created a dropdownbox with multiple variables (string)such as BO, CT, NH, VT and ALL. For example, If I pick BO then it will display only BO office data and Total cases that BO office cleared at the column TOTALCLEARED. If I pick ALL then ALL office will display in one row and the total case were cleared for all offices at the column TOTALCLEARED.
PLEASE HELP ME >>>>>>>>PLEASE HELP ME
I wish to call this table below names TOTALCLEARED
BOCL CTCL NHCL VTCL TOTALCLEARED CLEAREDDATE
February 6, 2009 at 3:56 pm
http://www.sqlservercentral.com/Forums/Topic651773-338-1.aspx
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply