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 |
|
Joe.B
Starting Member
5 Posts |
 Posted - 2003-03-28 : 12:23:30
|
Anybody know how to do this? I need to make update or even change the query statement during vb runtime.This is my ADO hierarchyrsCus_Sum Cus_Sum_ByProd Cus_Sum_ByProdSpec Cus_Sum_ByOrdersID thnx in advance |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-03-28 : 12:51:13
|
| You can change a command anytime you like.Just edit the commandText property and re-execute into another recordset object, or close the first one and re-execute into the same.Not sure what you are asking ....- Jeff |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-03-29 : 09:14:19
|
| Also look at WITH CUBE and WITH ROLLUP in Books Online, they offer ways to summarize data by each grouping value, and will generate grand totals for the entire set as well. |
|
|
|
|
|
|
Update child command in Data Environment