store procedure

bretto kumar A posted at 05-Jul-08 08:46

hi i am using store procedure

shall i execute a procedure inseted of select query with in a proceture

like :

my first procedure is having a query like

select id from emp;

and my 2nd procedure  is

select top 3 NewsID from staff whereid Not IN ( exec spu_SdOtherNews ) order by id desc;

the above procedure is display error

plase help me


Click here to sign in and reply. You could earn money via our $500 contest just for being helpful.
  store procedure - bretto kumar A  05-Jul-08 08:46 8:46:19 AM
      Go For Select Query - Sanjay Verma  05-Jul-08 09:13 9:13:44 AM
      Try cursor - Sujit Patil  05-Jul-08 09:20 9:20:00 AM
      I just went through this - Jason S  05-Jul-08 09:31 9:31:51 AM
      Re : Store Procedure - Ashutosh Dhok  05-Jul-08 10:44 10:44:20 AM
      ans to sp - Umapathy Kaliaperumal  06-Jul-08 08:03 8:03:14 AM
      OPENROWSET - sundar k  06-Jul-08 01:39 1:39:34 PM
      Yes u can execute sp within sp - Arvind Kumar  07-Jul-08 01:12 1:12:21 AM
View Posts