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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Temp Tables/Memory Arrays

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-08-21 : 14:19:38
Daniel writes "On SqlServer6.5/7.0
Using Sp_OaCreate/Destroy etc One can create a custom
function whose output can be applied with a cusor one
record at a time.
Q1: How can one get at columns of
Sqlserver's data either tmp tables or permanent tables
Through memory addressing
Ie Array(c1 out,c2 out,c3 out,c4 out/IN) as Output
and alter the contents of c4?
Could this be done Using a Dump to memory mapped files?
Q2: How can one create an native custom aggregate function
that will work in the Sql query functions.

Does anyone have examplecode? Thanks ...DanP."
   

- Advertisement -