How do I approach this?
You stated...
"Q2 will be populated only once and will be used as a
baseline for making database growth projections."
Then you stated...
"[a] If an entry exists in Q1 that does not exist in Q2,
it must be added to Q2
[b] If an entry exists in Q2 that does not exist in Q1,
it must be deleted from Q2"
This seems to be contradictory since you stated that "Q2
will be populated only once". Could you please explain?
-----Original Message-----
Hi
I hope someone can assist in getting my head around this
problem.
On worksheet "Server 2 Database Space Summary" I have a
QueryTable (lets
call this Q1) containing the following data
DB MB
ALLOCATED MB USED MB
FREE % FREE DB CREATED
BIDemo data only
20 12
7 37.44 2004/04/21 09:30
BIDemo log only
20 0
19 99.75 2004/04/21 09:30
master data and log
6 4
1 23.14 2004/04/05 14:46
model data and log
2 1
0 40.42 2004/04/05 14:46
sybmgmtdb data only
45 10
34 76.71 2004/04/06 14:13
sybmgmtdb log only
5 0
4 99.57 2004/04/06 14:13
sybsystemdb data and log
2 1
0 35.05 2004/04/05 14:46
sybsystemprocs data and log
120 58
61 51.52 2004/04/05
14:47
tempdb data and log
3 1
1 59.17 2004/05/04 16:22
Q1 will be refreshed every day. As you can see the data
represents data and
log usage for a particular data server, and the
possibility exists that
databases may be added or deleted.
On worksheet "Server 2 Projection Seed Values" I have
QueryTable (lets call
this Q2) containing the following data (a subset of Q2's
data)
DB MB
USED DB CREATED
BIDemo data only
12 2004/04/21
09:30
BIDemo log only 0
2004/04/21 09:30
Master data and log
4 2004/04/05
14:46
model data and log
1 2004/04/05
14:46
Sybmgmtdb data only 10
2004/04/06 14:13
Sybmgmtdb log only
0 2004/04/06 14:13
Sybsystemdb data and log 1
2004/04/05 14:46
Sybsystemprocs data and log 58
2004/04/05 14:47
Tempdb data and log
1 2004/05/04
16:22
Q2 will be populated only once and will be used as a
baseline for making
database growth projections.
What I need to accomplish here is;
[a] If an entry exists in Q1 that does not exist in Q2,
it must be added to
Q2
[b] If an entry exists in Q2 that does not exist in Q1,
it must be deleted
from Q2
Hope someone can help.
Kind Regards - Grant
.
|