Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I approach this?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What approach should I adopt ..... | Excel Discussion (Misc queries) | |||
Approach to Excel | Excel Discussion (Misc queries) | |||
What is the right approach? | Excel Worksheet Functions | |||
How to approach this? | Excel Discussion (Misc queries) | |||
Need new approach on forms I set up | Excel Programming |