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 |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2011-05-30 : 05:13:34
|
| i have a procedure that returns some valueshow can i query the output?exec sp_test 'a','b'i get 1234i want to ask if the output =4 than print 'yes' else 'no' |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-05-30 : 05:37:34
|
| declare @t table(col int)insert into @tEXEC sp_test 'a','b'select case when col=4 then 'yes' else 'no' end as status from @tMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
query procedures