Re: ntext/>8K as OUTPUT param
From: Jacco Schalkwijk (jacco.please.reply_at_to.newsgroups.mvps.org.invalid)
Date: 02/09/05
- Next message: Babu N: "Store procedure last executed ?"
- Previous message: Babu N: "store procedure last executed ?"
- In reply to: Steve Norman: "ntext/>8K as OUTPUT param"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 9 Feb 2005 12:39:36 -0000
You can create a temporary table in the calling stored procedure, and then
call the other stored procedure to fill this table. See for further
explanation:
http://www.sommarskog.se/share_data.html#temptables
-- Jacco Schalkwijk SQL Server MVP "Steve Norman" <SteveNorman@discussions.microsoft.com> wrote in message news:8704ABDF-1843-4EC3-BB2F-4C8AA9B12E86@microsoft.com... > Hi, > > I am trying to work out a way of returning some data from a SP to be used > in > a calling SP. There is a large amount of data, more than 8k, so I need to > use ntext but I cannot create a local var of type ntext to hold the output > before I can process it. > You may be wondering why I don't just return this data as a table from the > SP and insert it into a temp table and use that, but this stored procedure > will be being called from another SP and I have found that you cannot nest > INSERT INTO EXEC statements. I cannot turn the SP into a UDF as the SP is > very complex and needs to EXEC some sql which cannot be done in a UDF. > I have found some references to calling a COM .dll using sp_OA*, but I am > not sure this will help me in any way. > > Does anyone know what types I can return from the .dll that can be used in > a > SP that will help me? > > Sorry for the long question, but any help will be appriciated. > Steve
- Next message: Babu N: "Store procedure last executed ?"
- Previous message: Babu N: "store procedure last executed ?"
- In reply to: Steve Norman: "ntext/>8K as OUTPUT param"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
