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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-08 : 22:22:26
|
Peter writes "I need to extract a recordset from a SQL Server table, then use VBScript to manipulate each record to eventually produce a completely new recordset in memory. I then need to summarise the resultant Recordset using an SQL Statement like:
Select Sum([Transactions]) as [TotalTransactions] From.....etc.
The problem is that I cannot figure out how to use a recordset as a data source. I tried nested SQL subqueries but I cannot make this work as I need to manipulate the records in the first recordset using VBScript.
A temporary table (or an XML table) is a possibility but there are space constraints and I do not know how the server will react if 2 users try to create the temporary table at the same time
Can you help?" |
|
|
|
|
|
Executing an SQL query on a Recordset in memory