•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 327,522 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,295 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 526 | Replies: 1
 |
•
•
Join Date: Aug 2007
Posts: 20
Reputation: 
Rep Power: 1
Solved Threads: 1
Newbie Poster
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!!!
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!!!
•
•
Join Date: Feb 2008
Posts: 10
Reputation:
Rep Power: 1
Solved Threads: 2
Newbie Poster
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
3. Insert the columns from first SP into temp table.
4. Store the column value.
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
Hence Wijaya
www.ex-Soft.tk
www.ex-Soft.tk
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
DaniWeb Marketplace (Sponsored Links)
Linear Mode
Other Threads in the MS SQL Forum
- Previous Thread: Urgent - how to calculate rank in selected records in sql server 2000
- Next Thread: query mdf directly?
