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 - 2006-03-06 : 08:58:18
|
| uitian writes "there are two tables 1 SO(fields are -SOID, DATE, etc.)2 DC (fields are -DCID, SOID, etc.)now there is one stored procedure e.g"proc1"that contains query (select SOID from SO where SOID not in (Select SOID from DC)),now i want to place (select SOID from DC) in another stored procedure(named "PROC2") and call that stored procedure in "PROC1"like (select SOID from SO where SOID not in ("PROC2"))how to do this" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-03-06 : 09:01:16
|
| It is not directly supported. You should make use of Temporary tableCretate table #temp(SOID,......)Insert into #temp EXEC PROC2Nowselect SOID from SO where SOID not in (Select SOID from #temp)MadhivananFailing to plan is Planning to fail |
 |
|
|
mmarovic
Aged Yak Warrior
518 Posts |
Posted - 2006-03-07 : 07:11:35
|
| ... or table function. |
|
|
|
|
|
|
urgent reply required