Read row in a CLR Stored Procedure Without output parameter

[culebrin]

Hi all,

I have a Stored Procedure without an output parameter but it returns one row always, this SP is called by another SP, so I need to store some of those columns in a variables of the first SP. How can I do that?

Please help.

P.D.: I have no access to the code of the first SP, and is a CLR, HEEELPPP!!!

[huangzhi]

Hope this code can help you.

1. Execute your first SP in query analyzer to show the columns list.

2. Create temporary table and the field must the same as first SP columns

create table #tmpTemp (
  Field1 varchar(255),
  Field2 varchar(255))

3. Insert the columns from first SP into temp table.

insert #tmpTemp exec sp_SP1

4. Store the column value.

declare @Field1 varchar(255)
select @Field1 = Field1 from #tmpTemp

[culebrin]

Hope this code can help you.

1. Execute your first SP in query analyzer to show the columns list.

2. Create temporary table and the field must the same as first SP columns

create table #tmpTemp (
  Field1 varchar(255),
  Field2 varchar(255))

3. Insert the columns from first SP into temp table.

insert #tmpTemp exec sp_SP1

4. Store the column value.

declare @Field1 varchar(255)
select @Field1 = Field1 from #tmpTemp

That do the trick! thanks man!